Convert to array

Help Activities
, ,
1

given below iis a dummy data in string format :[

{
““Name””: ““ABC””

},

{
““Name””: ““EFGH””

},

{
““Name””: ““IJKL””

}]"

I want output in array of {“ABC”,“EFGH”,“IJKL”}
how i can get this output?

2

1/ deserialize to JArray
2/ yourArray = JArray.Select(function(x) CType(x.First, JProperty).Value.ToString ).toarray

cheers

3

@Aditi0374,

The string you have is JSON String. Use 3 assign activities as below.

jsonString = "[{""Name"": ""ABC""}, {""Name"": ""EFGH""}, {""Name"": ""IJKL""}]"
jsonObject = JsonConvert.DeserializeObject(Of JArray)(jsonString)
namesArray = jsonObject.Select(Function(x) x("Name").ToString()).ToArray()
4

Hi @Aditi0374

Deserialize JSON Array’ Activity

  • Input: jsonString Your String
  • Output: JArray

In the last assign

nameArray = JArray.Select(Function(item) item("Name").ToString()).ToArray()

The image shows a debugging session in an IDE where a JSON array is deserialized, selected elements are assigned to a variable , and then displayed in a message box. (Captioned by AI)
The image shows a debugging session in an IDE where a JSON array is deserialized, selected elements are assigned to a variable , and then displayed in a message box. (Captioned by AI)1778×750 49.4 KB

Hope this helps :slight_smile: