Method Community

Hi ,

I wanted to filter record id with particular date but its doesn't work , would you help me on this, like how do i filter the record with my given date and recordID?

https://rest.method.me/api/v1/tables/SalesOrder?filter=TxnDate ge '2024-06-20'?RecordID eq 17537

Hi athakur,

Here are a few things I found in your query you are using, You should not be using "?RecordID eq 17537" at the end. You can try something like https://rest.method.me/api/v1/tables/SalesOrder?filter=TxnDate ge '2024-06-20'.

To filter even further, you can try using the timestamp as well, appending T00:00. Also, here is a link to our API help center where it has covered the filter criteria in detail.

I hope this helps!

Cheers,
Inder

I already know this https://rest.method.me/api/v1/tables/SalesOrder?filter=TxnDate ge '2024-06-20'.  but I want include RecordID into URL seach parameter , lets say i want to filter for date : 2024-06-15 and RecordID 17335   I want result for this recordid 17335 based on this date  2024-06-15  :  

so please provide me the example url. and sample of exmaple 

To add RecordID just add the RecordID with AND parameter something like this:

https://rest.method.me/api/v1/tables/SalesOrder?filter=TxnDate ge '2024-06-20' AND RecordID eq ’17335’