fetch invoices from quickbooks desktop with c# desktop

Asked Dec 02 '20 at 18:58

Active Dec 28 '22 at 15:36

Viewed 181 times

hi i am working on a program with c# that fetch all invoices from quickbooks company file, any ideas... i tried this code but i am not developping a web app

public ActionResult GetAllInvoice()
{
  List<Invoice> InvoiceList = new List<Invoice>();
  try
  {
    OAuth2RequestValidator oauthValidator = new OAuth2RequestValidator(Access_token);
    // Create a ServiceContext with Auth tokens and realmId
    ServiceContext serviceContext = new ServiceContext(RealmId, IntuitServicesType.QBO, oauthValidator);
    serviceContext.IppConfiguration.MinorVersion.Qbo = "23";
    serviceContext.IppConfiguration.BaseUrl.Qbo = QboBaseUrl;
    // Create a QuickBooks QueryService using ServiceContext
    QueryService<Invoice> querySvc = new QueryService<Invoice>(serviceContext);
    InvoiceList = querySvc.ExecuteIdsQuery("SELECT * FROM Invoice").ToList();
    return View(InvoiceList);
  }
  catch (IdsException ex)
  {
    return View(InvoiceList);
  }
  catch (Exception ex)
  {
    return View(InvoiceList);
  }
}

asked Dec 02 '20 at 18:58

Karim Saidana

What exception are you getting? What is your connections string? See folowing : https://stackoverflow.com/questions/28138326/how-to-query-some-data-out-of-a-quickbook-qbw-file – jdweng Dec 02 '20 at 19:06
Please post the errors you get. And your environment – hAcKnRoCk Dec 03 '20 at 05:12
The code you posted is for QuickBooks ONLINE, but your question says you're trying to query QuickBooks DESKTOP. Can you clarify which one is correct? They are two different platforms, with two _very_ different APIs. – Keith Palmer Jr. Dec 03 '20 at 14:04
i didnt find a code for the desktop one – Karim Saidana Dec 03 '20 at 20:09
Are you trying to connect to QuickBooks DESKTOP, or QuickBooks ONLINE? – Keith Palmer Jr. Dec 04 '20 at 16:32
quickbooks desktop – Karim Saidana Dec 07 '20 at 15:18

fetch invoices from quickbooks desktop with c# desktop

0 Answers0