Create a string from a JSON object on the backend

Wappler General Need Help
1

I have a JSON array on the backend and I'd like to create a string by concatenating the values ​​contained in that JSON.

Example:

"prod_itens": [
{
"$id": "1",
"id_item": "3",
"descricao_item": "APP GARÇON ADD",
"qtde_item": "3"
},
{
"$id": "2",
"id_item": "3",
"descricao_item": "Licença ADD",
"qtde_item": "3"
}
]

Create a string from the content of 'item_description'.

APP GARÇON ADD | Licença ADD

I've already tried creating a 'setValue' and inserting the content of the setValue + $value.descricao_item inside a repeat loop, but each time it loops, it only inserts the value once, keeping the value of the last index in the setValue.

What would be the correct way to proceed?

2

I managed to solve it....

I created a setValue outside the repeat loop with the name = TT and global TT.

Inside the repeat loop, I created the same setValue again, but with output inside the repeat loop, and it worked.

image
image820×479 15.5 KB

result:

image
image1128×373 7.72 KB

3

You can use the join formatter to create a comma separated list (string) without the need of the repeat step.

5

How would I use this formatter?

6

Select the array expression , add the join formatter to it and pick the property you want to join.

7

thanks