.png){kind=logo}
Troubleshooting Import Errors in Clay: Help Needed
Hi team, somehow imports are not working on my clay and I am getting this error whenever I try to import into a table.
Loading attachments
Hi team, somehow imports are not working on my clay and I am getting this error whenever I try to import into a table.
Without seeing the specific error message, I can help you with one of the most common import errors - the "failed to parse body" error. This typically occurs when there's an issue with data formatting. Here are the main things to check: 1. Make sure all text strings are enclosed in double quotes 2. Remove any extra commas at the end of entries 3. Check that numbers are not in quotes (unless they have trailing zeros) 4. Look for any hidden characters or extra spaces 5. Verify proper syntax with colons and bracketsYou can validate your data format using a JSON validator like JSONLint to spot and fix any formatting issues.If you need more specific help, please share the exact error message you're seeing. Sources: FAQ: Why am I seeing the "failed to parse body" error when using the HTTP API enrichment? HTTP API integration overview | Clay University HTTP API with JWT authentication | Clay University
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
I tried multiple times and still the same error
Let me help you troubleshoot the import error. Here are the most common reasons for persistent import failures: 1. Check your data formatting: • Ensure all text strings have double quotes • Remove any extra commas between entries • Look for hidden characters or extra spaces • Check for proper syntax with colons and brackets 2. Follow the correct import process: • Navigate to the Source panel • For existing tables: Click Actions > Import • Upload your file by clicking Browse Files or drag and drop • Properly match your CSV columns to Clay table fieldsIf you're still experiencing issues after checking these points, please share the specific error message you're seeing so we can provide more targeted assistance. Sources: How to import your CSV into Clay | Clay University HTTP API integration overview | Clay University
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
There are no errors, but the count doesn't seem to increase on my table, somehow indicating that import didn't even happen
aditya - Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1733949000&signature=0ca99b66bed596b0da3f0813400cdb3972df24935d90215379004f34850d41b3&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSj1Ap4W2BKsam%2FhVPuf8w%3D%3D%0A
That's because there was most of all a lot of duplicates. You can see it from the table history :) https://downloads.intercomcdn.com/i/o/w28k1kwz/1293578016/86b46547f51ad56da777a7d8ec9f/CleanShot+2024-12-11+at+_29I67wbcau%402x.png?expires=1733949900&signature=1fe001e4f3409729ab45104fa35b3ad9682d0b198ad0897c08dc7ab7b312c6d6&req=dSIuFcx5lYFeX%2FMW1HO4zTofHUTDebf8NUGwFQs477lVJu9voqpguJdDsGM4%0AxSOj%0A
But when I am importing I am doing exclude from current table, in that case why are there dups
Hey! Let me clear up the duplication situation - it's actually working as designed. Here's what's happening: 1. The exclusion only kicks in after the whole search finishes, not while it's searching 2. Since you've got multiple sources running, they all need to complete before the deduplication happens 3. That's why you might see some overlap in the results initially If you want a totally fresh start without any duplicates, creating a new table would be your best bet. But I'm happy to take a closer look if you want to send over a Loom video of what you're seeing when you're doing the search What would be most helpful for you right now? 😊
