May 14, 2021 3:42 PM
I am trying to make a .Net request to https://api.hubapi.com/crm/v3/objects/deals/search to retrieve a variable number of deal objects using "account number" as the search property. The problem is that I do not know how many accounts must be returned- maybe 2, maybe 500. I have already tried to pass in a request body with >40 JSON objects in the "Filter" array, but receive a 'Bad request. Maximum number of filters is 3." message. Is there a way around this? I thank you so much!
May 17, 2021 10:40 AM
May 17, 2021 10:46 AM
Can you explain a bit further so that I get a clear sense of understanding.
Is account number a custom made property? Or is account number an object (such as deals, contacts, tickets and companies)?
Lets say account number is a custom made property - several deals (up to 500 or so) may have the same account number?
Do you want all deals with a specific account number or should it be all deals with a specific account number and also other requriements met?
Give me some more details and Ill gladly help out 🤗
May 17, 2021 1:00 PM
There are a few errors in your code - I dont know if you put them there on purpose or not so I will give you the full explaination.
In hubspots world the pipeline and dealstage have uniqe ID numbers. Since we can create an infinite amount of pipelines and an infinite amount of deal stages all get a uniqe ID.
You need to enter the id number of the pipeline and the id number of the dealstage under "value" in your code.
In your hubspot account - go to settings - submenu Data Management then click Deals. Within deals click Pipelines.
Within pipelines select the pipeline "accounts". And then click the </> to get the pipelines internal value.
In the same settings - hover the mouse over the dealstage "Openfunded" to get its internal value:
(ignore the fact that my deal stages are named differently in my example)
You may only use the operators listed here:
IN is not on the list what I can see.
In order to search a list as you want you have to setup different filters.
The example is shown here:
And picture (with my drawing here:)
May 17, 2021 3:07 PM
Thank you, Michael. I was indeed able to GET the pipeline and deal stage with your help. However, your suggested approach to searching many objects resulted in the following error:
May 17, 2021 3:51 PM
May 18, 2021 6:11 AM
Yes, this is the limitation of the Search API that you can pass a maximum of 3 filters at a time. I can see you're quite close to finding a solution but I would like to add a suggestion too. So based on your accounts maybe you can break requests into a group of 3?
May 18, 2021 6:24 AM