Troubleshooting Cell Data Size Exceeds Limit in Adyntel Ads Retrieval | Clay

Troubleshooting Cell Data Size Exceeds Limit in Adyntel Ads Retrieval

I’m trying to use adyntel to pull ads for specific companies, and what I get back is “cell data size exceeds limit.” Is it trying to put all the ads in a single cell? Can I set it up some other way?

9 comments

Christina P.
·
·
https://app.clay.com/workspaces/5798/tables/t_UWeqFy6s5TxF/views/gv_UYKVHpZzCPJF
Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Tomi F.
·
·
Hello Christina! I am not sure what the response format looks like, but you can try returning only particular fields in the output by listing the fields here: https://downloads.intercomcdn.com/i/o/w28k1kwz/1225314380/fff05716c0eeb116bf11b8d24a78/CleanShot+2024-10-22+at+17_34_48%402x.png?expires=1729634400&signature=4e69af7a47543af9aacc3aa722ce78eb945efbea734082c7922b05fe1394f2e2&req=dSIlE8p%2FmYJXWfMW1HO4zRdEkCs4SeBF6SJND%2BvsFZr8i75AkuaHKwAs6hNZ%0AQEvQ%0A If you want all the output fields, I recommend trying to split them half and half in different columns. Let me know if you are able to reach the desired output with these changes.
Christina P.
·
·
The response is a bunch of json. How would I specify which bits of the json I want?
Christina P.
·
·
Also, what would actually be helpful here is to have the response be split into a row for each ad. Is that possible?
Owen C.
·
·
Hey Christina, thanks for reaching out! Parsing the response into separate nested structures (e.g., Ad1 title, Ad1 results, Ad2 title, Ad2 results) should be possible! However, setting up the field paths correctly is challenging without knowing the key-value pairs in the JSON format. Do you have an example response you could share? We can work backward from the received JSON to identify the corresponding field paths needed to achieve this! :)
Christina P.
·
·
Hey! I got the response back, but honestly it took reasonably complicated python to parse what I need into a table. I think I’ll just use code to make the table, and then pull it into Clay to do the rest of what I need to accomplish. Thanks for your help!
Channeled
APP
·
·
Hi Christina P.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Christina P.!