QuickBooks API

 

The QuickBooks API is system that processes request from MoversSuite to MoversConnect. It works in conjunctions with the WebApiService to send and receive information as part of the QuickBooks Integration.

 

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.

 

Refer to the QuickBooks Integration topic for more information.

 

RELATED TOPICS:

MssApiService

QuickBooks Integration

WebApiService