How to load json file into dictionary

[CRNaidu (Naidu)]

Hi Everyone.

Can anyone please tell me how to Load a JSON file into a dictionary.

I have done up to deserialize JSON after that I took For each activity from there onwards I was Stuck.

Thanks in advance

Regards,
CRNaidu

[viswanarahari]

Just see if this link helps ?

Conversion of collection to dictionary

That’s partially true (depends on how you look at it). Lambda’s are a no, but anonymous functions are ok (do note that UiPath uses VB.Net for expressions, not C#). That said, something like JsonConvert.DeserializeObject(Of DIctionary(Of String, String))(jsonData.Item("ColMapping") should work as an rvalue of an assign. Short sample attached (not exactly your scenario, but should help). Do note that you need to include Newtonsoft.Json namespace for it, or fully qualify the JsonConvert call. J…

[JJDev]

Simply use Deserialize JSON activity, set TypeArgument to System.Collections.Generic.Dictionary<System.String, System.String>
and output is Dictionary(String, String)