.png){kind=logo}
Converting JSON Response to Table Format: How-To Guide
Hi Team, How can convert the JSON format response to a new table (Write to table).
Loading attachments
Hi Team, How can convert the JSON format response to a new table (Write to table).
👋 Hey there! Our support team has got your message - we'll be back in touch soon. 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!
I recorded this walkthrough video showing exactly how to set this up: https://cln.sh/BMzjxR0n Let me know if you have any follow-up questions!
Hey Sachin! Thanks for reaching out. Happy to help✨. I made a quick video showing how to do this: https://www.loom.com/share/d2ce9fc83daa4471adcee5ffafaba2be Let me know if this helps!
thanks Daniela D. for the help.
Hi Clay S. Daniela D. Could you please let me know the process through which I can get the most latest linkedin post or comment commented by person linkedin profile. Also, if we can filter the post and comments on the basis of finance, M&A, VC, PE related?
Hey Sachin! Thanks for reaching out. Happy to help✨. You can access public posts via a web search with Claygent by prompting it to run a search to find a LinkedIn post url (associated with a contact) related to Finance, M&A, VC & PE. If getting full coverage is the priority, other tools like PhantomBuster & Apify.com could help. These are live scrapers that use your live cookie session to find information. They'll be able to extract linkedin post & comments which can be filtered further in Clay for those related to finance, M&A, VC & PE. However, an important note with using these tools is that they may risk your account. Here's a quick guide for using Apify: https://www.clay.com/university/lesson/deep-dive-apify-actors-limitless-research Example actor: - https://apify.com/curious_coder/linkedin-post-search-scraper - https://apify.com/curious_coder/linkedin-comment-scraper Let me know if you have any questions!
Hi Daniela D. thanks for sharing the info. But why "Find Recent Posts by User or Company" clay enrichment is not working properly. It should pull the post from the linkedin profile but it is not doing it.
Hello Sachin! You're right that our Find recent social posts integration pulling LinkedIn posts has issues. Our team finally received the necessary updates from our data provider to fix these changes, and we'll be rolling out the fixed integration shortly. Appreciate your message, and rest assured we'll get back to you once its fixed! In the meantime, I would recommend other scraping tools like Apify and PhantomBuster as Daniela suggested earlier.
No problem! Here are guides to help you get started: • How to use Apify • How to use Phantombuster I found this Apify actor, for example, which should get the job done for your specific use case. Apify integrates with Clay, so you'll be able to build tables based on Apify actor runs, or trigger actor runs at strategic points in your workflow. Here's how you can set up a Clay table from an Apify actor run: https://downloads.intercomcdn.com/i/o/w28k1kwz/1360628483/b7a61b3d26ccea37632d09a98fda/CleanShot-2B2024-08-06-2Bat-2B15_48_57.gif?expires=1738393200&signature=af9ca4be6a05bb434ca1629c0df7baf68c1a73e466120bb10de125ffc0cbe104&req=dSMhFs98lYVXWvMW1HO4zZcX0G3cvNgkzdgADYRj3wfDYHqPCrqCR1Atozwd%0AO5OY%0A And here's how you can trigger an Apify actor in an active workflow: https://downloads.intercomcdn.com/i/o/w28k1kwz/1360628482/57b38afd01bd5d1f7ae5cd33614d/CleanShot-2B2024-08-07-2Bat-2B11_15_01.gif?expires=1738393200&signature=75471c1945e982f32a5124280ab2dd5fac2ae934613704026b6cedd6234f6591&req=dSMhFs98lYVXW%2FMW1HO4zYBMgKHBgiIoKM3ztm8AzTD%2FBCkC4JU6aATb12tR%0AuGYc%0A However, please note that doing this does go against LinkedIn's terms of service, meaning there is a possibility your account gets blocked, especially if it is not a paid account on LinkedIn.
thanks for sharing, I will try and will let you know if I have any queries.