cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
phil4mat
Level: Powered On

parsing generic key value pairs

I have  some data pushed to Flow as an HTTP request received in the format below:

I've tried various json parse, compose, select and conditional workflow options.

However I can't find an efficient way to get each subitems keys and values into a variable structure so that I can send this to a stored procedure. This is just multiple fields for one record update. Can anyone help? 

 

{
"$content-type": "application/x-www-form-urlencoded",
"$content": "sdsdfsdfsdfsdf",
"$formdata": [
{
"key": "type",
"value": "update"
},
{
"key": "date_time",
"value": "2018-12-03T15:00:47-06:00"
},
{
"key": "initiated_from",
"value": "admin"
},
{
"key": "initiated_by",
"value": "admin"
},
{
"key": "list",
"value": "0"
},
{
"key": "contact[id]",
"value": "3870"
},
{
"key": "contact[email]",
"value": "x@x.com"
},
{
"key": "contact[first_name]",
"value": "xxx"
},
{
"key": "contact[last_name]",
"value": "xxx"
},
{
"key": "contact[phone]",
"value": ""
},
{
"key": "contact[ip]",
"value": "127.0.0.1"
},
{
"key": "contact[tags]",
"value": "test1,test2,test3"
},
{
"key": "contact[fields][14]",
"value": "2018-11-30"
},
{
"key": "contact[fields][17]",
"value": "85"
},
{
"key": "contact[fields][18]",
"value": "1481526"
},
{
"key": "contact[fields][7]",
"value": "sdfaswasf"
},
{
"key": "contact[orgname]",
"value": "asdgawfa"
},
{
"key": "orgname",
"value": "asfasdf"
}
]
}

3 REPLIES 3
tfhegdbn
Level: Powered On

Re: parsing generic key value pairs

Hi @phil4mat,

 

I have tried a lot on my side, it seems that "$content-type": "application/x-www-form-urlencoded" affects the entire process.
Without this, it is easy to get the value you want by traversing.
yairxx
Level: Powered On

Re: parsing generic key value pairs

hey

i have the same problem

what i need to do to fix it?

Community Support Team
Community Support Team

Re: parsing generic key value pairs

Hi @phil4mat,

 

Is your problem solved? If not, please refer to a similar Thread:

https://powerusers.microsoft.com/t5/Connecting-To-Data/Problem-with-Parsing-formdata/m-p/198580#M421...

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,955)