Skip to main content
Question

Calling API through Formula URL

  • July 10, 2020
  • 0 replies
  • 174 views
Hi ,

I'm new to quickbase and I'm currently using a formula URL button and i need to call API_GenResultsTable . Can anyone help me or guide me on how to process this or what to write in my formula text box .

Any help would be appreciated .
Thanks



------------------------------
Ashish Nair
------------------------------
This topic has been closed for replies.

  • AustinK
  • Quickbase Alumni
  • July 10, 2020
What are you wanting it to do? Without any information like that it will be tough.

This site has examples of what to do so you can look at that and see if the URL alternative that is listed will work for you. If you need help past that come back and explain what it is you are wanting to do exactly.

https://help.quickbase.com/api-guide/gen_results_table.html

Example:

https://target_domain/db/target_dbid?a=API_GenResultsTable&ticket=
auth_ticket&apptoken=app_token&qid=5&jht=1&query=
{'6'.CT.'done'}AND{'14'.CT.'USA'}&clist=7.8&slist=6&options=sortorder-A

If you don't understand the query string comparison operators like this, {'6'.CT.'done'}AND{'14'.CT.'USA'}, then go here and scroll down to "Query string comparison operators" learn about them. 

https://help.quickbase.com/api-guide/do_query.html
  • RyanStanford1
  • Quickbase Alumni
  • July 10, 2020
Ironically enough, I'm looking for specifically this type of functionality...

Ideally, I want the formula field to do an API_DoQuery of related child records (there should only be one in our situation) and get the filename of a file attachment field in the child record. Any assistance would be greatly appreciated.

I know I can do the DoQuery where the related parent is equal to ID... I'm just used to doing this more in JavaScript versus in a formula field.

------------------------------
Ryan Stanford
------------------------------
Terms & ConditionsAccessibility statement