cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ManojR
Regular Visitor

[Solved] How to Parse JSON as a array and update the excel/SharePoint ?

Hi Community,

 

Greetings for the day,

 

I have the following JSON to parse as a array, loop through it and update the items into SharePoint list.

Is there any way to do this one ?

 

Thank you so much for your time,

Data required in single iteration of loop : EID, EMP Name, Job level ,Account etc.

 

 

[
    {
        "@odata.etag": "",
        "ItemInternalId": "2dc94879-049a-4042-85f5-f944ef03357e",
        "EID": "",
        "EMP Name": "",
        "Joblevel": "0",
        "Account Name": "",
        "Rev_x002e_ Region": "ANZ",
        "Country": "",
        "Capability/GIDC/Region": "",
        "Sub Program": "",
        "Work Performed by the Resource": "",
        "Lean and Automation Actions": "",
        "Action Date": "",
        "Action Type": "Exit",
        "Redeploy Category": "Redeployment",
        "Sending PPMC ID": "123456",
        "PPMC End Date": "",
        "Receiving PPMC ID": "",
        "PPMC Start Date": ""
    },
    {
        "@odata.etag": "",
        "ItemInternalId": "d4869179-bc92-43db-a872-443fafbfb6cf",
        "EID": "",
        "EMP Name": "",
        "Joblevel": "",
        "Account Name": "",
        "Rev_x002e_ Region": "",
        "Country": "",
        "Capability/GIDC/Region": "",
        "Sub Program": "",
        "Work Performed by the Resource": "",
        "Lean and Automation Actions": "",
        "Action Date": "",
        "Action Type": "Redeploy",
        "Redeploy Category": "",
        "Sending PPMC ID": "",
        "PPMC End Date": "",
        "Receiving PPMC ID": "",
        "PPMC Start Date": ""
    },
    {
        "@odata.etag": "",
        "ItemInternalId": "9e2161b4-19a9-4605-af06-f6cfe9056117",
        "EID": "it should be of 8 digit number",
        "EMP Name": "",
        "Joblevel": "",
        "Account Name": "",
        "Rev_x002e_ Region": "",
        "Country": "",
        "Capability/GIDC/Region": "",
        "Sub Program": "",
        "Work Performed by the Resource": "",
        "Lean and Automation Actions": "",
        "Action Date": "",
        "Action Type": "",
        "Redeploy Category": "",
        "Sending PPMC ID": "",
        "PPMC End Date": "",
        "Receiving PPMC ID": "",
        "PPMC Start Date": ""
    },
    {
        "@odata.etag": "",
        "ItemInternalId": "83e66d5e-5103-4a27-a3d7-2538985f600c",
        "EID": "",
        "EMP Name": "",
        "Joblevel": "",
        "Account Name": "",
        "Rev_x002e_ Region": "",
        "Country": "",
        "Capability/GIDC/Region": "",
        "Sub Program": "",
        "Work Performed by the Resource": "",
        "Lean and Automation Actions": "",
        "Action Date": "",
        "Action Type": "",
        "Redeploy Category": "",
        "Sending PPMC ID": "this should be 8 digit number",
        "PPMC End Date": "it should be a date",
        "Receiving PPMC ID": "same like column n",
        "PPMC Start Date": " it should be date only"
    }
]

 

 

 

Thanks again,

 

Manoj

1 ACCEPTED SOLUTION

Accepted Solutions
ManojR
Regular Visitor

Hi Guys,

Got the solution, it is pretty straight forward we can directly loop through because it's a already and array,

 

ManojR_0-1627139762209.png

Was trying to get json output of list rows from present in table and parsing it, so just updated the schema with following

{
    "type": "object",
    "properties": {
        "@@odata.etag": {
            "type": "string"
        },
        "ItemInternalId": {
            "type": "string"
        },
        "EID": {
            "type": "string"
        },
        "EMP Name": {
            "type": "string"
        },
        "Joblevel": {
            "type": "string"
        },
        "Account Name": {
            "type": "string"
        },
        "Rev_x002e_ Region": {
            "type": "string"
        },
        "Country": {
            "type": "string"
        },
        "Capability/GIDC/Region": {
            "type": "string"
        },
        "Sub Program": {
            "type": "string"
        },
        "Work Performed by the Resource": {
            "type": "string"
        },
        "Lean and Automation Actions": {
            "type": "string"
        },
        "Action Date": {
            "type": "string"
        },
        "Action Type": {
            "type": "string"
        },
        "Redeploy Category": {
            "type": "string"
        },
        "Sending PPMC ID": {
            "type": "string"
        },
        "PPMC End Date": {
            "type": "string"
        },
        "Receiving PPMC ID": {
            "type": "string"
        },
        "PPMC Start Date": {
            "type": "string"
        }
    }
}

template,

 

 

 

 

I was not able to find to delete this post so thought put answer of this one and close it off,

 

 

Thank you.!

 

View solution in original post

1 REPLY 1
ManojR
Regular Visitor

Hi Guys,

Got the solution, it is pretty straight forward we can directly loop through because it's a already and array,

 

ManojR_0-1627139762209.png

Was trying to get json output of list rows from present in table and parsing it, so just updated the schema with following

{
    "type": "object",
    "properties": {
        "@@odata.etag": {
            "type": "string"
        },
        "ItemInternalId": {
            "type": "string"
        },
        "EID": {
            "type": "string"
        },
        "EMP Name": {
            "type": "string"
        },
        "Joblevel": {
            "type": "string"
        },
        "Account Name": {
            "type": "string"
        },
        "Rev_x002e_ Region": {
            "type": "string"
        },
        "Country": {
            "type": "string"
        },
        "Capability/GIDC/Region": {
            "type": "string"
        },
        "Sub Program": {
            "type": "string"
        },
        "Work Performed by the Resource": {
            "type": "string"
        },
        "Lean and Automation Actions": {
            "type": "string"
        },
        "Action Date": {
            "type": "string"
        },
        "Action Type": {
            "type": "string"
        },
        "Redeploy Category": {
            "type": "string"
        },
        "Sending PPMC ID": {
            "type": "string"
        },
        "PPMC End Date": {
            "type": "string"
        },
        "Receiving PPMC ID": {
            "type": "string"
        },
        "PPMC Start Date": {
            "type": "string"
        }
    }
}

template,

 

 

 

 

I was not able to find to delete this post so thought put answer of this one and close it off,

 

 

Thank you.!

 

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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.

Users online (1,433)