DerekEvans
3 years agoQrew Member
Are Builder Accounts Allowed to Use the Quickbase JSON RESTful API?
Good evening,
Do Builder Account users have access to the Quickbase JSON RESTful API? I'm trying to retrieve records from a table within an application I created using Python and the script is returning the following 401 error shown below.
I've included the Python code that I'm currently using down below. If anyone has any insight to offer on this issue, it would be greatly appreciated.
Thank you in advance for your time.
Returned Error Message:
Python Code:
------------------------------
Derek
------------------------------
Do Builder Account users have access to the Quickbase JSON RESTful API? I'm trying to retrieve records from a table within an application I created using Python and the script is returning the following 401 error shown below.
I've included the Python code that I'm currently using down below. If anyone has any insight to offer on this issue, it would be greatly appreciated.
Thank you in advance for your time.
Returned Error Message:
{
"message": "Unauthorized",
"description": "Invalid Authorization."
}
Python Code:
import json
import requests
headers = {
'QB-Realm-Hostname': '*****',
'User-Agent': 'Edge/13.1058',
'Authorization': '*****'}
body = {"from":"*****","select":[6,7,8,9],"where":"{6.EX.'2021'}","sortBy":[{"fieldId":6,"order":"ASC"}],"groupBy":[{"fieldId":6,"grouping":"equal-values"}],"options":{"skip":0,"top":0}}
r = requests.post('https://api.quickbase.com/v1/records/query',
headers = headers,
json = body
)
print(json.dumps(r.json(),indent=4))
------------------------------
Derek
------------------------------