Hello,
I am trying to compare dates in a HTTP connector, in the query parameters.
In the picture, iuesv_dlai_3_dcelo is a date in one of my tables, and Date_depart is a variable on the same date format.
But when I try to run the connector, I get this error.
Anyone has a solution?
Hi Sami, let me see look into this with the team and get back to you!
Hi, do you have some news?
Hey @sami.janati -
Did some investigation into this, and it looks like there is a discrepancy on the format that connectors send the datetime and the format the tables API expects them. We are adding some functionality as we speak to expose a mechanism to change how connector inputs are encoded, and I will make sure we address this use case as part of that work.
You can do this today by using a text input. This input should be in the format ISO8601 RFC 3339, which looks like: 2023-10-17T14:30:00Z
Hope this helps-
Pete
