Method:API Q&A

Re: how do i filter by date and recorid

Method_Inderdeep — Wed, 26 Jun 2024 18:18:30 GMT

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’

Re: how do i filter by date and recorid

athakur@amlongroup.com — Mon, 24 Jun 2024 17:00:21 GMT

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

Re: how do i filter by date and recorid

Method_Inderdeep — Mon, 24 Jun 2024 16:32:00 GMT

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

how do i filter by date and recorid

athakur@amlongroup.com — Thu, 20 Jun 2024 21:55:11 GMT

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