Forum Academy Marketplace Showcase Pricing Features

Quickbooks Report JSON issue

I retrieved Quickbooks “Loss & Profit” report. JSON structure that I got is horrible. Instead of having “Name”:“value” JSON gives me a list of strings {“Name”, “value”, “Name”, “value”, “Name”, “Name”, “value”, “value”, “value”}. How to read this ?

https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/profitandloss

I tried to find an observation and differenciate values by position. For example I made an assumption that list always has same number of values and each value sits on the same position(e.g “Total Income” value is always on the 3rd position in the list). This is not stable and didn’t work.

report quickbooks

how can I make and use Generic JSON parser in Bubble ?