QuickBooks Online
The QuickBooks online connector is based on CData's connector. Please see their documentation for additional help: https://cdn.cdata.com/help/RNJ/ado/default.htm
Origin
Inserting Invoices
Inserting and Invoice requires two fields: CustomerRef and LineAggregate.
LineAggregate can be tricky to populate. It requires XML. Here is an example:
<Line><Amount>0.01</Amount><DetailType>SalesItemLineDetail</DetailType><SalesItemLineDetail><ItemRef>2</ItemRef></SalesItemLineDetail></Line> <Line><Amount>0.02</Amount><DetailType>SalesItemLineDetail</DetailType><SalesItemLineDetail><ItemRef>3</ItemRef></SalesItemLineDetail></Line>
Errors
[3100] message=DispatcherError; errorCode=003100; statusCode=401.
Make sure your "Company Id" on the QuickBooks Connection does NOT contain spaces. This error message tells you that your access token is no longer valid. Edit your QuickBooks Connection and re-authenticate.