Forum Discussion
ADF OData Connection Parameters
Hi Everyone and thanks for your input
Back to this issue....
The error I'm now receiving is then below. Again incorrect datetime format!
Requesting response from path Company('xxxxxxxx')/Dimension_Values_Excel?$Filter=Last_Modified_Date_Time gt 2024-08-23T10:00:00.00Z and query $top=10 failed with status code BadRequest and message {"error":{"code":"BadRequest","message":"The DateTimeOffset text '2024-08-23T10:00:00.00Z?$top=10' should be in format 'yyyy-mm-ddThh:mm:ss('.'s+)?(zzzzzz)?' and each field value is within valid range. CorrelationId: 9b43a6ca-1d12-413c-bfcf-a3a9eefed6a0."}}.
Not sure what is wrong with this format - 2024-08-23T10:00:00.00Z
'It's expecting this format - yyyy-mm-ddThh:mm:ss('.'s+)?(zzzzzz)? Not sure what the trailing part is tbh
Regards
Brian
You seem to have an extra question mark
?$top=10
replace it with &
Hello
Thanks a lot for your reply.
This is what I'm actually passing - Company('xxxxxxxx')/Dimension_Values_Excel?$Filter=Last_Modified_Date_Time gt 2024-08-23T10:00:00.00Z
The rest has been added by the Data Factory itslef since I'm pressing the Preview Data and it's seems that preview will give me the top 10 rows, so unfortunately I don't have control on this part - ?$top=10 since it has been appended automatically.
Reading your comment, I decided to skip the data preview function and run the pipeline with my parameters directly. Again I pasted a format which I found online.
Company('xxxxxxxxxxxx')/Dimension_Values_Excel?$Filter=Last_Modified_Date_Time gt 2024-08-28T00:00:00.0000000Z
This time the top was not added however it's still complaining of a sytax error!
Failure happened on 'Source' side. ErrorCode=ODataRequestNotSucceeded,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Requesting response from path Company('COME%20ON%20MALTA%20LIMITED')/Dimension_Values_Excel?$Filter=Last_Modified_Date_Time gt 2017-01-02 00:00:00.0000000Z and query failed with status code BadRequest and message {"error":{"code":"BadRequest","message":"Syntax error at position 40 in 'Last_Modified_Date_Time gt 2017-01-02 00:00:00.0000000Z'. CorrelationId: fad854b9-7cee-4327-80a8-8a7133ce5b4b."}}.,Source=Microsoft.DataTransfer.Runtime.ODataConnector,'
The below is the previous format I was using... just a difference at the trailing part
Company('xxxxxxxx')/Dimension_Values_Excel?$Filter=Last_Modified_Date_Time gt 2024-08-23T10:00:00.00Z
Regards
Brian
It seems to be swallowing the "T" that is mandatory for ISO8601.