# Searching for null values

**URL:** <https://community.hubspot.com/t/searching-for-null-values/72200>\
**Category:** APIs & Integrations\
**Created:** [January 4, 2023, 3:24pm UTC](https://community.hubspot.com/t/searching-for-null-values/72200 "2023-01-04T15:24:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![PAtlan](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/patlan/32/42298_2.png) [@PAtlan](https://community.hubspot.com/u/PAtlan)\
**Post date:** [January 4, 2023, 3:24pm UTC](https://community.hubspot.com/t/searching-for-null-values/72200/1 "2023-01-04T15:24:56Z")

</div>

I imported a bunch of empty notes using an excel spreadsheet, and I need to clean up the database for my users. Because of the import method, both the owner ID and body are “null”, so it should be easy to flag the proper ids …

As an initial trial, I was trying to retrieve the note ids using a search API call on notes from the documentation (or from postman), with something akin to “hubspot\_owner\_id” EQ null, except I can’t seem to express this particular condition …

Has anyone tried, or have a clever workaround?

Thanks!

---

<div class="post-metadata">

**Author:** ![Jaycee\_Lewis](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jaycee_lewis/32/61352_2.png) [@Jaycee\_Lewis](https://community.hubspot.com/u/Jaycee_Lewis)\
**Post date:** [January 9, 2023, 9:01pm UTC](https://community.hubspot.com/t/searching-for-null-values/72200/2 "2023-01-09T21:01:14Z")

</div>

Hey, @PAtlan 👋 Thanks for reaching out! Were you able to get this resolved?

I’ll add my example here in case other community members need a solution in the future:

- [Search operator](https://developers.hubspot.com/docs/api/crm/search#specify-returned-properties:~:text=use%20the%20following-,operators,-in%20a%20filter) used  
`NOT_HAS_PROPERTY — Doesn't have a value for the specified property​`

- Postman request

- Response

Have fun building! — Jaycee