How to fetch data from the Json queue

Help
, , , ,
1

Hello,
This is the transaction data in my queue

Test URL_1: [{“URL”:“https://google.com”,“First Name”:“Tom”,“Last Name”:“Cook”,“Location”:“https://onedrive.com/:f:/sites"},{“URL”:“https://google.com”,"First Name”:“Sam”,“Last Name”:“Robert”,“Location”:“https://onedrive.com/:f:/sites”}]

  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

2

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:
Newtonsoft.Json.Linq

1 Like