Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I'm building a pipeline in my Microsoft Fabric and trying to retrieve data from a rest API using my credentials (Basic Auth). The error I'm getting is that for the two parameters this API accepts dateStart and dateEnd it should be DateTime, but it doesn't recognize it from my query. Here's the error:
Error code: 23353
Activity ID: cff4ecc7-8a01-462e-8ca9-84873891fbc7
I'm using this as my base URL https://plateform.outsystemscloud.com/
The relative URL is: /API/rest/WTW/GetSales?dateStart={dateStart}&dateEnd={dateEnd}
My pagination rules are set to QueryParameters = {dateStart}, Body = 2024-03-01T00:00:00 and QueryParameters = {dateEnd}, Body = 2024-03-01T23:59:59
If I write as base URL https://plateform.outsystemscloud.com/API/rest/WTW/GetSales?dateStart=2024-03-01T00:00:00&dateEnd=20... and select preview data, I get a response and the preview data is shown. But I want to be able to make dateStart and End as parameters.
What can be the error?
---
Also see the result when I use the query as/API/rest/WTW/GetSales?dateStart=2024-03-01T00:00:00&dateEnd=2024-03-01T23:59:59
Solved! Go to Solution.
Hi @PauloAlvarez ,
Thanks for using Fabric Community.
I would like to understand why you are using Pagination Rules in your case?
Docs to understand Pagination rules - Link
You can directly use static values for datestart and dateend at relative url itself or you can also set variable to set the values for datestart and dateend.
Method 1 -
Method 2 -
Hope this is helpful. Please let me know incase of further queries.
Hello @PauloAlvarez ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .
Hi @PauloAlvarez ,
Thanks for using Fabric Community.
I would like to understand why you are using Pagination Rules in your case?
Docs to understand Pagination rules - Link
You can directly use static values for datestart and dateend at relative url itself or you can also set variable to set the values for datestart and dateend.
Method 1 -
Method 2 -
Hope this is helpful. Please let me know incase of further queries.
Hello @PauloAlvarez ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
4 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
10 | |
3 | |
2 | |
2 | |
2 |