topic Re: Call API with body from Report in Custom Visuals Development Discussion

Call API with body from Report

MegaOctane1 — Tue, 21 Nov 2023 20:31:14 GMT

Er have a AR report and our invoice distributor had an api that can return a pdf copy of an invoice. It is a POST api, but if we include customer number and invoice number, it returns a pdf. I have had it work with python.

I was thinking of integrating this in the report.

How could the user for example click on an invoice number, or enter the invoice number somewhere and trigger a request to get the invoice...

Or should I integrate a power app in the power bi?

Re: Call API with body from Report

lbendlin — Fri, 24 Nov 2023 19:36:11 GMT

Yes, PowerApp or Python visual is pretty much your only choice if you want to keep the user inside the report.

Re: Call API with body from Report

MegaOctane1 — Fri, 24 Nov 2023 20:04:08 GMT

I ended up doing it with power automate. I pass on customer and invoice number to the power automate visual. When it is triggered, it uses the HTTP connector to send a API request. It returns the pdf, that is then saved to a sharepoint library, and then finally email it to the requestor.