Reply
PauloAlvarez
Frequent Visitor

Help with error 23353: Failed to parse. 'DateTime' compatible data type is required for parameter

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

Details: Rest call failed with client error, status code 400 BadRequest, please check your activity settings. Request URL: https://plateform.outsystemscloud.com/API/rest/WTW/GetSales?dateStart=%7BdateStart%7D&dateEnd=%7Bdat.... Response: {"Errors":["Failed to parse. 'DateTime' compatible data type is required for parameter 'dateStart'.","Failed to parse request exception message: 'The value '{dateStart}' is not valid for DateTime.'","Failed to parse. 'DateTime' compatible data type is required for parameter 'dateEnd'.","Failed to parse request exception message: 'The value '{dateEnd}' is not valid for DateTime.'"],"StatusCode":400}

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?

Captura de pantalla 2024-03-04 134928.png

 

 

---

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

PauloAlvarez_0-1709557406174.png

 

 

2 ACCEPTED SOLUTIONS
avatar user
Anonymous
Not applicable

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 -

vgchennamsft_2-1709631214824.png

 



Method 2 -

vgchennamsft_0-1709631157903.png



vgchennamsft_1-1709631171113.png

 

Hope this is helpful. Please let me know incase of further queries.


View solution in original post

avatar user
Anonymous
Not applicable

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 .

View solution in original post

2 REPLIES 2
avatar user
Anonymous
Not applicable

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 -

vgchennamsft_2-1709631214824.png

 



Method 2 -

vgchennamsft_0-1709631157903.png



vgchennamsft_1-1709631171113.png

 

Hope this is helpful. Please let me know incase of further queries.


avatar user
Anonymous
Not applicable

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 .

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebFBC_Carousel

Fabric Monthly Update - February 2025

Check out the February 2025 Fabric update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)