Unanswered

HTTP request

(0) Share

Report

Posted on by TT126

Hi,

I am using power automate and creating a cloud flow and I’m trying to output the body and status code of my GET HTTP request, as XML then need to parse JSON and then output into a document.

I have put together a compose after my HTTP request with the following expression

xml(outputs(‘HTTP’)[‘statusCode’]?[‘body’])

However I am getting the below error message when trying to run the flow

InvalidTemplate. Unable to process template language expressions in action ‘Compose’. The template language expression cannot be evaluated because property ‘body’ cannot be selected. Property selection is not supported on values of type ‘Integer’.

Any help would be greatly appreciated

Thanks

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @TT126

The status code is integer and xml only accepts string and object as data type. You can try the following technique for this:

Save the status code like this in a compose:

Then in another compose save with the expression: xml(outputs('Compose'))

Just a question, why are you converting it to xml?

If this works for you, you can accept it as the solution, and if you liked the explanation, you can give a thumbs up, it really helps.
Thanks.

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report
Hi @TT126 ,

I think the following will reference the status code:

body('HTTP')?['statusCode']

Example: body('HTTP')?['success'] references the success property below:

{ "success": true, "historical": true, "base": "GBP", "date": "2022-02-01", "rates": { "EUR": 1.200205 } }

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
TT126 6 on at

Like (0)

Report

Hi @ekarim2020 ,

Thank you for your assistance

However when I try the expression you have advised, I am getting no inputs and outputs from the compose in my run history?

thanks

Was this reply helpful? Yes No
TT126 6 on at

Like (0)

Report

Hi @Sundeep_Malik

Thanks for your assistance also

although when I try to run the flow I get an error on the compose 2 which states the below

Unable to process template language expressions in action. The template language function ‘xml’ parameter is not valid. The provided value cannot be converted to xml

thanks

Was this reply helpful? Yes No