Parsing json in backend workflows

Need help APIs
1

I am struggling to extract the 4 linkedin profiles and save them in the database.

I need to iterate on each one of them and then save them.

I receive the API call, but problem is , because the variables are on level 2 and not as atop variable, i can only save the whole resultObject as one text.

Please help me . I have been sitting 20 h

{
“agentId”: “8161692021020777”,
“agentName”: “LinkedIn Search Export”,
“containerId”: “1325730254600206”,
“script”: “LinkedIn Search Export.js”,
“scriptOrg”: “phantombuster”,
“branch”: “master”,
“launchDuration”: 441,
“runDuration”: 21997,
“resultObject”: “[{"profileUrl":"https://www.linkedin.com/in/brentonstrine\",\“fullName\”:\"Brenton Strine","firstName":"Brenton","lastName":"Strine","vmid":"ACoAAAFAO7UBWQzEbBs2ZUUdymw90kw8zE0o7Y0","profileImageUrl":"https://media.licdn.com/dms/image/C5603AQGKCrfEPahubQ/profile-displayphoto-shrink_100_100/0/1652444143999?e=1720051200&v=beta&t=37tYSHD75EQcZ5ME_QnTAtGnFLfnEfokr5POgy5GJDw\“,\“summary\”:\”...and mentorship. I love Bubble.io and love discussing…","connectionDegree":"3rd","job":"Co-founder & CTO at Kicky, voted greatest potential for financial return","location":"Atlanta, GA","sharedConnections":"Provides services - Web Development, SaaS Development, Application Development, Custom Software Development","url":"https://www.linkedin.com/in/brentonstrine\",\“name\”:\"Brenton Strine","query":"bubble.io, API, sweden","category":"People","timestamp":"2024-05-01T12:35:43.516Z"},{"profileUrl":"https://www.linkedin.com/in/sambailez\",\“fullName\”:\"Samuel :cloud: Bailez (he/him)","firstName":"Samuel","lastName":":cloud: Bailez (he/him)","vmid":"ACoAAATbYR4BCHiK-cn8jrfTl3UHEVGuBS584uQ","profileImageUrl":"https://media.licdn.com/dms/image/C4E03AQEiWDuaNA7W9w/profile-displayphoto-shrink_100_100/0/1604260623850?e=1720051200&v=beta&t=bXkE1aBSXR0Mz_xyNNEgvm59aEiF0P_ZyBL8rvBaLVM\",\“currentJob\”:\"Software Engineer at Airdev - …web applications for clients in weeks with Bubble.io Bubble.io is the world’s most powerful…","connectionDegree":"3rd","job":"Tech & Business Strategist | Software Developer | Bubble.io | IE University & Stanford UIF | Ex Salesforce & Disney","location":"New York, NY","url":"https://www.linkedin.com/in/sambailez\",\“name\”:\"Samuel :cloud: Bailez (he/him)","query":"bubble.io, API, sweden","category":"People","timestamp":"2024-05-01T12:35:43.516Z"},{"profileUrl":"https://www.linkedin.com/in/amiryamin33\",\“fullName\”:\"Amir Yamin","firstName":"Amir","lastName":"Yamin","vmid":"ACoAAAXZvcsBdy29QRt07E5BuDS9cRDCDp7NWxs","profileImageUrl":"https://media.licdn.com/dms/image/D4D03AQHzT7PCn5o6gg/profile-displayphoto-shrink_100_100/0/1713557629990?e=1720051200&v=beta&t=tlTlj2NgDdpKPGMf5Az89SpUl4EMKdYtVwiudLlrSd0\",\“additionalInfo\”:\"Skills: Bubble.io","connectionDegree":"3rd","job":"Tech Lead | Application Architect | Ruby on Rails | Backend Developer | Adobe Experience Manager | JavaScript","location":"Lahore","url":"https://www.linkedin.com/in/amiryamin33\",\“name\”:\"Amir Yamin","query":"bubble.io, API, sweden","category":"People","timestamp":"2024-05-01T12:35:43.516Z"},{"profileUrl":"https://www.linkedin.com/in/marekstark\",\“fullName\”:\"Marek Stark","firstName":"Marek","lastName":"Stark","vmid":"ACoAAAACmrMBdb2CTc0FsmeBDjAkuM_hsimtJVc","profileImageUrl":"https://media.licdn.com/dms/image/C4D03AQEsXrJgmt2XgQ/profile-displayphoto-shrink_100_100/0/1596314322223?e=1720051200&v=beta&t=vzGyFh1LBkAKoGnZrKZvfD7AU_5SX0zEWlxahij4hzE\",\“pastJob\”:\"Project Manager, Product Owner, Bubble.io developer (contract) at NCC - …: Project Manager, Product Owner as well as Bubble.io…","connectionDegree":"3rd","job":"Senior Agile Product Owner & Project Manager - Driving digital projects from idea to success","location":"Stockholm","url":"https://www.linkedin.com/in/marekstark\",\“name\”:\"Marek Stark","query":"bubble.io, API, sweden","category":"People","timestamp":"2024-05-01T12:35:43.516Z"}]”,
“exitMessage”: “finished”,
“exitCode”: 0
}

1 Like