visit this page: https://developer.intuit.com/app/develo ... lancesheet
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?
I dont see how Aware can process this JSON data from Quickbooks
I dont see how Aware can process this JSON data from Quickbooks
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL
Re: I dont see how Aware can process this JSON data from Quickbooks
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 .
Henrik (V8 Developer Ed. - Windows)
Re: I dont see how Aware can process this JSON data from Quickbooks
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.
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.
- Attachments
-
- qb_restResponse.7z
- (40.46 KiB) Downloaded 179 times
Re: I dont see how Aware can process this JSON data from Quickbooks
We have worked with QuickBooks recently and done integration also, you can PM me if there is specific goal you want to achieve.
From,
Himanshu Jain
AwareIM Consultant (since version 4.0)
OS: Windows 10.0, Mac
DB: MYSQL, MSSQL
Himanshu Jain
AwareIM Consultant (since version 4.0)
OS: Windows 10.0, Mac
DB: MYSQL, MSSQL