VBA-JSON Help - If Key doesn't exist

[JumboCactuar]

Hi,
using:
GitHub - VBA-tools/VBA-JSON: JSON conversion and parsing for VBA

I have a structure like this:
Json("tickets")(i)

Where i is used as the Ticket number

Some tickets but not all have this property:
Json("tickets")(i)("tags")

I tried to loop through it like this but it fails if one doesnt have tags, how can i skip the "tickets" which dont have tags ?

 If Json("tickets")(i)("tags").Count > 0 Then 'do something'

 

[Dan_W]

The VBA-JSON library constructs a pseudo JSON Object by using dictionaries and collections. With that in mind, if JSON("tickets")(i) is a dictionary object, you can always used the .Exists method to test if tags key is there.

Alternatively, it's less elegant and it is far from good practice, but you could use `On Error Resume Next` to ignore any errors and just soldier on through. But you shouldn't need to if you can just test if the key is there or not with the Dictionary's Exist method.