Store part of JSON file in a variable

[YasserKhalil]

Hello everyone
I have a JSON file that I would like to parse data from .. I just need your help at specific point and that's how to refer to the desired part
Have a look at this snapshot
Untitled.png

What I need is to refer to the 'results' >> 0 >> testPassFailCounts
then to store its contents into an array

>> I have posted the thread at this link too
http://www.eileenslounge.com/viewtopic.php?f=30&t=31024

Thanks advanced for help

[YasserKhalil]

I could loop the json keys ..

Please Login or Register  to view this content.

Now how can I Loop through the items of results and refer to 'testPassFailCounts'?

[YasserKhalil]

Any help in this topic please?

[YasserKhalil]

Hope to find help in this topic. Are there any questions?

[Kyle123]

There's an example of doing that on the github repo that you've got the code from - https://github.com/VBA-tools/VBA-JSON

Which bit specifically are you struggling with, do you understand collections and dictionaries?

[YasserKhalil]

I already read a lot and have this link and downloaded it ..
The problem for me is how to refer to the desired element and store it in array
Please have a look at the json file

[Kyle123]

So do you understand dictionaries and collections? You need to understand them to use that library

[YasserKhalil]

I already stored the json content in a variable and could loop through the keys only

Please Login or Register  to view this content.

At this point I got lost ...

[YasserKhalil]

Any points are not clear !!?

[YasserKhalil]

Still waiting for help my friends

[YasserKhalil]

I would welcome any ideas to solve this issue

[YasserKhalil]

Is the issue difficult and impossible? I have searched and found a lot of pages but I couldn't find a clue till now

[YasserKhalil]

Problem solved at the other link with the help of Mr. Hans
Thanks a lot for following the issue and this is the final solution for those who are interested

Please Login or Register  to view this content.