TECHNICAL NOTE

You can query tables on an active QuickBooks instance through the use of two API end points, allowing you to query and view table data created through the QuickBooks Integration. The following API calls are available to query QuickBooks data.

XML QuickBooks API Query

http://[server]/[api]/quickbooks/query/[SQL Statement]

Example:

http//myserver:9999/api.aspx/quickbooks/query/select * from vendor where id=’56’

Output: Query data in XML format listing vendors with an id of “56”

JSON QuickBooks API Query

http://[server]/[api]/quickbooks/queryjson/[SQL Statement]

Example:

http//myserver:9999/api.aspx/quickbooks/queryjson/select * from vendor where id=’56’

Output: Query data in JSON format listing vendors with an id of “56”

Upon a successful call, the data is returned to your screen. You can copy and paste this data into a viewer to verify the data.