How to joing arrays of values in single string

Help Studio
, , , , , , , , , , ,
1

i have jason where i need to fetch scope value and there can be 1 or multiple scope
so json is -

image
image1135×281 32.4 KB

full json -
[
{
“id”: 477,
“type”: “project”,
“scopeType”: “project”,
“scope”: 22000,
“teamId”: 296,
“teamName”: “ADECCO OLE ESPANA 2019”
},
{
“id”: 478,
“type”: “project”,
“scopeType”: “project”,
“scope”: 21303,
“teamId”: 296,
“teamName”: “ADECCO OLE ESPANA 2019”
}
]

here above you can see ,my expected output will be
19403 (correcly giving)
22000,21303 (for now giving only lsat value)

i am using string .join as well still giving only last value

image
image557×413 19.7 KB

help me to resolve same

2

@Mathkar_kunal

can you share the full expression that using string.join…

check with below expression and try
String.Join(“,”, JsonArray.Select(Function(x) x(“scope”).ToString))

3

i am usin this
String.Join(“,”,currentJToken(“scope”).ToString)

and assigning to string variable StringValues

4

instead of using for each after deserialization array take assign activity and in to section create a list of a variable and in value section give below expression
String.Join(“,”, JsonArray.Select(Function(x) x(“scope”).ToString))

5

thanks now it is working only thing is i dont want comma in number only i need for saperation

image
image300×280 3.61 KB

you ca see line number 6
it is writing like - 2,200,021,303

i need -
2200,21303

@ppr @yedukondaluaregala @Anil_G @ashokkarale

6

This excel format issue, change format from number to text