Forum Discussion

PreetiSitaram_V's avatar
PreetiSitaram_V
Qrew Member
4 years ago

iteration through json data using python

Hi,
I am trying  to get all record from the Quickbase  using DO_query API using python.

but i am getting issue.

document_data=[]
Title=Description=Document=""
for i in data1.values():
values=i['table']['records']['record']
print(values)
[{'f': [{'@id': '6', '#text': 'Application Review'}, {'@id': '7', '#text': 'final demo'}, {'@id': '8', 'url': 'https://builderprogram-pverma.quickbase.com/up/bqscz87a5/g/rd/ei/va/Sample%20Document.docx', '#text': 'Sample Document.docx'}, {'@id': '3', '#text': '3'}], 'update_id': '1598972807556'}, {'f': [{'@id': '6', '#text': 'Track Record data'}, {'@id': '7', '#text': 'Track Record data'}, {'@id': '8', 'url': 'https://builderprogram-pverma.quickbase.com/up/bqscz87a5/g/rb/ei/va/Testing%20Guidelines-QuickBase.docx', '#text': 'Testing Guidelines-QuickBase.docx'}, {'@id': '3', '#text': '1'}], 'update_id': '1597820400040'}]

how can i get the data of 6,7,8


Thanks

------------------------------
Preeti Sitaram Verma
------------------------------