Filtering id greater than

[LRIFFELGROEHS]

Hello,

everytime I try a POST requisition to the v3 search endpoint using this payload I get an error.

{
 "filterGroups": [
 {
 "filters": [
 {
 "propertyName": "id",
 "operator": "GT",
 "value": 4409651
 }
 ]
 }
 ],
 "sorts": [
 {
 "propertyName": "id",
 "direction": "ASCENDING"
 }
 ],
 "properties": list_of_properties,
 "limit": 100
}

[Jaycee_Lewis]

Hey, @LRIFFELGROEHS Thanks for posting! In the future, posting your full request, response, and error body will help the community better understand your issue.

To clarify, you are:

• Using this endpoint? POST/crm/v3/objects/deals/search
• Your goal is to search for deals by using their deal ID? Essentially, “show me all deals with a Deal ID > 4409651”, correct?
• The internal value for Record ID (Deal ID) is “hs_object_id”

Here’s a quick test based on what I think you’re trying to accomplish.

• The goal as I understand it — search for Deal with Deal IDs > than a specific value.

• My request and JSON body:

  POST/crm/v3/objects/deals/search
  
  {
   "filterGroups":[
   {
   "filters":[
   {
   "propertyName": "hs_object_id",
   "operator": "GT",
   "value": "9344774700"
   }
   ]
   }
   ],
   "sorts": [
   {
   "propertyName": "hs_object_id",
   "direction": "ASCENDING"
   }
   ]
   }​
  

  Please note, in my example, I used a value for the filter that works for my portal.

• Response

  {
   "total": 14,
   "results": [
   {
   "id": "9435654818",
   "properties": {
   "amount": null,
   "closedate": "2022-08-26T17:28:05.450Z",
   "createdate": "2022-07-08T17:28:15.576Z",
   "dealname": "Test2",
   "dealstage": "appointmentscheduled",
   "hs_lastmodifieddate": "2022-10-24T19:58:04.003Z",
   "hs_object_id": "9435654818",
   "pipeline": "default"
   },
   "createdAt": "2022-07-08T17:28:15.576Z",
   "updatedAt": "2022-10-24T19:58:04.003Z",
   "archived": false
   },
  ...
  

• By using the GT operator, I excluded one existing deal, as it has a Record ID lower than the value I used. My query returned 14 deals, but I have 15 total deals in my portal.

In summary, you just needed to use the internal value for this property when searching. There are also a few formatting issues, including missing quotes for some of your values. Easy fixes, though

Have fun building! — Jaycee