Count JSON Obj and Set as dictionary value

[amaglam]

Hello, would any happen to know how to get the count of not null values in a JSON Object and set it as the value in a dictionary? What I need to do is loop through my list of users, and each user has list of values(my json values) and I need to count the unique values. Currently I am writing everything to a sheet and removing the duplicates then grabbing the count but I feel that is a more elegant way.