cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Output Array As Is

Hello,

 

I would like to output this JSON array  with different locations as is. So for example the input is:

 

{
    "ReasonForObjection": {
        "TypeOfOrder": "Standard Product",
        "CommentsB": "ExampleComment",
        "ProductManufacturedByReqOrg": "Yes",
        "ManufacturingLocations": [
            {
                "City": "Muscle Shoals",
                "State": "Alabama",
                "CurrentProductionCapacity": null,
                "PlantUtilization": null
            },
            {
                "City": "Davenport",
                "State": "Iowa",
                "CurrentProductionCapacity": null,
                "PlantUtilization": null
            },
            {
                "City": "Davenport",
                "State": "Iowa",
                "CurrentProductionCapacity": null,
                "PlantUtilization": null
            }
            
        ],
        "ProductionLocations": [
            {
                "Days": null,
                "City": "Lorain",
                "State": "Ohio",
                "CurrentProductionCapacity": null,
                "PlantUtilization": null
            },
            {
                "Days": null,
                "City": "Lorain",
                "State": "Ohio",
                "CurrentProductionCapacity": null,
                "PlantUtilization": null
            }
        ],
        "CommentsD": "ExampleComment. \r\n",
        "SubstitueProductByReqOrg": "Yes",
        "SubstitueLocations": [
            {
                "City": "Muscle Shoals",
                "State": "Alabama",
                "CurrentProductionCapacity": null,
                "PlantUtilization": null
            },
            {
                "City": "Davenport",
                "State": "Iowa",
                "CurrentProductionCapacity": null,
                "PlantUtilization": null
            }
        ],
        "ProductionSubstituteLocations": [
            {
                "Days": null,
                "City": "Lorain",
                "State": "Ohio",
                "CurrentProductionCapacity": null,
                "PlantUtilization": null
            },
            {
                "Days": null,
                "City": "Lorain",
                "State": "Ohio",
                "CurrentProductionCapacity": null,
                "PlantUtilization": null
            }
        ]
}

 

 

The output for ManufacturingLocations would be ( and so on and so fourth for each location):

 

City: Muscle Shoals
State: Alabama,
CurrentProductionCapacity: null,
PlantUtilization: null

City: Davenport,
State: Iowa,
CurrentProductionCapacity: null,
PlantUtilization: null

City: Davenport,
State: Iowa,
CurrentProductionCapacity: null,
PlantUtilization: null
.
.
.
.
.
.
.
.
.

 

 

The JSON changes so it could have more and could have less depending on the data. I also need to account for this.

1 ACCEPTED SOLUTION

Accepted Solutions
Paulie78
Super User III
Super User III

Something like this:

https://ibb.co/t8ZBDj3

locations.png

 

You can add in the text as per your liking.

View solution in original post

2 REPLIES 2
Paulie78
Super User III
Super User III

Something like this:

https://ibb.co/t8ZBDj3

locations.png

 

You can add in the text as per your liking.

View solution in original post

Anonymous
Not applicable

Fantastic, thank you! @Paulie78 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,262)