How to export data from Application Insights using c#?

Question

Hi,

How to easily export data to excel using any api service which will be a timer trigger and get data for particular period.

Regards,

K Samthrusha.

Answer 1

@KuppiReddygariSamthrushaReddy-3789 Welcome to Microsoft Q & A Community Forum and thank you for reaching out with your query.

Regarding your ask, have you already reviewed the option to export to excel from the Application insights using the existing available options. Here are some already available solutions.

• Assuming you are using workspace-based application insights, you can refer this document on exporting log data using M query and log analytics API : https://learn.microsoft.com/en-us/azure/azure-monitor/logs/log-excel
• You can also export data to excel using logic app connectors which also can be scheduled as per your requirement. Here is the document where the data is being sent to storage account using logic apps, it can be modified to be sent to Excel using the existing logic app connectors.
• To export data using C#, you can use the REST API to retrieve the data. Here are some articles to get started.
  • https://learn.microsoft.com/en-us/azure/azure-monitor/logs/api/overview
  • https://learn.microsoft.com/en-us/dotnet/api/overview/azure/Monitor.Query-readme?view=azure-dotnet