Invoking API with json input and output.

I have a table in my powerbi dashboard with a column of text. The data source is azure sql table.

I want to invoke an API by passing this text in the form of a json string of documents. The api will return be a json of documents that I need to put it back in my report.

What is the recommended way to make the API call?

Should I write a wrapper API that will read from the table and convert to Json and call the api to get back the json and convert it and put it in Azure sql to be consumed by my report or is there a better oob way of plumbing this

Thanks

Gyan

0 REPLIES 0

Helpful resources

Announcements

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Details

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.