Forum Discussion

ChadCox's avatar
ChadCox
Qrew Trainee
7 years ago

API_GenResultsTable javascript field that contains url link not present

I am using API_GenResultsTable with jsa=1 to return a JS array of data. It has been working great, until now, when I notice I cannot get the URL for a link that shows up. My QB report will have a colu...
APIs and custom code
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
7 years ago
Read this section of the HTTP API docs which describes two different ways of building URLs to file attachments:

File Management
https://help.quickbase.com/api-guide/filemanagement.html

You will probably have to build a formula for the URL from the [Record ID#], and the known fid and version like this:
"https://quickbase.com/up/"; &
Dbid() &
"/a/r" &
[Record ID#] &
"/e8/v0"
In the above fid=8 and version=0.

Include this formula URL field in your clist when using API_GenResultsTable.