Clay Icon
Join the Community
02 Support

Issues with Missing Updated At Field in Clay Table for HubSpot Integration

Avatar of Sean M.Sean M.
·
·

Is there any specific reason why I should expect to not see the Clay-created "Updated At" field from my Clay table, despite seeing the "Created At" field? I'm trying to use the "Updated At" field from the Clay row to import that specific date/time into a HubSpot Contact property.

6 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To successfully import date/time fields from Clay to HubSpot, there are a couple of important points to consider: 1. Date formats need to be compatible with your CRM. For dates to work properly, they should follow Unix time set to midnight. 2. You'll need to normalize the date format using the Format Date/Time formatter in Clay. Select Unix Timestamp as your output format, and keep the column type as text rather than date format to avoid formatting issues. 3. It's crucial to match the data type in your Clay table with the corresponding field type in HubSpot. Double-check the field types in your CRM to ensure successful data transfer, as the export will fail if the data types don't match. If you're still unable to see the "Updated At" field after implementing these changes, you may want to explicitly request human support to investigate your specific setup.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Is that what you were looking for?

  • Avatar of Sean M.
    Sean M.
    ·
    ·

    No - it's not a formatting issue, but rather the field not showing at all.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Looks like you're still looking for help.

    If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hi Sean, That's normal behavior in Clay. The "Updated At" field isn't available to reference directly because it would create an infinite loop - each time you'd reference it, the row would update, which would change the "Updated At" value, triggering another update. If you need to track when a row was last modified for your HubSpot import, you might want to create a custom date field with a formula. That'd be done like this: 1. Create a formula, reference a column and ask when was this last updated. 2. This will return right now but then every time you'll update it, you'll get the recent date. Let me know if you need any other help with this!