cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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
Highlighted
Helper IV
Helper IV

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.
Highlighted
Frequent Visitor

Re: parsing generic key value pairs

hey

i have the same problem

what i need to do to fix it?

Highlighted
Community Support
Community Support

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
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

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

Users online (3,980)