bug with brackets

[RaunakThomas]

Dim Json As Object
Set Json = JsonConverter.ParseJson("{""a"":123,""b"":[{""Name"":""abc""},{""Name"":""cde""}]}")
Debug.Print (Json("a"))
Debug.Print (Json("b"))

I'm not sure why the first print statement works whereas the second one doesn't

[aholden10]

Your "b" data is contained as two elements in an array (the square brackets) so you have to address the elements of that array to return results. These statements worked for me: Debug.Print (Json("b")(1)("Name"))  'gives abcDebug.Print (Json("b")(2)("Name"))  'gives cde Hope it helps! On Thursday, December 9, 2021, 04:22:46 PM EST, Raunak Thomas ***@***.***> wrote: Dim Json As Object Set Json = JsonConverter.ParseJson("{""a"":123,""b"":[{""Name"":""abc""},{""Name"":""cde""}]}") Debug.Print (Json("a")) Debug.Print (Json("b")) I'm not sure why the first print statement works whereas the second one doesn't — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or unsubscribe. Triage notifications on the go with GitHub Mobile for iOS or Android.

[groovedrm]

Your "b" data is contained as two elements in an array (the square brackets) so you have to address the elements of that array to return results. These statements worked for me: Debug.Print (Json("b")(1)("Name")) 'gives abcDebug.Print (Json("b")(2)("Name")) 'gives cde Hope it helps! On Thursday, December 9, 2021, 04:22:46 PM EST, Raunak Thomas @.***> wrote: Dim Json As Object Set Json = JsonConverter.ParseJson("{""a"":123,""b"":[{""Name"":""abc""},{""Name"":""cde""}]}") Debug.Print (Json("a")) Debug.Print (Json("b")) I'm not sure why the first print statement works whereas the second one doesn't — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or unsubscribe. Triage notifications on the go with GitHub Mobile for iOS or Android.

Tremendously helpful - thank you. Was suffering through this today and your answer solved my problem!

[aholden10]

Glad it helped, we've all suffered through it at one time or another!  Another user helped me through it over the Christmas holidays a few years ago....amazing. On Monday, October 10, 2022 at 03:20:31 PM EDT, Chris Cocuzzo ***@***.***> wrote: Your "b" data is contained as two elements in an array (the square brackets) so you have to address the elements of that array to return results. These statements worked for me: Debug.Print (Json("b")(1)("Name")) 'gives abcDebug.Print (Json("b")(2)("Name")) 'gives cde Hope it helps! On Thursday, December 9, 2021, 04:22:46 PM EST, Raunak Thomas @.***> wrote: Dim Json As Object Set Json = JsonConverter.ParseJson("{""a"":123,""b"":[{""Name"":""abc""},{""Name"":""cde""}]}") Debug.Print (Json("a")) Debug.Print (Json("b")) I'm not sure why the first print statement works whereas the second one doesn't — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or unsubscribe. Triage notifications on the go with GitHub Mobile for iOS or Android. Tremendously helpful - thank you. Was suffering through this today and your answer solved my problem! — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you commented.Message ID: ***@***.***>