Troubleshooting Data Transfer Errors When Pushing Scraped Data

💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!

Clay

Hi Hassnain, thanks for reaching out. Could you please provide a link to the table where you're encountering this issue? It seems that the list you're attempting to write to another table may not be compatible with the integration. Currently, only selected enrichment outputs can be written as lists to separate tables. You can refer to this guide for instructions on setting up the integration. For your use case, pay particular attention to step 4 onwards, where you'll need to parse the data from the column containing scraped websites into individual columns. This will enable you to properly write data to the target table: 1. You can choose to parse your arrays into an existing table or create a new blank table for them, by clicking on "new table": https://downloads.intercomcdn.com/i/o/1189705666/3740e7ce66126299688c295a/CleanShot%2B2024-09-04%2Bat%2B22_45_05.gif?expires=1727100000&signature=28b4c6c8df49fbbca99a73a19a25ffee0ee8d907b26775dd166473294a825d82&req=dSEvH85%2BmIdZX%2FMW1HO4zWIeGQ7uVCHHT%2Bxnh1bSnzUO1QnwnxwKVj%2BnfRNi%0AQEkG%0A 2. You can now neatly write our array of objects into individual rows by inserting a column in the 'Select a List from a Column' field. Type a forward slash, choose the column containing the arrays, open its properties, and click "insert all items". https://downloads.intercomcdn.com/i/o/1189705667/18b3e203cae15794dac52e49/CleanShot%2B2024-09-04%2Bat%2B22_53_01.gif?expires=1727100000&signature=ae899137516db4c44b2976e2c5214e4a6f2ab2b438d2aaffa3a8c0b8f452664b&req=dSEvH85%2BmIdZXvMW1HO4zVJJRqGbuFbmvH3qHykKApCTHN5Qhj7M5ujZlJ33%0Alao0%0A 3. Now the last thing we'll have to do is specify which objects from the array we want to write to the new table, and to which columns we want to map them. We'll be able to select columns which are existing or create new ad-hoc columns for this purpose: https://downloads.intercomcdn.com/i/o/1189705673/987d90f6f96b18151b38b985/CleanShot%2B2024-09-04%2Bat%2B22_55_01.gif?expires=1727100000&signature=64c4338997dba571e927d52405bb44c371f1ad60c555c6c251349f4523f9f137&req=dSEvH85%2BmIdYWvMW1HO4zc4D%2B7AgD%2FKpFQr309mO5ZunKcOcVV9au3oSblpo%0AOduz%0A 4. You can also add other column values to the table, which is useful when transferring lead data from one table to another using the 'Write to Table' column. This setup can work independently, without the list feature configured in step 4. https://downloads.intercomcdn.com/i/o/1189705664/11988528afd0aaa5aa0255b0/CleanShot%2B2024-09-04%2Bat%2B23_00_35.gif?expires=1727100000&signature=6972a04d500d037178e7b1e61facee23caf49ed6489885099105ede88bafd7f0&req=dSEvH85%2BmIdZXfMW1HO4zZTK3VEJJS0pMGLT541SSMxRrJzCAwNw7FO%2F4%2F2w%0AxQzX%0A You're all set! You can now save and run your 'Write to Table' column. I hope this was helpful. If there's anything else I can assist you with, please let me know!

This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.