HTTP Requests with XML as input

(0) Share

Report

Posted on by Maschek

I'm having the following issue:

I need to call an external API with "Report search criteria and export options are passed in request XML file."

How to do this in Power Automate?

I want to use this to automate reporting.

Any help would be great.

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (0)

lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

did you mean to say "Report search criteria and export options are passed as XML in the POST request body/payload" ? Does your external API come with documentation and examples?

Was this reply helpful? Yes No
Maschek 2 on at

Like (0)

Report

Hello,
The documentation for the API can be found here: https://support.blancco.com/display/KB/API+documentation
For example:
Im'having the following XML file (filename:API_XML_Request_test.xml)
<?xml version="1.0" encoding="UTF-8"?>
<request>
<export-report>
<report mode="original"/>
<search path="report.report_date" value="2022-12-01 00:00:00" operator="gt" datatype="date" conjunction="true" />
<search path="report.report_date" value="2023-01-01 00:00:00" operator="lt" datatype="date" conjunction="true" />
<reportColumns>
<columnPath>report.uuid</columnPath>
<columnPath>report.report_date</columnPath>
<columnPath>blancco_data.blancco_hardware_report.system.serial</columnPath>
<columnPath>user_data.fields.Asset ID</columnPath>
</reportColumns>
<csv-options csvLanguage="en_US" delimiter=";" subDelimiter=":"/>
</export-report>
</request>

When running a CURL command
curl --user [Username]:[password] --basic --form "xmlRequest=@API_XML_Request_test.xml" https://cloud.blancco.com:443/rest-service/report/export/csv
on Windows everything works fine.

The question now is how to do this in Power Automate?

Was this reply helpful? Yes No
lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

like this

Was this reply helpful? Yes No