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