Unable to Read the data from the rest api result using the compose Action

(0) Share

Report

Posted on by TarunEY

We are getting the below format data from parameter data_array as a result of the rest api call

[
[
"[{\"ID\":\"12\",\"Name\":\"Raju \",\"FolderName\":\"0028\",\"FACEID\":\"6462\",\"Status\":\"Completed\"},{\"ID\":\"13\",\"Name\":\"Suresh\",\"FolderName\":\"0027\",\"FACEID\":\"27628316.1.0\",\"Status\":\"Completed\"}]"
]
]

We need to read actual data in string format -([{\"ID\":\"12\",\"Name\":\"Raju \",\"FName\":\"0028\",\"FACEID\":\"6462\",\"Status\":\"Completed\"},{\"ID\":\"13\",\"Name\":\"Suresh\",\"FName\":\"0027\",\"FACEID\":\"27628316.1.0\",\"Status\":\"Completed\"}]) from result and need to create a table for the actual data string.

We tried to use the compose action but unable to read the data in the string format.

Any help or suggestions on the same please. Thanks in Advance

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Chriddle 8,697 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Ask the API developers to respond with the correct JSON 😉

Otherwise, use the json() function with the string:

json(first(first(outputs('Compose'))))

Was this reply helpful? Yes No
TarunEY on at

Like (0)

Report
Copy link

Link copied!

@Chriddle Thank you for the help. It worked perfectly 😀

Was this reply helpful? Yes No