.png){kind=logo}
Fixing Zenrow Data Scraping: Cell Size Exceeds Limit Error
Zenrow scrapped data "Cell data size exceeds limit (8kB)" and cannot be added as a column, what should I do?
The "Cell data size exceeds limit (8kB)" error occurs because Clay has a character limit of 8000 characters per cell. To resolve this, you can try the following: 1. Reduce the amount of data being scraped or split it into multiple columns. 2. Use the "Map child columns" feature to break down the large dataset: • Click on the cell with the Zenrow enrichment. • In the "Cell details" panel, hover over the desired endpoint. • Click "Add as column" to create a new column with specific data. If you need further assistance, please request human help by clicking on "Talk to a person" in this chat.
Andi D.··im already doing that but the cell is too big
If you're still encountering the "Cell data size exceeds limit (8kB)" error after splitting the data, here are some additional steps you can try: 1. Use the "Write to Other Table" feature to map the large dataset to a separate table. 2. In the Cell details panel, use the "Turn items into rows" option to move each list item into its own row in another table. 3. If the data is in a comma-separated list, use the "Extract Data From Values" feature with a custom Regex to split the values into a list, then send it to a new table. If these solutions don't resolve the issue, you may need to further reduce the data size or consider alternative data structuring methods. If you need more assistance, please request human help by clicking on "Talk to a person" in this chat.
- Andi D.··
nope not working. Another question, for "find jobs" a lot of job postings are no longer accepting applications, how can I check and see if a job is still active?
Smit V.··Hi Andi, thank you for reaching out! I'd recommend using Claygent to visit those job application links and check if they are still accepting applications. Could you try that, and let me know how it goes?
- Andi D.··
Hey thanks Smit! Claygent can’t read that red “no longer accepting applications” on expired/closed job posts (or maybe my prompt isn’t good) 😕 Any ideas?
- Smit V.··
Happy to take a look into your prompt. Do you mind sending the link (url) to the table?
(52 kB)
- Andi D.··
an. I don’t have that column anymore (deleted to move forward with different workflow
- Andi D.··
But lot of Clay find jobs or Job Open enrichment are closed for application
- Smit V.··
At the moment, our data for open jobs doesn’t provide a way to tell if an application has stopped accepting submissions, we mainly rely on whether the posting is still marked as active. I understand this might not be ideal. It sounds like you’ve started exploring a different approach now. If you have any other questions, please let me know :)