I dont see how Aware can process this JSON data from Quickbooks

Jaymer

visit this page: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/balancesheet

scroll the right side (in black) to see the JSON data returned when you run a report via the API

I don't see how (in JSON) that data is going to get processed by Aware.
Each nested Rows,Row,Rows,Ros,Coldata, etc. is a BO in Aware. And some elements are not correctly named for aware to insert them into a field.
I think its a lost cause.

Any ideas?

hpl123

I think maybe Awaresoft has a quickbooks plugin you can use (not 100% sure it was quickbooks). If not, they can develop one for you so nothing is a lost cause in Aware 😃.

bssxfire8

Because I was bored for a minute earlier I was curious just what aware would do with the response.
I've attached a sample bsv and a csv of the data ColData table from after I made the api call.
It is beyond complicated on the response's Business Object relationship structure and I kind just threw everything at it attribute wise to see what stuck but it worked to at least a decent degree.

If this is absolute garbage just let me know and I'll delete it.

qb_restResponse.7z

40.46kB

qb_restResponse.7z

40.46kB

himanshu

We have worked with QuickBooks recently and done integration also, you can PM me if there is specific goal you want to achieve.