JumboCactuar
Well-known Member
- Joined
- Nov 16, 2016
- Messages
- 788
- Office Version
- 365
- Platform
- Windows
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 ?
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 ?
VBA Code:
If Json("tickets")(i)("tags").Count > 0 Then 'do something'