You’re offline. This is a read only version of the page.
Announcements
Hello everyone,
I have a JSON that has the following format:
Share
Report{
"value": [
{
"title": "Title 1",
"ID": "9ee4ee0d-388a-4c87-8ff0-b2584eac42e3",
},
{
"title": "Title 2",
"ID": "9ee4ee0d-388a-4c87-8ff0-b2584eac42e3-1",
},
{
"title": "Title 3",
"ID": "9ee4ee0d-388a-4c87-8ff0-b2584eac42e3-2",
}
]
}
I used Data Operations - Select to extract the ID fields and now I have the following format:
[
{
"ID": "9ee4ee0d-388a-4c87-8ff0-b2584eac42e3"
},
{
"ID": "9ee4ee0d-388a-4c87-8ff0-b2584eac42e3-1"
},
{
"ID": "9ee4ee0d-388a-4c87-8ff0-b2584eac42e3-2"
}
]
I want to extract the values of all the IDs and return them as a string.
I have already managed to do so, using 'Variables-Initialize Variable', 'Aply To Each' and 'Variables-Append to string Variable'. I am looking for a solution where I don't have to use the 'Apply To Each' ,as this operation takes a fews seconds to complete and the latency increases with increasing number of items (in the case above only 3). Does anyone know how to return all the IDs as a string without the use of Apply To Each?
Any kind of help or input is appreciated. Thank you in advance!
Hi @liko,
Per my certain research and test, I am afraid that it might be not possible to extract all the IDs and set them as a string without using Apply to each.
There is another customer request the same feature on join function, please see it at here:
Please vote and comment the idea at here. I will keep an eye on this issue to see if there are other available methods.
Best regards,
Mabel Mao
All responses (
Answers (
522
