# Using Query Parameters in Connectors Functions

**URL:** <https://community.tulip.co/t/using-query-parameters-in-connectors-functions/2599>\
**Category:** Support, Troubleshooting, & Help\
**Tags:** connectors, query, parameters\
**Created:** [April 26, 2021, 6:43pm UTC](https://community.tulip.co/t/using-query-parameters-in-connectors-functions/2599 "2021-04-26T18:43:12Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ermingut](https://avatars.discourse-cdn.com/v4/letter/e/ee59a6/32.png) [@ermingut](https://community.tulip.co/u/ermingut)\
**Post date:** [April 26, 2021, 6:43pm UTC](https://community.tulip.co/t/using-query-parameters-in-connectors-functions/2599/1 "2021-04-26T18:43:12Z")

</div>

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”

Without parameters query works.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/d/d17a0ead0a1268a6750d4bf835997c0cda709e21.png)

I have connector to tulip tables.

Ermin

---

<div class="post-metadata">

**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\
**Post date:** [April 26, 2021, 9:31pm UTC](https://community.tulip.co/t/using-query-parameters-in-connectors-functions/2599/2 "2021-04-26T21:31:57Z")

</div>

hello @ermingut, thanks for posting!! here’s a quick guide on how to filter the Table API Connector Function based on parameters.

1. run a Connector Function **GET** `https://{{instance_name}}.tulip.co/api/v3/tables/$tableID$` and find the **name** for the field in your Table you’d like to filter by:  
 ![Screen Shot](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/d/d3e51787df89a466591b8d4196e6753696190f5d.jpeg)
2. add Query Parameters to your Connector Function **GET** `https://{{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`  
 ![Screen Shot 1](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/8/81d89a76b8d867569495617682391497ed59ff35.jpeg)

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).

for further resources, I’d recommend looking at:

- [How to Use the Table API | Tulip Help Center - Support for Building Manufacturing Apps](https://support.tulip.co/en/articles/3983173-how-to-use-the-table-api)

- https://{{instance\_name}}.tulip.co/apiDocs

does this answer you question?? let us know!!

---

<div class="post-metadata">

**Author:** ![ermingut](https://avatars.discourse-cdn.com/v4/letter/e/ee59a6/32.png) [@ermingut](https://community.tulip.co/u/ermingut)\
**Post date:** [April 27, 2021, 1:56pm UTC](https://community.tulip.co/t/using-query-parameters-in-connectors-functions/2599/3 "2021-04-27T13:56:43Z")

</div>

Hi.

Thank you @gio. This is exactly what I need. I tried multiple filters and works beautifully.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/a/ada8bd544f9f272a827086d1c0ed78db598bdb9a.png)

---

<div class="post-metadata">

**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\
**Post date:** [April 27, 2021, 2:00pm UTC](https://community.tulip.co/t/using-query-parameters-in-connectors-functions/2599/4 "2021-04-27T14:00:05Z")

</div>

happy to hear it @ermingut!!

it would be awesome if you could share the use case for which you’re using this in [Show and tell - Tulip Community](https://community.tulip.co/c/show-and-tell/9).

---

<div class="post-metadata">

**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\
**Post date:** [April 27, 2021, 2:00pm UTC](https://community.tulip.co/t/using-query-parameters-in-connectors-functions/2599/5 "2021-04-27T14:00:08Z")

</div>


