What blocks do I use to put these key-value pairs into a dictionary? The JsonTextDecodeWithDictionaries block is not able to convert the JSON string properly and gives an error saying that the key-value pairs are not well-formed. I'm assuming this is due to the presence of the colons in the timestamps.
I would be very grateful if someone here can help me with this. Really hope there's a solution to this!
As you rightly say, you have a JSON string. Drag out a web component, then use the JSONTextDecodeWithDictionaries block to convert to an object, then it will be a dictionary, then you can handle the key:pairs.
Thank you very much for your kind help! After tinkering around, I finally realised that the JSON string could not be parsed because there are square brackets around it i.e., what I received was actually
So all I needed to do was to remove the square brackets and the JsonTextDecodeWithDictionaries block was able to parse the JSON string properly. Thank you!
The Web JsonTextDecodeWithDictionaries block handled the [ ] correctly.
You could instead have selected item 1 of the resulting list, then applied dict lookup to item 1.