Search code examples
quickbooksintuit-partner-platformquickbooks-online

What am I doing wrong in this QBO v3 Reports API query?


When I use the following query, I get a good response (with only the first 5 days of May, so apparently the default is not 'This Fiscal Year-to-date' as the documentation suggests, but I digress):

https://quickbooks.api.intuit.com/v3/company/0123456789/reports/CustomerSales

When I add parameters, I get an oauth exception. For example:

https://quickbooks.api.intuit.com/v3/company/0123456789/reports/CustomerSales?start_date='2013-01-01'&end_date='2014-05-06'

Gives me this:

{
 "Fault": {
  "type": "AUTHENTICATION", 
  "Error": [
   {
    "Message": "message=Exception authenticating OAuth; errorCode=003200; statusCode=401", 
    "code": "3200"
   }
   ]
 }, 
 "requestId": "[redacted]", 
 "time": "[redacted]"
}

This gives me the same result:

https://quickbooks.api.intuit.com/v3/company/0123456789/reports/CustomerSales?date_macro='This Fiscal Year'

So does this:

https://quickbooks.api.intuit.com/v3/company/148305798/reports/CustomerSales?accounting_method='Accrual'

I figure I'm missing something small. I'm not changing any of the headers or any of the other request details...just the url.

I tried without the single quotes around the dates and other params too.

What am I breaking?


Solution

  • Are you including the data to the right of the ? in the URL in the "base" string and are you sorting it with the other parameters?