Phantombuster - Data Output not a proper Json

How To
1

I’m working with Phantombuster’s download module and converting the output data from binary to string using toString. My goal is for this data to be structured as a proper JSON format, allowing it to be parsed directly with a JSON parse module.

Could you please help ensure the data converts to JSON correctly during this process?

Screenshot_17
Screenshot_171634×869 118 KB

2

Hi Abdul, you can use transform to JSON module and then pass it to parse JSON.

3

Thank you for reply,
Tried but not work

4

can you provide the string that you are trying to convert into JSON

5

{“resultObject”:“[{"profileUrl":"Sales Navigator Garbim","firstName":"Tiago","lastName":"Garbim","imgUrl":"https://media.licdn.com/dms/image/v2/C4D03AQGwKORN48Dbgw/profile-displayphoto-shrink_800_800/profile-displayphoto-shrink_800_800/0/1628302316082?e=1735171200&v=beta&t=7S7L0l1g9SYMr7Fs5jK-ejvI-UYaO_uXuc88V80NBl4\",\“degree\”:\“2nd\”,\“title\”:\"Founder & CEO","companyName":"Wevy","companyUrl":"Sales Navigator, São Paulo, Brazil","note":"","outreachActivity":"","outreachDate":"","dateAdded":"2024-10-04T19:41:03.770Z","vmid":"ACwAAAASz4wBqIp_uzF3X0cg2WT9UVzJ-JaXe2s","linkedInProfileUrl":"https://www.linkedin.com/in/ACwAAAASz4wBqIp_uzF3X0cg2WT9UVzJ-JaXe2s/\",\“name\”:\"Tiago Garbim","query":"Sales Navigator Machado","firstName":"Ivo","lastName":"Machado","imgUrl":"","degree":"3rd","title":"Chief Executive Officer","companyName":"TAO S.A","companyUrl":"Sales Navigator Paulo, São Paulo, Brazil","note":"","outreachActivity":"","outreachDate":"","dateAdded":"2024-10-04T19:41:03.770Z","vmid":"ACwAAAALOkgBbfZ9rc7cO4t7ryL5AmkPM8WB0BY","linkedInProfileUrl":"https://www.linkedin.com/in/ACwAAAALOkgBbfZ9rc7cO4t7ryL5AmkPM8WB0BY/\",\“name\”:\"Ivo Machado","query":"Sales Navigator”},

6

After using the JSON Transform module, the output is as follows.
And Gives the Error on Parse module

Screenshot_20
Screenshot_201066×604 61.4 KB

Screenshot_19
Screenshot_19560×455 32.7 KB

7

are you passing the string that you provided in the JSON string of parse JSON

image
image1545×827 247 KB

the structure of the result object hould be like this

{ "resultObject": [ { "profileUrl": "Sales Navigator Garbim", "firstName": "Tiago", "lastName": "Garbim", "imgUrl": "https://media.licdn.com/dms/image/v2/C4D03AQGwKORN48Dbgw/profile-displayphoto-shrink_800_800/profile-displayphoto-shrink_800_800/0/1628302316082?e=1735171200&v=beta&t=7S7L0l1g9SYMr7Fs5jK-ejvI-UYaO_uXuc88V80NBl4", "degree": "2nd", "title": "Founder & CEO", "companyName": "Wevy", "companyUrl": "Sales Navigator, São Paulo, Brazil", "note": "", "outreachActivity": "", "outreachDate": "", "dateAdded": "2024-10-04T19:41:03.770Z", "vmid": "ACwAAAASz4wBqIp_uzF3X0cg2WT9UVzJ-JaXe2s", "linkedInProfileUrl": "https://www.linkedin.com/in/ACwAAAASz4wBqIp_uzF3X0cg2WT9UVzJ-JaXe2s/", "name": "Tiago Garbim", "query": "Sales Navigator Machado" }, { "profileUrl": "Sales Navigator Machado", "firstName": "Ivo", "lastName": "Machado", "imgUrl": "", "degree": "3rd", "title": "Chief Executive Officer", "companyName": "TAO S.A", "companyUrl": "Sales Navigator Paulo, São Paulo, Brazil", "note": "", "outreachActivity": "", "outreachDate": "", "dateAdded": "2024-10-04T19:41:03.770Z", "vmid": "ACwAAAALOkgBbfZ9rc7cO4t7ryL5AmkPM8WB0BY", "linkedInProfileUrl": "https://www.linkedin.com/in/ACwAAAALOkgBbfZ9rc7cO4t7ryL5AmkPM8WB0BY/", "name": "Ivo Machado", "query": "Sales Navigator" } ] }

8

I’m using a variable named ‘json’, but the output I’m getting isn’t in proper JSON format. Could someone please guide me on how to convert this output into valid JSON?