Forum Discussion

AlexanderBerezo's avatar
AlexanderBerezo
Qrew Member
5 years ago

Can't use pandas.read_json() with new QB RESTFul API

Hi,  I try to use inbuilt pandas read_json with new RESTFull QB API, but it doesn't work, even though I tried every orient and typ.  https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas...
APIs and custom code
RichardChagnon's avatar
RichardChagnon
Qrew Trainee
5 years ago
Hi Alexander,
Did you find a solution for this?   I  am working on a similar problem of writing to a csv file, and the key for me is that the response is a nested dictionary as is the data part. So a couple of  for loops works.

for record in r.json()[data]:
       for item in record:  # build csv line


I hope this helps

------------------------------
Richard Chagnon
Chicago IL
------------------------------