pythonquickbase

Is there a way to get access to QuickBase tables using python API?


I'm trying to read the table contents in Quick Base. As of now I'm downloading the files from Quickbase in CSV format and reading them from the python pandas package. Is there a way to get access to QuickBase tables using python API? So that we can avoid the process of downloading the files and directly reading the table contents directly from QuickBase


Solution

  • Yes, can you get table data via the Quickbase REST API: https://developer.quickbase.com

    There isn't a directly supported SDK, but it's fairly simple to interact with this API using the Python json and request libraries to make a POST call.

    import json
    import requests
    
    headers = {
        'QB-Realm-Hostname': '{QB-Realm-Hostname}',
        'User-Agent': '{User-Agent}',
        'Authorization': '{Authorization}'
    }
    body = {}
    r = requests.post(
    'https://api.quickbase.com/v1/records/query', 
    headers = headers, 
    json = body
    )
    
    print(json.dumps(r.json(),indent=4))