Compare dates in a connector


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-

1 Like