I am using the SAP Odata connector to retrieve table properties from Success Factors.
Using Postman and help from our SAP developer guys I have managed to compile my query (with expand) and get all desired properties.
So far so good.
However, adding a filter seems to break the query, returning an internal server error.
The SAP team have confirmed the date time format and in Postman the following is working:
lastModifiedDateTime gt datetimeoffset '2025-01-05T15:16:23'
However, Power Automate is returning an internal sever error. What is even more frustrating the SAP back end is showing no error.
Here is my workflow / query.
So for I have tried:
lastModifiedDateTime gt datetimeoffset '2025-01-05T15:16:23'
lastModifiedDateTime gt datetimeoffset '2025-01-05T15:16:23z'
lastModifiedDateTime gt datetimeoffset 2025-01-05T15:16:23
lastModifiedDateTime gt datetimeoffset 2025-01-05T15:16:23z
lastModifiedDateTime gt '2025-01-05T15:16:23'
lastModifiedDateTime gt '2025-01-05T15:16:23z'
lastModifiedDateTime gt 2025-01-05T15:16:23
lastModifiedDateTime gt 2025-01-05T15:16:23z
None of the above works.
Any pointers / suggestions would be highly appreciated.
Not a lot of documentation on how to use this connector online, only how to set it up.