How to get the http request Json data into excel sheet?

Hi team,

I want create a flow iam getting the json format data from the http request the format is i don’t know how it will come but i have 2 keys in json which are doctype which holds the type of document is it and exacted_data which holds the data of all the fileds on base of doc type i want to write that perticular json file into different excel files.

can any help will flow

format of http request output:

{
“doc_type”: “custom_document”,
“extracted_data”: {
“amount”: [“456.0”, “5255”, etc…,]
simillar way there are some fileds some are in list some or in not list as shown like “amount”: [“”]
}
}

@naveen5 , not sure where exactly you are facing the issue.

image

"Doc Type is: " + jobjContent("doc_type").ToString
"Amounts are: " + String.Join(", ", jobjContent("extracted_data").Item("amount"))