Skip to main content
J
Jose33137-Bedrock
7-Bedrock
November 25, 2024
Solved

Download CSV file in Power Automate

  • November 25, 2024
  • 1 reply
  • 1386 views

Is it possible to get the CSV file of the URL link of the email that is sent from the Data Monitor in Power Automate?

 

I enter the URL link and put in the Headers the Basic authorization, but it does not work. Is something missing in the settings?

 

I use the same URL link and Headers settings in Power BI to get data from a web data source and it works.

 

Jose3313_0-1732547126746.png

 

 

Best answer by rhart

THe following url can output or download the results of query builder reports as CSV and other formats.

 

https://<windchill_host>/Windchill/servlet/WindchillAuthGW/wt.enterprise.URLProcessor/URLTemplateAction?oid=OR%3Awt.query.template.ReportTemplate%3A<report_ID>&action=ExecuteReport&format=formatDelegate&delegateName=CSV

 

Use the custom input page to select an output format, wtcore\jsp\report\reportGenForm.jsp, then generate the report and copy the url.

 

2024-12-02_145922.png

 

Should be OK to use that in power automate, I have used it in powerquery/automate too with basic auth from power desktop and report server

1 reply

R
rhart16-PearlAnswer
16-Pearl
December 2, 2024

THe following url can output or download the results of query builder reports as CSV and other formats.

 

https://<windchill_host>/Windchill/servlet/WindchillAuthGW/wt.enterprise.URLProcessor/URLTemplateAction?oid=OR%3Awt.query.template.ReportTemplate%3A<report_ID>&action=ExecuteReport&format=formatDelegate&delegateName=CSV

 

Use the custom input page to select an output format, wtcore\jsp\report\reportGenForm.jsp, then generate the report and copy the url.

 

2024-12-02_145922.png

 

Should be OK to use that in power automate, I have used it in powerquery/automate too with basic auth from power desktop and report server

    A
    aaronjlarson14-Alexandrite
    14-Alexandrite
    December 2, 2024

    I think this is one part of the answer.  The OP states needing to grab the URL from the Data Monitor which leads me to believe that - yes, the intent is to ingest the resulting file from the Data Monitor link into Power Automate.  If the Data Monitor has multiple runs then just knowing one URL to give Power Automate (a static input) will not work if you intent to get the latest file output from the Data Monitor.  The URL will change over time with each execution of the Data Monitor.  I did something similar once

     

    aaronjlarson_0-1733166012903.png

    With this subselect to narrow down the criteria to a single Data Monitor (hard coded) and also the latest "saved report holder" in the Data Monitor, i.e. the URL/file from the last execution.  This is done with subselect just finding the latest "saved report holder" with the latest modified date.

    aaronjlarson_1-1733166138594.png

    In my case I was using this to return an XML payload to Power Automate.  The way I had it setup was Power Automate would call this report and ingest the result which included the dynamic parts of the URL.  Then I would create the full Data Monitor URL in Power Automate by combining with the static parts of the URL - done all using variables. Then I could make another HTTP GET request to the full URL that would provide the full payload of the executed Data Monitor "file".  

      J
      Jose33137-BedrockAuthor
      7-Bedrock
      December 3, 2024

      Thanks

      Terms & ConditionsAccessibility statement