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!
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?
It appears using the EQ operator cannot accomodate the number of requests we anticipate. FYI I was able to use the IN operator but it only returns partial results (i.e. some deals are not being returned even though they have matching account_number):