Is there a way to search for objects that are *missing* an association?

[linkfuse]

We've tried searching associations.contact "NOT_HAS_PROPERTY", but it returns an error.

Are there any other ways to do this?

[VPer]

Hey,

I have a similar problem, Could you resolve it?

Thanks

[linkfuse]

This is for tickets to contacts, specifically. Could that be the issue?

[RMones]

Hi @linkfuse and @dennisedson ,

with the current payload:

{
    "filters": [
        {
            "propertyName": "associations.contact",
            "operator": "NOT_HAS_PROPERTY"
        }
    ]
}

I've got also a 400 error.

{
"status": "error",
"message": "There was a problem with the request.",
"correlationId": "be038525-2741-4d36-8bef-ae151c4c820c"
}

You do also a POST request @dennisedson ?

Regards Ronald

[dennisedson]

@RMones 👀

This is a screenshot of my postman request (collapsed the results array)

 

[RMones]

Hi @dennisedson ,

Yes your example is working. But when change deals to tickets or a custom object ID, I've got a 400 http error..

Regards,

Ronald

[dennisedson]

Wow. So I somehow found the only one that works!  What are the odds....

I do not have a good answer for this.  I will do some research to see if this is working as designed.

[linkfuse]

Hi! Were you able to determine if this is working as designed?

Thanks for your help!

[dennisedson]

Working on it!  Promise to drop the answer here when I find out!

[linkfuse]

It does seem to make sense as trying to get to contacts or tickets through workflows / the UI doesn't work either (we tried to set a property if the association was missing).

Contacts have associated deals as criterion, and tickets have associated companies, but not contacts as criterion.

[TShma]

We had similar issues - we could get Deals using associations.contact but not vice versa. This thread helped us working it out. Actually, you can use the filter in Hubsport (in the relevant screen for your case: Deals, Tickets, Contacts, etc.),  looking for "Associated X" and check its options. If there is such a filter, and it has an option "is known/unknown" it means you can use the NOT_HAS_PROPERTY (or HAS). If not, try to work out with what options there are.
In our case of finding Contacts without associated Deals the only relevant filter is "num_associated_deals", and it has an option (in Hubspot app) "is known" so one can check for "NOT_HAS_PROPERTY".
Hope it helps. 

[RMones]

Awesome! Thx 🙂

[linkfuse]

Hmm... ours was part of a filterGroup. That must be the difference - we were searching for another known property as well, but we probably don't need to get that granular.

We'll try it again without the group.

Thanks!

[dennisedson]

@linkfuse 

How are you structuring your body?

I sent this request and it seems to work:

{
    "filters": [
        {
            "propertyName": "associations.contact",
            "operator": "NOT_HAS_PROPERTY"
        }
    ]
}