I searched thru community posts and also Tulip support site but I’m unable to find how to use query parameters in connector functions.
I have a boolean field in table called ToolKit and i would like to filter data based on data in this column (which can be yes or no). I’m using then this query to populate Single select widget.
I’m probably doing something wrong. When I test query I get error:
“details” :“Unable to parse query string: extra param(s): ToolKit”
“errorCode”: “InvalidQueryString”
hello @ermingut, thanks for posting!! here’s a quick guide on how to filter the Table API Connector Function based on parameters.
run a Connector Function GEThttps://{{instance_name}}.tulip.co/api/v3/tables/$tableID$ and find the name for the field in your Table you’d like to filter by:
add Query Parameters to your Connector Function GEThttps://{{instance_name}}.tulip.co/api/v3/tables/$tableID$/records as such: filters.0.field = name of a Table column filters.0.arg = the value to compare to filters.0.functionType = comparison function
this will return the filtered Table Records based on the Filters provided. I would like to point out that you can add multiple filters by entering sequential filters and incrementing the index (where it’s set to 0 in the above example).