Forum Discussion
Create Wallboard from API REST calls
- 1 year ago
hello Darwood
I think you have done most of the hard work to get the authentication and connection done
Now for Web Activity Output Handling
• Use a Set Variable activity to capture the Web Activity response
• Configure the variable to store the complete JSON output
Create Copy Data Activity Setup
• Create a dummy source query using a Fabric Datawarehouse connection
• Use the “Additional Columns” section in the source to define your output schema
• Configure the destination as the Lakehouse Files section
• Map the fields from your variable to the destination columns
check this discussion it will be helpfulIf this helps. Please accept the solution
Thanks
I've managed to get this working by using a ForEach step and putting a Copy Data activity inside of there so it copies one record at a time. It's a very kludgy solution but it's working. I have to say MS Fabric functionality for getting data from an API with OAuth is very poor. It's taken me days just to do what took me about 30m with Grafana.
- nilendraFabric1 year ago
Super User
Apols Darwood I was busy , so didn't got time to look into this.
Happy it worked out.
Could you please accept the solution if this was helpful 🙂