Hi all,
I have been trying to connect to JSON webhook payloads from an external tool to append records to a SharePoint list. The issue I am facing is my JSON payload comes in a List style, whereby each data point has a key (the name of the field) and a value (the variable) pairing. These will always be consistently named for all outputs to this Flow, however, I cannot figure out how to access the values as dynamic content under the name of the key.
Can someone help me with setting this up so I can use the keys as dynamic content? I am new to webhooks in the Microsoft world. A test sample of the JSON payload is below:
{
"$content-type": "application/x-www-form-urlencoded; charset=UTF-8",
"$content": "XYZ123xyz321",
"$formdata": [
{
"key": "Alpha_ID",
"value": "12345"
},
{
"key": "Beta_ID",
"value": "263014"
},
{
"key": "Gamma",
"value": "XYZ II"
},
{
"key": "Country",
"value": "United States"
},
{
"key": "Delta_ID",
"value": "2630168"
},
{
"key": "Epsilon_Name",
"value": "Test's Company"
},
{
"key": "Email",
"value": "test@gmail.com"
},
{
"key": "Zeta",
"value": "Test Co."
},
{
"key": "Eta_ID",
"value": "12345"
},
{
"key": "Theta_Name",
"value": "XYZ"
},
{
"key": "State",
"value": "California"
}
]
}
It is important to note that:
- The key-value pairing will not change for this webhook, so I want to be able to use each element
- The format in the sample reflects the format of these fields, and these will not change (but may be null in some cases where not all data is available)
My Flow looks as follows:
Any and all help will be greatly appreciated!
