How to Format Date Data for API Integration Compatibility

Miguel M. · 2025-04-13T22:30:35.730028+00:00

i've created a custom http API integration and I'm trying to send my "created at" data over to my 3rd party app, however the data format in clay does not match the destitnation date format - what's the fastest way to make this compatible?

The fastest way to make your "created at" data format compatible with your destination format is to use the Format Date/Time formatter in Clay. Here's how: 1. Select the Format Date/Time action in your workflow. 2. Choose Unix Timestamp as your output format. 3. Keep the column type as text rather than date format to avoid formatting issues. This method will normalize your dates, making them compatible with most CRM systems and third-party apps. If you need further customization, you can adjust other settings like timezone and locale in the Format Date/Time action.

Source: Format Date/Time with Clay Formatters

2 comments