How do I transform JSON?

Server Side Components
#1

By API, I receive a file in JSON format. How do I convert the file to key:value format? This is the result I want to get.
Please help me solve the problem.

#2

You’ll have to write a custom module to alter the JSON structure.
Alternatively, you can add multiple repeats, etc. in a SA to save the data object by object in a table, then query that table (as shown in the result image you have shared) to get back data as expected.

1 Like