Power Automate Sharepoint HTTP request unable to parse JSON response Click to Download instead of JSON object

[na44]

Hello,

I am sending an HTTP request through the Sharepoint HTTP activity, however I am unable to parse the response. I think the reason for it is that instead of the JSON object I get a Click to download link in the Outputs. The activities that follow just think there is no content and error. I do not know that this is causing it for sure, but when I use a generic Send HTTP request I always get the response body in the outputs rather than a link.

I would be grateful for any advise on how to either make it show the JSON response, or how to reach/download the response automatically and then parse it to continue the flow.

1) 

2) 

3) When I click to download, the payload is not empty, and I need to get the statusCode

4) The subsequent Parse JSON activity always shows this error

Many thanks!

[Expiscornovus · Accepted solution]

Hi @na44,

I see you are using the body in the Parse Json. However, the status code is not in the body. And it it looks like there is no body property at all in the response. That's probably why it is returning empty.

Can you use this expression instead of the body field in your Parse Json action?

outputs('Send_an_HTTP_request_to_SharePoint_-_Delete_Forms_response')

[na44]

Hi @Expiscornovus 

Thank you for your reply. I used the Body as it was the only thing available so I didn't really give it a second thought.

Entering outputs fails with message Correct to include a valid reference to 'Send_an_HTTP_request_to_SharePoint_-_Delete_Forms_response' for the input parameter(s) of action 'Parse_JSON'.

Many thanks!

[Expiscornovus]

Hi @na44,

I might made a typo in the action name part of the expression. Double check if it is correct.

Alternatively, can you add the expression in a Compose action just before the Parse Json action. Does it work in there?

[na44]

Thank you very much @Expiscornovus, I realised there was a double space in the activity name, once I'd corrected it all worked fine!

[na44]

@Expiscornovus I've also just realised that I used one of your articles about Forms API in my learning, so it's great that I can thank you in "person" 😊. Thank you!!  https://www.expiscornovus.com/2022/04/25/get-microsoft-forms-responses-submitted-today/

[Expiscornovus]

Hi @na44,

Great to hear that blog was useful. Happy to help out with that as well 😁