Match data and extract multiple values

Build
#1

I have the next JSON desarialize:

{
“idUsers”:3,
“users”: “mail@automan.com.mx”,
“password”: “password1234#”,
“portal”: “https://www.portal.com/part/layout/url/buys.as",
“Agencia:”: "agencia”,
“aseguradora”: “harmall”
}

How can I extract all data between {}, if matches with the string “www.portal.com”

Thank you in advance.

#2

@Mauricio_Reyes
there are several options e.g.

  • classical JSON Processing
  • Deserializing into a Dictionary (would work in your case, due no complex datatypes are in use) and checking for the string “http://www.portal.com”
#3

Hi @Mauricio_Reyes,

You can use something like that let’s say deserialize json is jsonObject . Now you get the value of portal like this jsonObject(“portal”).ToString it will return you https://www.portal.com/part/ layout/url/buys.as .
Now can check whether this string will contain www.portal.com you will get whole json for that you can use deserialize json then right after you can use For Each loop and argument type should be Newtonsoft.Json.Linq.JToken and save these value in a variable or you can convert your JSON into the data table using these steps:
1/ deserialize JSON as described.

2/ convert it into dictionary
dic = jsonObject.ToObject(of Dictionary(of string, string))

3/ build datatable using BuildDataTable activity

4/ convert dictionary into datatable
dt = (From row In dic Select dt.Rows.Add(row.Key.ToString,row.Value.ToString)).ToArray.CopyToDataTable

Hope it helps.

Best!!
Anml