Is there a way to create a recursive query in QuickBase to return all items from a table with relationships that may be several layers deep?
I know there isn't a way to to do recursion natively in Quickbase. I have a bunch of recipes that nest 5 levels deep. I want to create a query to flatten the structure. Is there a dirty way to do ...
Part 1 > We only have 500 API calls a day, so this can't get too dirty.
You can avoid calling API_DoQuery altogether by making your queries through the native action ?a=q and requesting CSV output instead of HTML using &opts=csv.
Here is a query of the Formula Function Reference table manually applied through the console:
The script above makes use of a QuickBase function CSVToArray() which is located in in /js/_packed/common.packed.js so you don't have to load a CSV parsing script yourself.
Part 2 The problem can be solved with script using one table and a script that makes multiple queries. It would require specific knowledge of your fields and current tables.
