Array from JSON Objects

[AmriiBacchus]

I am building a flow that receives a JSON payload from an API, I want to add these daily to a MS List.  Problem it is coming in as individual objects.  My understanding of JSON and  API's but here is part of my schema

{

    "type": "object",

    "properties": {

        "100271": {

            "type": "object",

            "properties": {

                "Branch": {

                    "type": "string"

                },

                "Name": {

                    "type": "string"

                },

                "BigCBasics": {

                    "type": "string"

                },

                "Progress": {

                    "type": "string"

                },

                "Assigned": {

                    "type": "string"

                },

                "Completed": {

                    "type": "string"

                },

                "CertificateDate": {

                    "type": "string"

                },

                "RewardDate": {

                    "type": "string"

                }

            }

        },

There are several of those 6 digit numbers 1 for each person actually... What I would like to do is just take the information for each person and put into the list.  Parsing the JSON just makes a variable for every single one.  Any insight would be amazing.  Thanks

[abm]

Hi @AmriiBacchus 

So you want to extract Branch, Name, BigCBasics, Progress, etc against the six digit numbers 100271 and create a record in SharePoint list? Could you also provide some sample JSON data? 

Thanks

[AmriiBacchus]

Actually I would prefer to make a record for each one of the numbers which there are several.  So an array that creates an item in SP for each one of those groups, I cannot use the number since it will have to be rewritten each time someone is added.  I think there is something like 40 unique numbers each containing those strings inside. 

[AmriiBacchus]

Here is a portion with actual data

},
"104267": {
"Branch": "SB",
"Name": "Miss",
"BigCBasics": "Inside Sales",
"Progress": "100%",
"Assigned": "2022/10/13",
"Completed": "2022/04/19",
"CertificateDate": "2022/04/20",
"RewardDate": "2022/04/20"
},
"104285": {
"Branch": "Ke",
"Name": "Dustin ",
"BigCBasics": "Yard & Driver",
"Progress": "5.56%",
"Assigned": "2022/10/14",
"Completed": "n/a",
"CertificateDate": "n/a",
"RewardDate": "n/a"
},

[abm]

Hi @AmriiBacchus 

Thanks for providing the data. So every time these numbers (104267, 104285)  can get changed? Do you have a definitive list of all 40 unique numbers?

[AmriiBacchus]

Yes I gave access to all the numbers 

[abm]

Hi @AmriiBacchus 

I will work on a flow based on the data above and post something soon.

Thanks

[abm]

Hi @AmriiBacchus 

Do you need to insert those six digit numbers also in your list?

[AmriiBacchus]

I do not, in fact prefer the numbers to not be a factor as new ones will often be introduced.  

[abm · Accepted solution]

Hi @AmriiBacchus 

I made a tutorial video based on this. Please have a look and let me know.

https://youtu.be/8Se_yZqpN60

Thanks

[AmriiBacchus]

Great thank you!