Forum Discussion

AshishNair's avatar
AshishNair
Qrew Member
5 years ago

Calling API through Formula URL

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
------------------------------
APIs and custom code
Formulas and functions
  • AustinK's avatar
    AustinK
    Qrew Commander
    5 years ago
    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's avatar
    RyanStanford1
    Qrew Captain
    5 years ago
    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
    ------------------------------