I have a SharePoint list - witch I want to use to build a JSON file, formatted after a certain schema. HOW!
Getting the data isn't the problem (Get Item) , but how do I format the output according to my schema?
Ex:
I hava a list with 7 columns. I want to build a JSON file/ data-file with the following structure/schema:
(Also see below)
After using Get Item - I can adress the data, I used: Select Row - But this didn't solve the formatting...
How do I set this up - to place the data in the right place - and format?
[
{
"template": "template.pptx"
"data": [
{
"name": Chart1",
"table": [ (Number of rows in this array will differ)
[{"string": "ProjectName_1"}, {"date": "2023-05-01"}, {"date": "2023-06-01"}, {"date": "2023-07-01"}], (Number of objects in this array is constant.
[{"string": "ProjectName_2"}, {"date": "2024-05-01"}, {"date": "2024-06-01"}, {"date": "2024-07-01"}],
..
...
.....
]
},
{
"name": Chart2",
"table": [ (Number of rows in this array will differ)
[{"string": "ProjectName_1"}, {"date": "2023-05-01"}, {"string": "Sven"}, {string": "Gunnar"}], (Number of objects in this array is constant.
[{"string": "ProjectName_2"}, {"date": "2023-05-01"}, {"string": "Ella"}, {"string": "Anna"}],
..
...
.....
]
}
]
}
]
