topic Re: [Hubspot API] How do you use IN filter operator? in APIs & Integrations

[Hubspot API] How do you use IN filter operator?

CSwart — Wed, 20 Oct 2021 09:09:40 GMT

I am trying to use an IN Filter for getting all deals from a list of deal_ids when trying this I get an invalid JSON error:

HTTP response body: { "status":"error", "message":"Invalid input JSON on line 1, column 42: Cannot deserialize instance of `java.lang.String` out of START_ARRAY token", "correlationId":"dd4d7def-6cc8-4b7e-a48d-658e0330e8cd" }

I am using the Python API as such to do the IN filter operation with a list of deal_id strings in deal_ids:

domain_filter = hubspot.crm.deals.models.Filter( property_name="id", operator="IN", value=deal_ids ) filter_group = hubspot.crm.deals.models.FilterGroup( filters=[domain_filter] ) public_object_search_request = hubspot.crm.companies.models.PublicObjectSearchRequest( filter_groups=[filter_group] ) deal_results = self.hubspot_api_client.crm.companies.search_api.do_search(public_object_search_request=public_object_search_request)

This is what the dict repr of public_object_search_request looks like:

{'after': None,
 'filter_groups': [{'filters': [{'operator': 'IN',
                                 'property_name': 'id',
                                 'value': ['3651752129', '3741754830']}]}],
 'limit': None,
 'properties': None,
 'query': None,
 'sorts': None}

Would love to see a working IN operator example to get it working for myself.

Re: [Hubspot API] How do you use IN filter operator?

Teun — Wed, 20 Oct 2021 17:37:56 GMT

Hi @CSwart ,

I checked the Deals docs, and I think you can retrieve the deals with two endpoints.

