Converting JSON Response to Table Format: How-To Guide

HEre is the workflow link https://app.clay.com/workspaces/289883/workbooks/wb_7NizqdmmPtJV/tables/t_d3w7Wyi7mtSD/views/gv_AYVSN4xBKNbj

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!

Hi Bo (. I want all the job posted in the link mentioned in the "URL Concatenation" column. the process that you showed only pulling one job from the scrapped data. But it has around 10-12 jobs in the link.

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.

Thank you so much for sharing your feedback Sachin!

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.

Hi Anaum K., thanks for the feedback. Please if I get an update on the fix issue, will be very helpful. I am not sure if we can integrate Apify and PhantomBuster to Clay automation. Is there any process vid instruction from where I can take reference.

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.

I have great news for you! The Find Recent Social Posts enrichment for LinkedIn has been restored with major improvements: What you can do now: Track Post Engagement - Pull all comments, reactions, and shares from any LinkedIn post (works as a source or action) Monitor User Activity - Get a user's recent comments, posts/shares, or reactions on LinkedIn Enrich Posts - Now costs only 0.5 credits and includes videos, @mentions, reaction counts, and more Let me know if you have any questions 🙂

This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.