Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

Converting Apollo API JSON Blob to Text Format in Clay | Clay

Converting Apollo API JSON Blob to Text Format in Clay

·

·

hi hi! i'm using the Apollo API and getting a JSON blob in Clay, but i'm having trouble working with it. is there a way i can convert it to text and export it?

Loading attachments

6 comments

· Sorted by Oldest

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!
Muhammad S.
·
·
You can stringify the JSON using this formula but probably the text is too long to fit into the clay cell data size limit since you are extracting all the data returned by API
JSON.stringify({{APOLLO_COLUMN_NAME}}?.results?.people)

Create a new formula column and paste this formula column in there. Replace the APOLLO_COLUMN_NAME with your actual apollo column name
Muhammad S.
·
·
Alternative: You can use HTTP API call to call apollo and limit the data returned using field paths to returned field.
John S.
·
·
awesome – thank you Muhammad S.!
Arturo O.
·
·
Hey John, how's it going? Thanks for the inquiry. Also, appreciate you as always, Muhammad, that's a great workaround! You can also push the data to a new table via the Write to table integration to extract a list of results into their own rows, here's a quick video: https://www.loom.com/share/d46fd74ae9004d229142a2474ac61866?sid=440fafc1-5d4c-4ed4-bebe-449748573397 Let me know if you have additional questions!
Channeled
APP
·
·
Hi John S.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: