I would like to integrate Azure Application Insights into my Redash Dashboard using the JSON data source. (It would be nice if there was a built in data source for that).
By design from Azure the API key may not be passed in the URL. The only option is to include it in the header when making the cURL request using x-api-key. Is there any possible way to include a header when making the call with the JSON data source or any other way to gain access to Azure Application Insights in Redash?
A typical request would look like:
curl "https://api.applicationinsights.io/v1/apps/<application-id>/metrics/requests/failed?timespan=P7D&interval=P1D" -H "x-api-key: <APIKey>"
Thanks in advance