0

I have setup a unique key in hubspot company called "qb_id".

We have few keys and we need to check if there is a company against any of these keys. So I am using IN operator in Hubspot. Now this works fine as long as all values in the values section exist in the entity.

But I was expecting it to return what it has and ignore others. Is this how Hubspot API works?

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

    {
  "filterGroups": [
    {
      "filters": [
        {
          "values": [
            "80009B-1740523656",
           "800009-1714768680",
           "80001A-1740245396"
          ],
          "propertyName": "qb_id",
          "operator": "IN"
      }
      ]
    }
  ],
  "properties":["qb_id"]
}

In the given sample only one ID exists in companies table. But it does not return any result. If I remove dummy values and search with only one valid value, it return results correctly.

Improve this question
1
  • By my reading here (developers.hubspot.com/docs/guides/api/crm/…), your comma-separated list of "values" is being treated as AND (inclusive of all three), whereas it sounds like you want to do an OR (separate filter sets). Not sure how practical that will actually be for you, since there are limitations on how many separate filter sets can be specified. Commented Feb 26 at 0:57
Related questions
2
Search request for companies returns all companies instead the one by domain in HubSpot API
1
Hubspot Post Search API
1
Unable to create HubSpot Contact entry using hubspot-api-client
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.