Parse an JSON of a HTTP response

(0) Share

Report

Posted on by fbanik

Hello guys!

I need help parsing the response from an HTTP request, like this:

First step:

"https://br-demo-5.topdesk.net/tas/api/persons?query=phoneNumber=="&Topic.telefone

After this GET, here de whole answer:

[{“attention”:null,“attentionComment”:“”,“authorizeAll”:true,“authorizeBranch”:true,“authorizeBudgetHolder”:true,“authorizeDepartment”:true,“authorizeSubsidiaryBranches”:true,“birthName”:“Marcelo Almeida”,“branch”:{“clientReferenceNumber”:“”,“extraA”:null,“extraB”:null,“id”:“85a55557-e74f-4f14-b07b-8897df29a272”,“name”:“S\u00E3o Paulo”,“timeZone”:“Brazil/East”},“budgetHolder”:{“id”:“b9574d6e-83ab-4313-9b27-0bbe27ae81c3”,“name”:“ADM”},“city”:“S\u00E3o Paulo”,“clientReferenceNumber”:“”,“creationDate”:“2022-06-13T13:29:23.000\u002B0000”,“creator”:null,“department”:{“id”:“6570e7d9-1fcc-45a6-a6d8-84ec64ccfd2f”,“name”:“Helpdesk”},“departmentFree”:null,“dynamicName”:“Marcelo Almeida",“email”:"marceloalmeida@hotmail.com”,“employeeNumber”:“44”,“fax”:“”,“firstInitials”:“”,“firstName”:“Marcelo”,“gender”:“MALE”,“hasAttention”:false,“id”:“860fb3fa-4f70-4826-9c29-f9242614725a”,“isManager”:true,“jobTitle”:“RCA”,“language”:null,“location”:null,“mainframeLoginName”:“”,“manager”:{“id”:“67a7a04f-fa49-40f0-a27f-79291868a466”,“name”:“Ina Mendoza”},“mobileNumber”:“”,“modificationDate”:“2024-04-18T17:45:33.000\u002B0000”,“modifier”:{“id”:“b944e70b-ed65-458d-b550-edc3323c851c”,“name”:“Code7”},“networkLoginName”:“”,“optionalFields1”:{“boolean1”:false,“boolean2”:false,“boolean3”:false,“boolean4”:false,“boolean5”:false,“date1”:null,“date2”:“2024-02-28T17:43:58.717\u002B0000”,“date3”:null,“date4”:null,“date5”:null,“memo1”:null,“memo2”:null,“memo3”:null,“memo4”:null,“memo5”:null,“number1”:0.0,“number2”:0.0,“number3”:0.0,“number4”:0.0,“number5”:0.0,“searchlist1”:{“id”:“8e7b6668-d611-4c78-9464-5c29dceef2cf”,“name”:“Sim”},“searchlist2”:{“id”:“9d3bb71f-8b42-40a2-9fc2-a7e4a4ee3774”,“name”:“N\u00E3o”},“searchlist3”:null,“searchlist4”:null,“searchlist5”:null,“text1”:“”,“text2”:“”,“text3”:“”,“text4”:“”,“text5”:“”},“optionalFields2”:{“boolean1”:false,“boolean2”:false,“boolean3”:false,“boolean4”:false,“boolean5”:false,“date1”:null,“date2”:null,“date3”:null,“date4”:null,“date5”:null,“memo1”:null,“memo2”:null,“memo3”:null,“memo4”:null,“memo5”:null,“number1”:0.0,“number2”:0.0,“number3”:0.0,“number4”:0.0,“number5”:0.0,“searchlist1”:null,“searchlist2”:null,“searchlist3”:null,“searchlist4”:null,“searchlist5”:null,“text1”:“”,“text2”:“”,“text3”:“”,“text4”:“”,“text5”:“”},“personExtraFieldA”:null,“personExtraFieldB”:null,“phoneNumber”:“19997394600”,“prefixes”:“”,“showAllBranches”:false,“showBranch”:true,“showBudgetholder”:true,“showDepartment”:true,“showSubsidiaries”:true,“status”:“person”,“surName”:“Almeida”,“tasLoginName”:“malmeida”,“title”:“”}]

I would like to store just the "dynamicName" part, is it possible?
field "Marcelo Almeida" in a variable called "parsedName"

How can I do it?

Thanks in advance!

All responses (7)

Answers (1)

Viswav 94 on at

Like (0)

Report

