Azure Serverless Computing Cookbook - Second Edition

Durable serverless way of implementing an Excel import

The following diagram shows the necessary steps for building the solution using the serverless architecture:

Each section of the preceding diagram is labeled and explained in the following steps:

1. External clients or applications upload an Excel file to Blob Storage.
2. The Blob Trigger gets triggered after the Excel file is uploaded successfully.
3. A Durable Orchestrator is started from the Blob Trigger.
4. The Orchestrator invokes Read Excel - Activity Trigger to read the Excel content from Blob Storage.
5. The Orchestrator invokes Scale RUs - Activity Trigger to scale up the Cosmos DB collection's ...