Closed cosmoc closed 8 months ago
The issue you have comes from the fact that you are using the JSON data from the first example inside the second example:
The JSON content for the second example is something like this :
{"values":[{"a":1,"b":2,"c": 3}]}
And then the Parsed variable should look something like this:
In this case, you can see that the key "values" that you call on the dictionary isn't a special key that returns values. For the key to be valid it has to appear as an item in the object.
Thank you. I see that data was in the comment, however, my mistake to copy the first example's json data. I think I am all set and I appreciate the help.
Thank you
My pleasure!
Executing advanced example. Run-time error '424' Issue appears on
Dim Values As Variant ReDim Values(Parsed("values").Count, 3)
from the advanced example
The Spec.xlsx show all "pass"
Running Windows Microsoft® Excel® for Microsoft 365 MSO (Version 2302 Build 16.0.16130.20806) 64-bit
I am single-stepping in debug
I created an example.json using the same data as the first example in the Readme.md
The JSON content is {"a":123,"b":[1,2,3,4],"c":{"d":456}}
This is Parsed prior to the ReDim statement
I have tried other content and encounter the same error.
NOTE: I previously erroneously reported this in the wrong Git repo.