What Exactly is the ""Be The API"" Technique?
What Exactly is the "Be The API" Technique? Every now and then people ask if an API method exists to do some particular task. Occasionally, there is no method in the official API documentation that...
Forum Discussion
I just needed this function for some client work so I added this example:
Example 4: getExpandedURL(dbid, qid)
There is no published API method that will return the individual query parameters as an object given the dbid and qid. The only place this information is available is on the following page:
dbidTable?a=JBI_GenExpandedURL&qid=1
This function will return an object of all the constituent query parameters associated with a query given a dbid and qid.
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=407
Example 4: getExpandedURL(dbid, qid)
There is no published API method that will return the individual query parameters as an object given the dbid and qid. The only place this information is available is on the following page:
dbidTable?a=JBI_GenExpandedURL&qid=1
This function will return an object of all the constituent query parameters associated with a query given a dbid and qid.
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=407
Someone just liked my answer. But there is another reason to use the "Be The API" technique that was not mentioned in the post. If you want your script to iterate over all applications, tables, reports, queries etc there probably will not be a common API token setup so you can't use the API at all. You can however call all the other non-API methods to accomplish the same goal. This is especially important when asking another user to run a script from their account.
ASK: Please Give Me Your Formulas
https://community.quickbase.com/quickbase/topics/formula-parser-in-javascript#reply_18555784
ASK: Please Give Me Your Formulas
https://community.quickbase.com/quickbase/topics/formula-parser-in-javascript#reply_18555784