How to get values using json in vba excel

[manurockz007]

---

How do i separate all the values from the following

{ "anonymousId": "12dhdhdhfds548521555", "event": "sample", "integrations": {}, "messageId": "1455gdhggdddddggg154", "properties": { "test_play_percentage": "0.926", "test_video_duration": 148.95600907029478, "test_video_position": 138, "test_video_url": "https://www.youtube.com/watch?v=dghssdghfddgs", "site_type_id": 10 }, To get an output where all the values should be separate.

<tbody>
</tbody>

I need to get values anonymousId, event, and other values in a separate cell in excel and also loop it so that i can get number of data done in one time.
Once we place data in a cell it should automatically separate the values not need of button to perform the action.
Advance thanks.

 

[DeBeuz]

Hi,

In VBA you should first remove "{" and "}," from the string using the replace function.
When done, you can split the string into an array of tag/value pairs using the split function on the "," Pairs = Split(String, ",").
Each pair can be split on the the colon (":") into tag and value.

Hope this helps