How to fetch data from the Json queue

This is the transaction data in my queue

Test URL_1: [{“URL”:“”,“First Name”:“Tom”,“Last Name”:“Cook”,“Location”:“"},{“URL”:“”,"First Name”:“Sam”,“Last Name”:“Robert”,“Location”:“”}]

  1. I want total number of Last Name in the transaction
  2. After opening a directory location, I want to select all those jpg files whose names are similar to Last Name.

Please support for the issue

Hi @rajat_dhammi

You should be able to do a simple JArray.Parse(yourStringHere) to convert your transaction data to a workable JArray which you can then loop over using the For Each loop.

You might have to import this namespace for this to work:

1 Like