Search results by user ID 88135

Re: how to get record from particular range of date ( last month till today date )

athakur@amlongroup.com — Tue, 10 Sep 2024 20:02:22 GMT

error I got :

Failed to decrypt sub-resource 'None' payload on cloud with error: Failed to decrypt sub-resource payload {
"name": "Linked_SalesOrder",
"properties": {
"description": "Calling Salesorder_Api ",
"annotations": [,
"type": "RestService",
"typeProperties": {
"url": "********************",
"enableServerCertificateValidation": "********************",
"authenticationType": "********************",
"encryptedCredential": "********************"
}
}
} and error is: Failed to validate the signature because the content is tampered, the expect context is '{"url":"@{concat('https://rest.method.me/api/v1/tables/SalesOrder?filter=TxnDate ge ''', formatDateTime(addDays(utcNow(), -7), 'yyyy-MM-dd'), ''' and TxnDate le ''', formatDateTime(utcNow(), 'yyyy-MM-dd'), '''&orderby=TxnDate desc&$top=1')}","authenticationType":"Anonymous","dataFactoryName":"Amlon"}' and the runtime context is '{"url":"https://rest.method.me/api/v1/tables/SalesOrder?filter=TxnDate ge '2024-09-03' and TxnDate le '2024-09-10'&orderby=TxnDate desc&$top=1","authenticationType":"Anonymous","dataFactoryName":"Amlon"}'.., status code: BadRequest.

how to get record from particular range of date ( last month till today date )

athakur@amlongroup.com — Wed, 04 Sep 2024 21:41:15 GMT

I am using Azure ADF services under Rest serverce activities :

i want to get last month till today date record , how do i put into URL endpoint :

@{concat('https://rest.method.me/api/v1/tables/SalesOrder?filter=TxnDate ge ''', formatDateTime(utcNow(), 'yyyy-MM-dd'), '''&orderby=TxnDate desc&$top=1')
}

lets say I want to get last month record along with till today and i try with this url endpoint but its give me error :

@{concat('https://rest.method.me/api/v1/tables/SalesOrder?filter=TxnDate ge ''', formatDateTime(addMonths(startOfMonth(utcNow()), -1), 'yyyy-MM-dd'), ''' and TxnDate le ''', formatDateTime(utcNow(), 'yyyy-MM-dd'), '''&orderby=TxnDate desc&$top=1')}

would you please send me the structure regarding that so that i can use it.

how do i retrieves distinct (unique) records?

athakur@amlongroup.com — Mon, 24 Jun 2024 17:30:20 GMT

"I'm using Azure Data Factory to fetch records. How do I ensure each request retrieves distinct (unique) records? For example, if I have 201 records in SalesOrderLine and want to get all data using an API call without duplicating records each time, how can I ensure it returns the latest data with each request?"

let's say: i have 201 record and i have hit endpoint i will get 100 record but when i request 2nd time it should provide me next 100 unique record . please provide me some example or url request sample.

here is api URL request :

@{concat('https://rest.method.me/api/v1/tables/SalesOrderLine?filter=SORecordIDTxnDate le ''', '2024-05-30T18:00:00', '''&orderby=SORecordIDTxnDate desc&$top=1')

}

Re: how to increase Maximum limit of 100 records?

athakur@amlongroup.com — Mon, 24 Jun 2024 17:27:51 GMT

here is api URL request :

@{concat('https://rest.method.me/api/v1/tables/SalesOrderLine?filter=SORecordIDTxnDate le ''', '2024-05-30T18:00:00', '''&orderby=SORecordIDTxnDate desc&$top=1')

}

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

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

Re: how to increase Maximum limit of 100 records?

athakur@amlongroup.com — Tue, 04 Jun 2024 05:24:32 GMT

here is api URL request :

@{concat('https://rest.method.me/api/v1/tables/SalesOrderLine?filter=SORecordIDTxnDate le ''', '2024-05-30T18:00:00', '''&orderby=SORecordIDTxnDate desc&$top=1')

}

Re: how to increase Maximum limit of 100 records?

athakur@amlongroup.com — Tue, 04 Jun 2024 04:10:17 GMT

and SalesOrder as well

Re: how to increase Maximum limit of 100 records?

athakur@amlongroup.com — Tue, 04 Jun 2024 04:09:58 GMT

I am using Salesorderline table

Re: how to increase Maximum limit of 100 records?

athakur@amlongroup.com — Mon, 03 Jun 2024 21:34:44 GMT

it's urgent I need answer for my questions. please reply me.

Hello Support ,

We are retrieving records fine when limited to Top 10.

I changed the 10 to 100 and we get 401 unauthorized , can you please advise how we can increase the limit on both Top and skip without being blocked.

From documentation it says ……. The default value of top is 10 and the maximum allowed value of top is 100. i.e Maximum of 100 records can be requested in a single request, use the nextLink to get the next 100 records.

We changed the 10 to 100 and we get 401 unauthorized , can you please advise how we can increase the limit to 100 and to get next hundred also add 100 in skip

We are using Postman to test.

I want to get more than 100 records in single request. let me know the solutions.

Search results by user ID 88135

Re: how to get record from particular range of date ( last month till today date )

how to get record from particular range of date ( last month till today date )

how do i retrieves distinct (unique) r﻿ecords﻿?﻿

Re: how to increase Maximum limit of 100 records﻿?

Re: how do i filter by date and recorid

how do i filter by date and recorid

Re: how to increase Maximum limit of 100 records﻿?

Re: how to increase Maximum limit of 100 records﻿?

Re: how to increase Maximum limit of 100 records﻿?

Re: how to increase Maximum limit of 100 records﻿?

how do i retrieves distinct (unique) records?

Re: how to increase Maximum limit of 100 records?

Re: how to increase Maximum limit of 100 records?

Re: how to increase Maximum limit of 100 records?

Re: how to increase Maximum limit of 100 records?

Re: how to increase Maximum limit of 100 records?