You’re offline. This is a read only version of the page.
45
I am creating a repeating nested table using plumsail.
My desired json should look something like this
Share
Report[
{
"job": "20",
"dumpsites": [
{
"name": "Land & Lakes",
"code": "23051",
"quanity": "400",
"notes": "First 10 feet",
"enddate": "1/24/2024"
}
]
},
{
"job": "35",
"dumpsites": [
{
"name": "Land & Lakes",
"code": "5124",
"quanity": "400",
"notes": "First 10 feet",
"enddate": "1/24/2024"
},
{
"name": "Reliable Thornton",
"code": "19856",
"quanity": "1000",
"notes": "",
"enddate": "1/24/2024"
}
]
}
]
My output from my Select looks like this
[
{
"job": "35",
"dumpsites": [
{
"name": "Land & Lakes",
"code": "5124",
"quanity": "400",
"notes": "First 10 feet",
"enddate": "1/24/2024"
}
]
},
{
"job": "20",
"dumpsites": [
{
"name": "Land & Lakes",
"code": "23051",
"quanity": "400",
"notes": "First 10 feet",
"enddate": "1/24/2024"
}
]
},
{
"job": "35",
"dumpsites": [
{
"name": "Reliable Thornton",
"code": "19856",
"quanity": "1000",
"notes": "",
"enddate": "1/24/2024"
}
]
}
]
What is the process of changing the json schema?
Thanks
All responses (
Answers (
