Clay Icon
Join the Community
02 Support

Troubleshooting HubSpot Data Export Error by ID

Avatar of Julius C.Julius C.
·
·

Hi there, I get this error message when I try to export data to Hubspot, the export should work based on the Hubspot ID

8 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    There could be a few reasons for the error when exporting to Hubspot using the Hubspot ID: 1. Data type mismatch: Ensure the data type in your Clay table matches the corresponding field type in Hubspot. This is crucial for successful exports. 2. Session token expiration: Try logging out of Clay and logging back in to refresh your session token. This can often resolve export errors. 3. Incorrect ID: Verify that you're using the correct Hubspot Record ID. Using a lookup column to confirm the company exists in Hubspot can help ensure you have the right ID. If the issue persists after trying these steps, you may need to request human assistance for further troubleshooting.

  • Avatar of David R.
    David R.
    ·
    ·

    I'm also getting something similar when I try to use the HTTP API to add a record to a list.

  • Avatar of David R.
    David R.
    ·
    ·

    Is there any way to disable any JSON formatting magic going on for a HTTP request?

  • Avatar of David R.
    David R.
    ·
    ·
  • Avatar of Julius C.
    Julius C.
    ·
    ·

    Thx, is there a way to solve this? The issue is still ongoing

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey Julius—this error’s happening because the HubSpot Phone Number field is linked to the entire object instead of just the value.

    (75 kB)
    Image

    Since your first 100 rows don’t have a mobile number, nothing shows up. To fix it, add the phone number as a separate column, sort this column from A to Z to bring rows with numbers to the top, then link it properly.

  • Avatar of Julius C.
    Julius C.
    ·
    ·

    Great, thank you!