Parse data from webhook workflow

Hi there
I am using a webhook from phantombuster, and trying to parse the result that comes beack.

The problem is that it delivers all the data I need under one of the parameters.
How can I separate the data below to be able to save it into fields? From the result object i need 7-8 parameters like imgUrl

Many thanks

“agentId”: “5499142461941992”,
“agentName”: “Untitled LinkedIn Profile Scraper”,
“containerId”: “2045470518041777”,
“script”: “LinkedIn Profile Scraper.js”,
“scriptOrg”: “phantombuster”,
“branch”: “master”,
“launchDuration”: 803,
“runDuration”: 50976,
“resultObject”: “[{“general”:{“imgUrl”:“",“fullName”:"Muhammad Waseem”,“headline”:“Senior Software Engineer | Tech Content Creator”,“location”:“Lahore, Punjab, Pakistan”,“connections”:“500+ connections”,“profileUrl”:“",“connectionsCount”:500,“connectionDegree”:“2nd”,“mutualConnectionsUrl”:“[“F”]&facetConnectionOf=[“ACoAACTtPXoBdGlHRHU0NaxZOxFQb_v2wgKSwt8”]&origin=MEMBER_PROFILE_CANNED_SEARCH&RESULT_TYPE=PEOPLE”,“mutualConnectionsText”:"Almir Tihak, Tomislav Galić, and 5 other mutual connections”,“description”:”",“subscribers”:20857,“firstName”:“Muhammad”,“lastName”:“Waseem”,“userId”:“619527546”,“backgroundUrl”:“",“vmid”:“ACoAACTtPXoBdGlHRHU0NaxZOxFQb_v2wgKSwt8”,“linkedinSalesNavigatorUrl”:“,name”,“connectionsUrl”:“[“ACoAACTtPXoBdGlHRHU0NaxZOxFQb_v2wgKSwt8”]&facetNetwork=[“F”%2C"S”]&origin=MEMBER_PROFILE_CANNED_SEARCH"},“details”:{“linkedinProfile”:“”,“websites”:“”,“twitter”:“mwaseemzakir”,“twitterProfileUrl”:“”,“connectedOn”:"",“mail”:“”},“skills”:[{“name”:“TypeScript”,“endorsements”:2},{“name”:"REST APIs”,“endorsements”:2},{“name”:“Microsoft Azure”,“endorsements”:2},{“name”:“Online Content Creation”,“endorsements”:2},{“name”:“C#”,“endorsements”:10},{“name”:“Angular 8.0”,“endorsements”:6},{“name”:".NET Framework",“endorsements”:8},{“name”:“Research”,“endorsements”:2},{“name”:“Software Development”,“endorsements”:3},{“name”:“Web Development”,“endorsements”:2},{“name”:“Object-Oriented Programming (OOP)”,“endorsements”:3},{“name”:“Algorithms”,“endorsements”:2},{“name”:“Data Structures”,“endorsements”:1},{“name”:“Creative Writing”,“endorsements”:1},{“name”:“Writer”,“endorsements”:1},{“name”:“Web Services”,“endorsements”:1},{“name”:“ASP.NET Core”,“endorsements”:4},{“name”:“Entity Framework”,“endorsements”:4},{“name”:“HTML”,“endorsements”:1},{“name”:“Bootstrap”,“endorsements”:1},{“name”:“ASP.NET”,“endorsements”:3},{“name”:“SQL”,“endorsements”:4},{“name”:“JavaScript”,“endorsements”:4},{“name”:“jQuery”,“endorsements”:1},{“name”:".NET",“endorsements”:1},{“name”:“Entity Framework (EF) Core”,“endorsements”:0},{“name”:“LINQ”,“endorsements”:0},{“name”:“MySQL”,“endorsements”:0},{“name”:“JSON Web Token (JWT)”,“endorsements”:0},{“name”:“Angular”,“endorsements”:0},{“name”:".NET Core",“endorsements”:0},{“name”:“Firebase”,“endorsements”:0},{“name”:“React.js”,“endorsements”:0}],“allSkills”:“TypeScript, REST APIs, Microsoft Azure, Online Content Creation, C#, Angular 8.0, .NET Framework, Research, Software Development, Web Development, Object-Oriented Programming (OOP), Algorithms, Data Structures, Creative Writing, Writer, Web Services, ASP.NET Core, Entity Framework, HTML, Bootstrap, ASP.NET, SQL, JavaScript, jQuery, .NET, Entity Framework (EF) Core, LINQ, MySQL, JSON Web Token (JWT), Angular, .NET Core, Firebase, React.js”,“jobs”:[{“companyUrl”:“",“companyName”:"Cinnova Technologies, LLC”,“logoUrl”:“",“jobTitle”:"Senior Software Engineer (.NET)”,“dateRange”:“Nov 2022 - Present · 8 mos”,“description”:“𝑺𝒌𝒊𝒍𝒍𝒔 : .NET 6.0 and 7.0 , React JS , SQL , C# 11 , Azure Devops , Angular\n\nAs a skilled software engineer with experience in .NET, SQL, Angular, and React, I am currently working directly with clients in the USA to deliver top-notch services on various projects. My diverse technology stack allows me to tackle a wide range of challenges and deliver exceptional results. Whether you are in need of a new software solution or an update to an existing one, I have the skills and experience to help you succeed.”},{“companyUrl”:“",“companyName”:"Abacus Consulting”,“logoUrl”:“",“jobTitle”:"Senior Consultant”,“dateRange”:“Sep 2021 - Nov 2022 · 1 yr 3 mos”,“description”:“𝑺𝒌𝒊𝒍𝒍𝒔 : Angular 8 , Bootstrap , Typescript , Dot Net Core , Entity Framework , C# , SQL , Azure , Ant Design , MVC , Web APIs”},{“companyUrl”:“",“companyName”:"Abacus Consulting”,“logoUrl”:“",“jobTitle”:“Consultant”,“dateRange”:"Mar 2021 - Aug 2021 · 6 mos”,“description”:“𝑺𝒌𝒊𝒍𝒍𝒔 : Angular 8 , Firebase, Bootstrap , Typescript , Dot Net Core , Entity Framework , C# , SQL , Azure , Ant Design , Web APIs”},{“companyUrl”:“",“companyName”:"Abacus Consulting”,“logoUrl”:"",“jobTitle”:"Research Associate ",“dateRange”:“Mar 2020 - Feb 2021 · 1 yr”,“description”:“𝑺𝒌𝒊𝒍𝒍𝒔 : Angular 8 , Bootstrap , Typescript , Dot Net Core , Entity Framework , C# , SQL , Azure”},{“companyUrl”:“",“companyName”:"Abacus Consulting”,“logoUrl”:“",“jobTitle”:"Internship Trainee”,“dateRange”:“Nov 2019 - Feb 2020 · 4 mos”,“description”:“𝑺𝒌𝒊𝒍𝒍𝒔 : JavaScript, JQuery”},{“companyUrl”:“",“companyName”:"Excellence Delivered (ExD) Pvt Ltd”,“logoUrl”:“",“jobTitle”:"Technical Trainer (.NET)”,“dateRange”:“Aug 2022 - Oct 2022 · 3 mos”,“description”:“As a seasoned software engineer with a passion for teaching, I had the opportunity to work as a trainer at a bootcamp for 3 months, where I helped students learn the fundamentals of .NET development. It was an incredibly rewarding experience, and I am always looking for new opportunities to share my knowledge and experience with others.”,“location”:“Lahore, Punjab, Pakistan”},{“companyUrl”:“",“companyName”:“Fiverr”,“logoUrl”:“”,“jobTitle”:"Freelance | .NET | Angular 2+ | SQL”,“dateRange”:“Jun 2016 - Mar 2022 · 5 yrs 10 mos”,“description”:“As a Level 1 seller on Fiverr with a strong background in .NET technologies, I have completed numerous web development projects for satisfied clients. My experience and skills make me a valuable asset for any team looking to take their web development to the next level. Whether you are in need of a new website or an update to an existing one, I have the knowledge and expertise to deliver high-quality results.\n\nConnect with me on LinkedIn to learn more about my experience and see how we can work together to achieve your web development goals”,“location”:“Remote”},{“companyUrl”:“",“companyName”:"University of the Punjab”,“logoUrl”:“",“jobTitle”:"Teaching Assistant”,“dateRange”:“Oct 2018 - Mar 2019 · 6 mos”,“description”:“As a dedicated and skilled software engineer, I have a passion for helping others succeed in the field. I have served as a teacher assistant for various software engineering subjects, where my responsibilities included evaluating student projects, assignments, and quizzes. My experience in this role has allowed me to develop strong skills in assessment and feedback, and I am always looking for opportunities to share my knowledge and experience with others.”,“location”:“Lahore, Punjab, Pakistan”}],“schools”:[{“schoolUrl”:“",“schoolName”:"University of the Punjab”,“logoUrl”:“",“degree”:"Bachelors of Software Engineering, Computer Software Engineering”,“dateRange”:“Oct 2015 - Jul 2019”,“description”:“Courses : \n •Analysis Of Algorithms \n •Computer Networks \n •Computer Vision \n •Data Sciences and Machine Learning \n •Database Systems \n •Engineering \n •Mathematics \n •Enterprise Application Development \n •Object Oriented Programming \n •Operating Systems \n •Probability and Statistics \n •Programming Fundamentals \n •Software Architecture \n •Software Engineering \n •Software Project Management \n •Software Quality Assurance \n •Software Requirements Engineering \n •Theory Of Automata \n •Web Engineering”}],“query”:"",“timestamp”:“2023-06-14T14:10:58.496Z”}]",
“exitMessage”: “finished”,
“exitCode”: 0

If the result is a nested JSON, you can send the value of the key to another to a backend API workflow and parse it from there.

If it’s a frontend call, you can either run JavaScript or just use a JSON parser plugin like JSON Assistant to do it. Alternatively extract with Regex if you know how.

1 Like