Need help with azure workbook and function app

Ashwin Venkatesha 230 Reputation points

Hi, I am trying to use a function app to make an api call to our product. I am not doing this operation from the workbook itself because I end up doing multiple api calls and lots of heavy lifting is done in workbook, instead I want the function app to do parsing, transformations/aggregations and store this data "somewhere".
Once stored, I want the workbook to access this location and visualize the data.

I am thinking, storage browser's table storage.

I have about 8 widgets that work with same api response data, so its 8 aggregations/views of same response.

How do you suggest handling this? Am i thinking this right?

Store in table storage and leverage the same in azure workbook? If yes, how to leverage that in azure workbook.

Another requirement is, I want this function app to be running every 5mins, so the data that is fetched for each run has to update what is in the table, not create additional rows.

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,938 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,512 questions
0 comments No comments
{count} votes

Accepted answer
  1. AnuragSingh-MSFT 20,996 Reputation points

    @Ashwin Venkatesha, thank you for posting this question here on Microsoft Q&A.

    I have broken down my response below to cover all the scenarios mentioned in the question:

    1. Trigger Function App on schedule (use timer trigger Azure Functions) and store data. I would not suggest using the Azure Storage Account, as it is not natively mentioned as one of the data sources for "the "Azure MonitorWorkbook". For set of data sources available for Azure Monitor Workbook, please refer to this link - Azure Workbooks data sources Instead, storing the returned information in a LA workspace would be a better choice where KQL can be used to query for required aggregations/insights. The Azure function can have the code in it to send the response received from APIs to LA workspace using the Logs Ingestion API in Azure Monitor. This method would allow for flexible queries directly from the Workbook to present visualization.
    2. The rows in LA workspace table cannot be updated/overwritten. The queries could be written to scan only the latest data received (or that has been received in the last 5 minutes as Azure Function runs every 5 minutes). If you are concerned about the cost, you could keep the retention to a minimum so that the logs do not grow much.

    If the answer did not help, please add more context/follow-up question for it. Else, if the answer helped, please click Accept answer so that it can help others in the community looking for help on similar topics.

0 additional answers

Sort by: Most helpful