Batch read (inputs= should get your array of ID's):

import hubspot from pprint import pprint from hubspot.crm.deals import BatchReadInputSimplePublicObjectId, ApiException client = hubspot.Client.create(api_key="YOUR_HUBSPOT_API_KEY") batch_read_input_simple_public_object_id = BatchReadInputSimplePublicObjectId(properties="dealname", inputs=[{"id":"3651752129"},{"id":"3741754830"}]) try: api_response = client.crm.deals.batch_api.read(archived=False, batch_read_input_simple_public_object_id=batch_read_input_simple_public_object_id) pprint(api_response) except ApiException as e: print("Exception when calling batch_api->read: %s\n" % e)

Search:

import hubspot from pprint import pprint from hubspot.crm.deals import PublicObjectSearchRequest, ApiException client = hubspot.Client.create(api_key="YOUR_HUBSPOT_API_KEY") public_object_search_request = PublicObjectSearchRequest(filter_groups={"filters":[{"value":"3741754830","propertyName":"hs_object_id","operator":"EQ"},{"value":"3651752129","propertyName":"hs_object_id","operator":"EQ"}]}, sorts="dealname", query="string", properties="dealname", limit=10, after=0) try: api_response = client.crm.deals.search_api.do_search(public_object_search_request=public_object_search_request) pprint(api_response) except ApiException as e: print("Exception when calling search_api->do_search: %s\n" % e)

OR:

import hubspot from pprint import pprint from hubspot.crm.deals import PublicObjectSearchRequest, ApiException client = hubspot.Client.create(api_key="YOUR_HUBSPOT_API_KEY") public_object_search_request = PublicObjectSearchRequest(filter_groups={"filters":[{"value":"[\"3651752129\", \"3741754830\"]","propertyName":"hs_object_id","operator":"IN"}]}, sorts="dealname", query="string", properties="dealname", limit=10, after=0) try: api_response = client.crm.deals.search_api.do_search(public_object_search_request=public_object_search_request) pprint(api_response) except ApiException as e: print("Exception when calling search_api->do_search: %s\n" % e)

Re: [Hubspot API] How do you use IN filter operator?

CSwart — Thu, 21 Oct 2021 10:00:24 GMT

Thanks for the helpful solution ideas I am going to try them out today!

Re: [Hubspot API] How do you use IN filter operator?

tb1024 — Fri, 11 Feb 2022 13:44:53 GMT

Teun,

It seems that your last example doesn't work for me, I am getting this error:

{"status":"error","message":"Invalid input JSON on line 9, column 17: Cannot construct instance of `com.hubspot.inbounddb.publicobject.core.v3.search.Filter`, problem: operator IN requires values","correlationId":"c0f97d27-fd9c-4e21-a476-ed9ee20a2000"}

This is what I have in Postman. Any input would highly be appreciated. Thank you.

Re: [Hubspot API] How do you use IN filter operator?

tb1024 — Fri, 11 Feb 2022 14:00:26 GMT

Teun,

For future reference, it looks like you have a typo in your sample. It should be "values" (plural) instead of "value". Also, it is looking for a string[] (see picture).

Re: [Hubspot API] How do you use IN filter operator?

mooney — Tue, 15 Feb 2022 00:17:58 GMT

HI @Teun

Will you confirm you sucessfully got your second search option from you reply using the IN operator working outside of Postman? HubSpot api returns: "...problem: operator IN requires values." when using the following filter & operator:

{ "propertyName": "dealstage", "operator": "IN", "values": [8464307, 8464306] }

We are able to get it working in Postman and would like to know if their is a bug with the following node package:

@hubspot/api-client v6.0.1

api call:

const apiResponse = await hubspotClient.crm.deals.searchApi.doSearch(publicObjectSearchRequest);

Re: [Hubspot API] How do you use IN filter operator?

Teun — Tue, 15 Feb 2022 09:09:46 GMT

Thanks for the update!

Re: [Hubspot API] How do you use IN filter operator?

Petercopter — Tue, 22 Mar 2022 18:50:45 GMT

Thanks for puzzling this out. Here's an example that works in Ruby. Note the VALUES key

{ filterGroups: [ { filters: [ { operator: 'IN', propertyName: 'dealstage', values: ['closedlost', 'closedwon'] } ] } ], sorts: [{ direction: 'ASCENDING', propertyName: 'dealname' }] }

Re: [Hubspot API] How do you use IN filter operator?

BSeslija — Thu, 31 Mar 2022 14:52:06 GMT

Hi! I am trying to filter search results and get contacts data based on date created. I added this to request body:

{
 "filters": [
  {
   "propertyName": "createdate",
   "operator": "IN",
   "values": ["2022-03-01T00:00:29.962Z", "2022-03-31T00:00:29.962Z"]
   }
  ]
}

But I always get There was a problem with the request in the response.

What am I doing wrong?

Re: [Hubspot API] How do you use IN filter operator?

BSeslija — Thu, 31 Mar 2022 15:01:58 GMT

Hi! I am trying to filter contact data based on date created. I have added this to request body:

{
 "filters": [
 {"propertyName": "createdate",
  "operator": "IN",
  "values": ["2022-03-01", "2022-03-31"]
 }]
}

But I always get There was a problem with the request as a response.

What am I doing wrong?

Re: [Hubspot API] How do you use IN filter operator?

mooney — Thu, 31 Mar 2022 15:31:23 GMT

are you able to filter using any other values other than closedlost and closedwon such as custom stages?

Re: [Hubspot API] How do you use IN filter operator?

SNowak6 — Wed, 30 Nov 2022 09:32:31 GMT

Hi! I have a problem when trying to search products using custom property. When I use "EQ" operator I'm getting a product as a result:

{
  "filterGroups": [
    {
      "filters": [
        {
          "value": "VKBA 1355",
          "propertyName": "litium_productarticlenumber",
          "operator": "EQ"
        }
      ]
    }
  ],
  "properties": [
    "litium_productarticlenumber"
  ]
}

But when I try to do same search (and search with more values) using "IN" operator I'm not getting anything:

{
  "filterGroups": [
    {
      "filters": [
        {
          "values": [ "VKBA 1355", "VKBA 3434" ],
          "propertyName": "litium_productarticlenumber",
          "operator": "IN"
        }
      ]
    }
  ],
  "properties": [
    "litium_productarticlenumber"
  ]
}

What am I doing wrong?