Answered

Array from JSON Objects

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (1)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
AmriiBacchus 22 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
AmriiBacchus 22 on at

Like (1)

Report
Copy link

Link copied!

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"
},

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
AmriiBacchus 22 on at

Like (1)

Report
Copy link

Link copied!

Yes I gave access to all the numbers

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @AmriiBacchus

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

Thanks

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @AmriiBacchus

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

Was this reply helpful? Yes No
AmriiBacchus 22 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @AmriiBacchus

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

https://youtu.be/8Se_yZqpN60

Thanks

Was this reply helpful? Yes No
AmriiBacchus 22 on at

Like (1)

Report
Copy link

Link copied!

Great thank you!

Was this reply helpful? Yes No