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

Question

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

Answer 1

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))

Answer 2

Note: Please only comment if you have helpful things to say. I am fully aware that this should be a comment but I don't have enough reputation and I need help.

To Erich Wehrmann's answer:

Hello, thank you for your help. I have gotten here but I don't know how to actually get the data out of my table instead of just the field names in json format.

Do you know how I can actually get the data from my table?

import json
import requests

headers = {
    'QB-Realm-Hostname': 'my-realm.quickbase.com',
    'User-Agent': '{User-Agent}',
    'Authorization': 'QB-USER-TOKEN my-token',
    'Content-Type': 'application/json',
}

body = {
    'from': 'my-table-id', 'select': '[1,2]'
}
r = requests.get(
'https://api.quickbase.com/v1/fields?tableId=my-table-Id',
headers = headers,
json = body
)

print(json.dumps(r.json(),indent=4))