Get contacts/companies that don't have deals

[RIvanov]

Hey All,

Is there a way to get all contacts/companies that don't have deals?

Thanks in advance!

[JBeatty · Accepted solution]

Hi @RIvanov,

You can use the search api as follows: 

URL: 

https://api.hubapi.com/crm/v3/objects/company/search?hapikey=************************

Method: POST

Body:

{
    "filters":[
          {
            "propertyName": "num_associated_deals",
            "operator": "NOT_HAS_PROPERTY"
          }
        ]
      }
  }

This will work for both contact and companies.

[RIvanov]

Hey Joshua Beatty,

Thanks, that's exactly what I needed.

[RMones]

Hi @RIvanov ,

When i'm right you cannot filter on associated records. But maybe can the following workaround help you out:

Make a Workflow on a Deal that start when the Deal Name is known (or another property)

and then update a property all the contacts that are associated to this Deal.

Afther that you can filter on that property in the Contacts Filter Api.

Regards, Ronald

[dennisedson]

@Kevin-C , @JBeatty ,

Either of you have an idea on how to go about this?