Re: Parse an JSON of a HTTP response

Thanks. Works now, my bad.
fbanik 12 on at

Like (0)

Report

Re: Parse an JSON of a HTTP response

Thank you man!

It worked for me!!
alaabitar 1,509 on at

Like (0)

Report

Re: Parse an JSON of a HTTP response

if you paste your json to https://jsonlint.com/ is it a valid json ?
Viswav 94 on at

Like (0)

Report

Re: Parse an JSON of a HTTP response

Yep I did. For my use case, the I get the error when I use this JSON:
alaabitar 1,509 on at

Like (0)

Report

Re: Parse an JSON of a HTTP response

When you paste your sample did you replace the “” by ". This is what I pasted in the generate from sample data
[{"attention":null,"attentionComment":"","authorizeAll":true,"authorizeBranch":true,"authorizeBudgetHolder":true,"authorizeDepartment":true,"authorizeSubsidiaryBranches":true,"birthName":"Marcelo Almeida","branch":{"clientReferenceNumber":"","extraA":null,"extraB":null,"id":"85a55557-e74f-4f14-b07b-8897df29a272","name":"S\u00E3o Paulo","timeZone":"Brazil/East"},"budgetHolder":{"id":"b9574d6e-83ab-4313-9b27-0bbe27ae81c3","name":"ADM"},"city":"S\u00E3o Paulo","clientReferenceNumber":"","creationDate":"2022-06-13T13:29:23.000\u002B0000","creator":null,"department":{"id":"6570e7d9-1fcc-45a6-a6d8-84ec64ccfd2f","name":"Helpdesk"},"departmentFree":null,"dynamicName":"Marcelo Almeida","email":"marceloalmeida@hotmail.com","employeeNumber":"44","fax":"","firstInitials":"","firstName":"Marcelo","gender":"MALE","hasAttention":false,"id":"860fb3fa-4f70-4826-9c29-f9242614725a","isManager":true,"jobTitle":"RCA","language":null,"location":null,"mainframeLoginName":"","manager":{"id":"67a7a04f-fa49-40f0-a27f-79291868a466","name":"Ina Mendoza"},"mobileNumber":"","modificationDate":"2024-04-18T17:45:33.000\u002B0000","modifier":{"id":"b944e70b-ed65-458d-b550-edc3323c851c","name":"Code7"},"networkLoginName":"","optionalFields1":{"boolean1":false,"boolean2":false,"boolean3":false,"boolean4":false,"boolean5":false,"date1":null,"date2":"2024-02-28T17:43:58.717\u002B0000","date3":null,"date4":null,"date5":null,"memo1":null,"memo2":null,"memo3":null,"memo4":null,"memo5":null,"number1":0.0,"number2":0.0,"number3":0.0,"number4":0.0,"number5":0.0,"searchlist1":{"id":"8e7b6668-d611-4c78-9464-5c29dceef2cf","name":"Sim"},"searchlist2":{"id":"9d3bb71f-8b42-40a2-9fc2-a7e4a4ee3774","name":"N\u00E3o"},"searchlist3":null,"searchlist4":null,"searchlist5":null,"text1":"","text2":"","text3":"","text4":"","text5":""},"optionalFields2":{"boolean1":false,"boolean2":false,"boolean3":false,"boolean4":false,"boolean5":false,"date1":null,"date2":null,"date3":null,"date4":null,"date5":null,"memo1":null,"memo2":null,"memo3":null,"memo4":null,"memo5":null,"number1":0.0,"number2":0.0,"number3":0.0,"number4":0.0,"number5":0.0,"searchlist1":null,"searchlist2":null,"searchlist3":null,"searchlist4":null,"searchlist5":null,"text1":"","text2":"","text3":"","text4":"","text5":""},"personExtraFieldA":null,"personExtraFieldB":null,"phoneNumber":"19997394600","prefixes":"","showAllBranches":false,"showBranch":true,"showBudgetholder":true,"showDepartment":true,"showSubsidiaries":true,"status":"person","surName":"Almeida","tasLoginName":"malmeida","title":""}]
Viswav 94 on at

Like (0)

Report

Re: Parse an JSON of a HTTP response

But when I tried the same, I get an error
Verified answer

alaabitar 1,509 on at

Like (0)

Report

Re: Parse an JSON of a HTTP response

Hello @fbanik

so first you would need to generate the response data type from sample data by pasting your json example.

Then you can use this type of formula to put all the dynamnicName into a table