Assistance to Parse Odata value response - possible nested array?

Ask the Experts and Postman Tips
,
1

Hi all, my first post after i’ve spent hours failing to come up with an answer.

I’ve searched around and couldnt find the answer that quite matched what i was looking for. On an Odata POST I get this response:

{
“@odata.context”: “url.com: THE URL Shortener - Free, Custom URLs”,
“value”: “{“BlobId”:”{78F2FB04-E13F-42F3-877D-F2AB2F06C23C}",“BlobUrl”:"https://url.windows.net/dmf/1aa2773a-7759-474a-8956-d173b556acca?sv=2014-02-14&sr=b&sig=LWptK5Y6B4nUCJa9UBch4kD9pN8ZZj9JPobuPajQTkc%3D&st=2021-09-08T17%3A23%3A02Z&se=2021-09-08T17%3A58%3A02Z&sp=rw"}"
}

I’ve been able to parse other responses with var jsonData = JSON.parse(responseBody);
and then get the value with jsonData.expires_on etc, however, I cannot seem to do the same with the response for this. I just need to get the BlobUrl out. I think it may be the fact I just need assistance in parsing nested JSON arrays?

If anyone could provide some guidance I would appreciate it.

many thanks

Andrew

2

@bigglesuk Welcome to the community :partying_face:

You can use https://jsonpathfinder.com/ this is help the newbies to parse the JSON response.

I wrote a blog on how to use it here.

1 Like
3

Thanks I will give it a go