CRM API | Deals | Search - Property is unknown

I’m trying to search the deals with a property empty so I can fill with a computed data.

I’m calling

https://api.hubapi.com/crm/v3/objects/deals/search

And I tryied the following filters:

filterGroups: [{filters: [{value: null, propertyName: ‘dia_da_semana_data_de_criacao’, operator: ‘EQ’}]}]

filterGroups: [{filters: [{value: ‘’, propertyName: ‘dia_da_semana_data_de_criacao’, operator: ‘EQ’}]}]

But I aways end with the message: problem: operator EQ requires a value

I changed the operator but get the same message.

Hi @FPerardt !

Welcome to the Community!

I would suggest using the NOT_HAS_PROPERTY and removing the value altogether. This will check to see if the property has a value assigned to it.

Example

{
 "filterGroups":[
 {
 "filters":[
 {
 "propertyName": "dia_da_semana_data_de_criacao",
 "operator": "NOT_HAS_PROPERTY"
 }
 ]
 }
 ]
 }