Power Platform Community Forum Thread Details

Change schema of json

I am creating a repeating nested table using plumsail.

My desired json should look something like this

[
 {
 "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"
 }
 ]
 }
]

ccdd select.png

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

Quick Links