Hello Airbyte friends! I am working on implementing an incremental sync for Shipbob and I am able to get the initial sync to work but the incremental syncs fail due to a mismatch in expected date formats. I get the following error on incremental runs

Additional Failure Information: time data '2023-05-22T20:36:11.6980713+00:00' does not match format '%Y-%m-%dT%H:%M:%S.%f+00:00'

Which I totally understand, the

created_date

from my API response is coming in with 7 digits for microseconds as opposed to the expected 6 digits but I am not sure how to handle this. Thank you in advance!

A message from kapa.ai

Is there a way to do something like

{{ now_utc().strftime('%Y-%m-%dT%H:%M:%S.%f+00:00') }}

but instead I am pointing to my cursor field from my response body which is created date. Something along the lines of

{{ created_date.strftime('%Y-%m-%dT%H:%M:%S.%f+00:00') }}

Hi Dion, did you solve this problem? I'm having the same issue