Append to Array Variable with URLs

[Arshad80]

Hi All,

I am working on flow to take the URLs from this JSON below, and append them in an array variable so that i can use it in another step. but when i try to append them i got an error message. i have tried to use split function to create each individual URL but it doesnt seem to work.

" Unable to process template language expressions in action 'Compose_2' inputs at line '1' and column '2260': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Array'. Please see https://aka.ms/logicexpressions#split for usage details.'."

[
{
"$id": "4",
"MailboxPrimaryAddress": "ketegik@gmail.com",
"Upn": "ketegik@gmail.com",
"Type": "mailbox",
"RiskLevel": "None",
"Urn": "urn:UserEntity:021773f9262a2772978bab2632ef1c2d",
"Source": "OATP",
"FirstSeen": "2021-01-07T11:14:40"
},
{
"$id": "5",
"Recipient": "ketegik@gmail.com",
"Urls": [
"https://add.eventable.com/generate/5d41929cadb9b7001e461663/?opt_in=001710ec42&alias=ketegik@gmail.c...",
"https://add.eventable.com/generate/5d419b7001e461663/?opt_in=false&events=5f15c52539341e001710ec42&a...",
"https://add.eventable.com/generate/5d61663/?opt_in=false&events=5f1710ec42&alias=ketegik@gmail.com&c...",
"https://add.eventable.com/generate/5d41929c1663/?opt_in=false&events=5f15c525342&alias=ketegik@gmail...",
"https://oralroberknbts.com/prayer/",
"https://raisedonkjhors.com/oralroberts/donate",
"http://www.loveworldtelevisionministryfakere.org/",
"http://us14.forwardde-too-frieytnd.com/forward?u=bc8a20a6169fb&id=94ad5e1480&e=2672b6a6b1",
"https://zoom.us/mhggeeting/regihggster/tJckfu2tqT0rEbQINekv",
"http://www.loveworldcsa.org/"
],
"Threats": [
"ZapPhish"
],
"Sender": "prayer@oralroberts.com",
"P1Sender": "bounce-mc.us14_62438977.113734-2672b6a6b1@mail29.suw91.mcdlv.net",
"P1SenderDomain": "mail29.suw91.mcdlv.net",
"SenderIP": "198.2.184.29",
"P2Sender": "prayerhgjg@oralroberts.com",
"P2SenderDisplayName": "RT",
"P2SenderDomain": "oralrobeyghgrts.com",
"ReceivedDate": "2021-01-04T16:34:45",
"NetworkMessageId": "8452350d-5269-4873-eb9b-08d8b0cea3b5",
"InternetMessageId": "<bc8a20a61dd41b07eea2469fb.2672bd5e1480.997636f1@mail29.suw91.mcdlv.net>",
"Subject": "Do you need...",
"AntispamDirection": "Inbound",
"DeliveryAction": "Delivered",
"DeliveryLocation": "Inbox",
"Language": "en",
"Type": "mailMessage",
"Urn": "urn:MailEntity:a23b59b504347660794",
"Source": "OATP",
"FirstSeen": "2021-01-07T11:14:40"
}
]

[v-litu-msft · Accepted solution]

Hi @Arshad80,

I store the JSON you provided into a Compose action, then you could refer to the following expression, use index "1" to get the second member, then use property name Urls to extract values:

outputs('Compose')[1]['Urls']

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Arshad80]

Thanks for your feedback but this is what i get.

[v-litu-msft]

Hi @Arshad80,

If you already get the array and store it into the Compose action, you could store the output of Compose action into the variable directly.

outputs('Compose')

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.