Querying all Opportunities since a specific timestamp from the REST API

Question

I have been tasked with building an integration with the Sugar CRM API Version 11_9 that needs to be able to read all Opporutnites that have been created or modified after specific timestamp. Consider the following simplified data set. 
 
 [

{
 id:"1",
"date_modified":"2020-08-10T03:09:09-08:00"
},
{
 id:"2",
"date_modified":"2020-08-12T03:09:09-08:00"
},
{
 id:"3",
"date_modified":"2020-08-14T03:09:09-08:00"
},
{
 id:"4",
"date_modified":"2020-08-16T03:09:09-08:00"
},

] 
 
 I am needing to be able to call something like {{base_url}}/rest/v11_9/Opportunities?since=2020-08-13T03:09:09-08:00 and return 
 
 [
{
 id:"3",
"date_modified":"2020-08-14T03:09:09-08:00"
},
{
 id:"4",
"date_modified":"2020-08-16T03:09:09-08:00"
},

]

Any ideas on how to this? This route isn't documented inside the REST API documentation so most everything I have had to figure out through inspection of API calls made vis the CRM Client application. 
 
 Any help on figure out how this should be done is greatly appreciated. Thanks!

Matthew McGuff · Accepted Answer

You need to be using the filter endpoint. Take a look at the following links 
 https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_9.2/Integration/Web_Services/REST_API/Endpoints/modulefilter_GET/ 
 https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_9.2/Cookbook/Web_Services/REST_API/PHP/How_to_Filter_a_List_of_Records/

Matthew McGuff · Answer

That module filter route was exactly what I looking for. Here is what I ended up using: 
 
 curl --location --request GET '{{sugar_baseurl}}/rest/v11_9/Opportunities/filter' \ --header 'Authorization: Bearer {{auth_token}} \ --header 'Content-Type: application/json' \ --data-raw '{ "filter":[ { "date_modified":{ "$gte":"2020-08-15T05:53:05-08:00" //or what ever time stamp my application needs here } } ] }' 
 
 Thank you so much for the unexpectedly quick response. Super helpful!