Building URL to download CSV

Question

I'm building some automations outside of Quickbase and have found the best way to pull data has been to build a URL using a usertoken that pulls data into a CSV that I process externally with python.&nbsp;For previous tables I've used this basic format:qb URL: https://company.quickbase.com/db/dbID?a=q&amp;qid=34
url = 'https://company.quickbase.com/db/dbID(from original URL)?a=api_genresultstable&amp;qid=34(from original URL)&amp;options=csv&amp;usertoken=private_token'
However, when i build a URL call based on the URL below it pulls data from the wrong table... WHY.
https://company.quickbase.com/db/dbID?a=q&amp;qid=31
​Would love some insight on how to adjust my URL call to have it pull the correct data.&nbsp;p.s. this works as long as I'm already signed in, but I need to do this when I'm not necessarily signed in:
https://company.quickbase.com/db/dbID&amp;opts=csvThanks,&nbsp;Ed------------------------------Edwin Reik------------------------------

blakeharrison · Answer

I think the better option might be for you to look into using the API. The URLs that you're using are meant for access via the UI, so probably not the best way for you to grab information via an automated method.

QuickBase API

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------

edwinreik · Answer

Thanks for the response Blake.&nbsp;The URL calls work fine with my python automation but I'm open to a more robust option. I just need to automate pulling the table and saving it so I can manipulate the data.&nbsp;I've been looking here: https://help.quickbase.com/api-guide/gen_results_table.html#URL_AlternativeWhat would the API call look like?&nbsp;------------------------------Edwin Reik------------------------------

blakeharrison · Answer

I'd suggest you look into querying your Quickbase data directly utilizing the API. If you're working with Python, you can use the REST API here: https://developer.quickbase.com/operation/runQuery&nbsp;Select the Code Samples tab and select Python from the drop-down and you'll get this code as an example query:
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))
​------------------------------Blake Harrisonbharrison@datablender.ioDataBlender - Quickbase Solution ProviderAtlanta GA404.800.1702 / http://datablender.io/------------------------------

edwinreik · Answer

When I try this and print(r.url) I get the signin page. This is what happened when i tried to write my API request which i believe means I'm not getting in.&nbsp;
If you're able to support with building a URL that works I'd be satisfied.&nbsp;'https://eagleview.quickbase.com/db/bpw3pr8nu?a=q&amp;qid=31' + '&amp;opts=csv' works when I'm signed in.'https://eagleview.quickbase.com/db/bpw3pr8nu?' + 'a=api_genresultstable&amp;qid=31&amp;options=csv&amp;usertoken=SECRET' works when I'm not signed in, but downloads the wrong table!&nbsp;
'https://eagleview.quickbase.com/db/bpw3pr8nu?a=api_genresultstable&amp;qid=31&amp;usertoken=*secret*' (no mention of options csv) opens a page with the correct table present, but doesn't download the csv. This works when I'm not signed in.when I do the same as above but add '&amp;options=csv' it downloads a CSV, but not the one that is being shown (same wrong one as mentioned above)...&nbsp;What am I missing that can specify what the url is grabbing

​------------------------------Edwin Reik------------------------------

blakeharrison · Answer

If you use the last URL you mention and include the CSV option and it's downloading the wrong fields, I'm going to guess it's downloading the default fields for that table. Most likely, you'll need to include the 'clist' parameter to identify the fields you want to download.------------------------------Blake Harrisonbharrison@datablender.ioDataBlender - Quickbase Solution ProviderAtlanta GA404.800.1702 / http://datablender.io/------------------------------

Forum Discussion

Building URL to download CSV

7 Replies