Powershell azure function to read data from an API and output as excel in blob storage

Question

Hello,

I have a scenario where we need to read data from an API and create an excel file in Azure Blob Storage using Powershell Azure Functions.

Is this possible at all? And if so could you provide a small example?

Best,
Luuk

Answer 1

Since I don't have an Azure Blob available atm I created this script for you too look at.
There are two functions:

• ApiToExcel, this uses the ImportExcel module and creates a local file of any API request you add to it. Please modify to match your API.
• FileToBlob you can pipe a file or more in to this and it should connect and upload the files. (Untested)

There are sources in the code and if this didn't help let me know and I'll look into it when I have my Azure Lab up.

https://github.com/dkaaven/M365-Scripts/blob/main/azure/FileToBlob.ps1

---

If this was helpful, please Upvote and Accept Answer.
Else, please Comment with further information or related questions.