API Response - Text manipulation

Dear All,

I need your help. I’m using API activity to get the text. The API is providing me with data for more than 1 order, and I want to apply string manipulation to extract only address value. Which activity will help me? I have tried is match and match activities, but those are not helping me.

{“data”:[{
“uuid”:“66272614-a140-40c7-959e-677d1247fed2”,
“number”:“MO004434”,“status”:“PENDING”,
“items_count”:null,
“type”:“SHIPPING”,
“payment_status”:“PAID_BY_DIGITAL”,
“pickup_code”:null,“total”:“$195.00”,
“created_at”:“01/14/2025”,
“completed_at”:“-”,
“user”:{“id”:852,“name”:“Ay. “,“phone”:”+17702943307”},
“items”:[{“id”:8031,“name”:“Cartridges”,
“description”:“Indica”,“qty”:4,
“price”:“$45.00”,
“total”:“$180.00”,
“discount”:“$0.00”}],
“address”:“Ay, Ha, 691 John Wesley Dobbs Avenue Northeast unit I, Atlanta, Georgia, 30312”},

{"uuid":"acf69961-423f-49d2-97c9-9ac77b774160",
"number":"MO004433",
"status":"PENDING",
"items_count":null,
"type":"SHIPPING",
"payment_status":"PAID_BY_DIGITAL",
"pickup_code":null,"total":"$175.00",
"created_at":"01\/14\/2025",
"completed_at":"-",
"user":{"id":852,"name":"Ay. ",
	"phone":"+17702943307"},
	"items":[{"id":8030,"name":"Exotic Flower",
	"description":"Black Label - 3.5g - 3.5g",
	"qty":4,"price":"$40.00",
	"total":"$160.00","discount":"$0.00"}],
"address":"Ayman, Hasan, 2123 summer wind drive, Atlanta, Ga, 30060"}
]

}

grafik
out: myJObject

Assign Activity
arrAddresses | DataType: String Array =
myJObject("data").SelectTokens("..address").select(Function (x) x.Value(Of String)).ToArray()

Can you please share the complete flow SS

its just about 2 activities

  • the Deserialize JSON using the JSON string / API response
  • Assign Activity: arrAddresses…

Feel free to do your RnD and prototypings also within the immediate panel
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

What had you modelled so far into the direction as described above?