Forum Discussion

DerekEvans's avatar
DerekEvans
Qrew Member
2 years ago

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:

{
"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
------------------------------
No RepliesBe the first to reply