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

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

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

Post by Jaymer »

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?
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
hpl123
Posts: 2579
Joined: Fri Feb 01, 2013 1:13 pm
Location: Scandinavia

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

Post by 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 :D.
Henrik (V8 Developer Ed. - Windows)
bssxfire8
Posts: 46
Joined: Fri Oct 02, 2015 11:41 pm

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

Post by 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.
Attachments
qb_restResponse.7z
(40.46 KiB) Downloaded 170 times
himanshu
Posts: 722
Joined: Thu Jun 19, 2008 6:24 am
Location: India
Contact:

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

Post by himanshu »

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
Post Reply