When your QuickBase table contains more than 150 fields, not all fields will be retrieved by Workato for performance optimization. For cases whereby your selected QuickBase table has massive, multi-layered tables and contains more than 150 fields, you would need to specify which fields you're interested in using in your recipe.
In this article, we'll talk about the output field list, which is applicable for QuickBase triggers. A largely similar concept for the QuickBase connector, the input field list, is covered in this other article, and is applicable for QuickBase actions.
For example, if I'm using a trigger and would like to retrieve data from a formula field "Attendee Name" and a composite address type field "Home Address", I'll type in the exact, case sensitive field names as in QuickBase:
And in the datatree, I'll be able to see the fields that make up the address field type, such as street, city, postal code, etc.
- When specifying fields, only provide one field name per line. Field names are case sensitive, hence ensure that field names provided are an exact match as the QuickBase field names.
- Any required fields in your QuickBase table should be displayed in the action by default. Required fields will not show up automatically if you fail to define them in the Input field list.
- Always refresh your recipe schema after changing the Input field list.
- There should NOT be additional spaces in front of or behind each field name