Dealing with Inconsistent Datetime Formats in API Responses


Strategies to address synchronization issues caused by inconsistent datetime formats in API responses


I’m working on integrating a vendor using the connector builder and have encountered synchronization issues due to some API responses from this vendor containing invalid and inconsistant datetime formats. For example, some timestamps have seven fractional seconds, such as 2024-04-19T13:21:06.4643864Z, instead of the standard six. This discrepancy is causing sync failures as it doesn’t match the templates that I defined for incremental sync (ex: %Y-%m-%dT%H:%M:%S.%fZ). Could you recommend any strategies to address this issue? Thank you

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["inconsistent-datetime-formats", "api-responses", "connector-builder", "synchronization-issues"]