Deserialize JSON from Spotify: added 1 field but cannot deserialize

[HensRansen]

First I had this code for calling the API from Spotify:

and deserialize:

Now, I also want to now id from the track.

This is my new code:
“https://api.spotify.com/v1/playlists/“+strSpotifyPlaylistCode+”/tracks?market=NL&fields=items(track(name,id),track(artists(name)))”

because in response content (output) the track id is also included:
"{"items":[{"track":{"artists":[{"name":"Vieze Asbak"},{"name":"Joost"}],"name":"Wachtmuziek (Sped Up)","id":"2joc5EdF3gTzvrtjvjKrud"}}

(etcetera)

But the deserialization does not work, ID is not added:
DeserializeJSON_d70a20 { items=List(79) { items { track=track { artists=List(2) { artists { name=“Vieze Asbak” }, artists { name=“Joost” } }, name=“Wachtmuziek (Sped Up)” } }

how can i include ID ?

[ppr (Peter Preuss)]

Just a few analysis and clearing steps

• ensure that the schema indicating is the same / within the same structure as the base lined Input Type

• checkout the returned JSON within the immediate panel
  Understanding the 6 Debugging Panels of UiPath in the easiest way possible!

• try a general deserialization into a JObject and extract from this

[HensRansen]

Hi Peter, thanks for your reply.
My problem is, I don’t know how to choose the Input Type.
How can I choose the correct input type?

How do I make a general deserialization?

[ppr (Peter Preuss)]

@HensRansen

How do I make a general deserialization?

use JObject as Input type and let the sample blank

[HensRansen]

alright. The output from deserialize json is variable named test4.

Contents:

Now I want to iterate through the objects, with a for each, but I get this error:

How do I iterate through this json object?

[ppr (Peter Preuss)]

@HensRansen

Now I want to iterate through the objects, with a for each, but I get this error:

just share the JSON (as Text file) with us, so we can help you with the details.

in the immediate panel, you can get a more readable JSON with test4.toString

[HensRansen]

test4.txt (10.2 KB)

See attachment. I think it is a partial extract, because it ends with …

[HensRansen]

I think I almost get it working, but cannot call
current.track.name.tostring

[HensRansen]

alright, this works:

current(“track”)(“artists”).ToString
@“[
{
““name””: ““Vieze Asbak””
},
{
““name””: ““Joost””
}
]”

but this doesn’t:
current(“track”)(“artists”)(“name”).ToString

is it because there are multiple names under artists?

[ppr (Peter Preuss)]

As all tracks are within a JArray we can loop within a for each activity:

myJObject("items").Values(Of JObject)

and iterate over all items from the “items” Array

Cross Check:

[HensRansen]

thanks! Works like a charm!