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
Hi Again
I found this date time format which I tried passing - 2017-01-02 00:00:00.0000000
Still same error!!