Discussions

Expand all | Collapse all

iteration through json data using python

  • 1.  iteration through json data using python

    Posted 27 days ago
    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
    ------------------------------


  • 2.  RE: iteration through json data using python

    Posted 26 days ago
    Hi Preeti. I'm certainly not a Python dev, but you might consider checking our new RESTful APIs which may be more natural for you. https://developer.quickbase.com

    ------------------------------
    Harrison Hersch
    ------------------------------