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!

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

alaabitar 1,503 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Viswav 92 on at

Like (0)

Report

But when I tried the same, I get an error

Was this reply helpful? Yes No
alaabitar 1,503 Super User 2024 Season 1 on at

Like (0)

Report

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":""}]

Was this reply helpful? Yes No
Viswav 92 on at

Like (0)

Report

Yep I did. For my use case, the I get the error when I use this JSON:

Was this reply helpful? Yes No
alaabitar 1,503 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
fbanik 12 on at

Like (0)

Report

Thank you man!

It worked for me!!

Was this reply helpful? Yes No
Viswav 92 on at

Like (0)

Report

Thanks. Works now, my bad.

Was this reply helpful? Yes No