# Connector function filter by null value

**URL:** <https://community.tulip.co/t/connector-function-filter-by-null-value/4087>\
**Category:** General\
**Tags:** connectors, null, connector\_function\
**Created:** [November 21, 2021, 9:29am UTC](https://community.tulip.co/t/connector-function-filter-by-null-value/4087 "2021-11-21T09:29:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Amit](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/amit/32/968_2.png) [@Amit](https://community.tulip.co/u/Amit)\
**Post date:** [November 21, 2021, 9:29am UTC](https://community.tulip.co/t/connector-function-filter-by-null-value/4087/1 "2021-11-21T09:29:34Z")

</div>

Hello,  
I created a connector function that filter a Tulip table by several fields and should return a single record, first field is text type and other 2 are boolean, I want to get all fields with values from app for the first 2 fields and where the 3rd field is blank (null value), how can I do that ?

 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/2/2f74fc80fa075773acbe7eeebcaa16b52148670e.png)  
What sould I write where the red arrow is ?

If I’m tring to write null or NULL I get the following error :

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

Kind regards,  
Amit Berku

---

<div class="post-metadata">

**Author:** ![Grant](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/grant/32/182_2.png) [@Grant](https://community.tulip.co/u/Grant)\
**Post date:** [November 21, 2021, 3:10pm UTC](https://community.tulip.co/t/connector-function-filter-by-null-value/4087/2 "2021-11-21T15:10:32Z")

</div>

Hi @Amit,

For values you’re checking if null, you can use the functionType `blank` and not pass in an `arg` to the filter! You can use `notBlank` as well if you want to return records that are not null!

Let us know if that helps.

---

<div class="post-metadata">

**Author:** ![Amit](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/amit/32/968_2.png) [@Amit](https://community.tulip.co/u/Amit)\
**Post date:** [November 21, 2021, 3:30pm UTC](https://community.tulip.co/t/connector-function-filter-by-null-value/4087/3 "2021-11-21T15:30:27Z")

</div>

Hi @Grant,  
Yes it helped, thank you very much, where can I find a list of those function types or any help on query parameters ?

Amit

---

<div class="post-metadata">

**Author:** ![Grant](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/grant/32/182_2.png) [@Grant](https://community.tulip.co/u/Grant)\
**Post date:** [November 21, 2021, 3:52pm UTC](https://community.tulip.co/t/connector-function-filter-by-null-value/4087/4 "2021-11-21T15:52:47Z")

</div>

Hi @Amit,

You can find this at `<your-instance>.tulip.co/apiDocs` in the description of the endpoint you’re using!