Fixing Zenrow Data Scraping: Cell Size Exceeds Limit Error

Andi D.

Zenrow scrapped data "Cell data size exceeds limit (8kB)" and cannot be added as a column, what should I do?

16 comments

Channeled
APP
·
·
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.
Source: Table columns | Documentation | Clay University
Andi D.
·
·
im already doing that but the cell is too big
Channeled
APP
·
·
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.
Sources: Manage cell data | Documentation | Clay University Write to Other Table | Documentation | Clay University
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 :)
Channeled
APP
·
·
Alexander F.
·
·
Hi, has anyone else found a solution to enrich if the job is still accepting applications?
Alexander F.
·
·
Or do you have some advice how to build affordable lists of companies that are hiring?
Andi D.
·
·
Alexander F. Use Apify job post scraper works a bit better, but not perfect.
Smit V.
·
·
Hi there, When running the "Find Jobs" search in Clay, you can set the posting date to filter for recent job listings. Selecting a shorter time frame, such as the past week, helps ensure the jobs you find are still accepting applications. Alternatively, you could use other tools like Apify for building job lists, though this would require a separate subscription or payment. Let me know if I can help you with anything else :) - Smit
Alexander F.
·
·
Thanks guys, very helpful!

Fixing Zenrow Data Scraping: Cell Size Exceeds Limit Error | Clay