Calling APIs from KQL??

Copper Contributor

Is it possible to make API calls from KQL/query explorer?

2 Replies
You can use the externaldata operation in KQL -
But this is rather limited as there is no way to authenticate.

If you need access to an API that requires authentication, you should write a Logic App and use that

@Thijs Lecomte - 

I have used externaldata operator to fetch data from a CSV having a few columns namely, IP ranges, country code, country name, continent name etc.

In Azure Activity table there is a CallerIP value.

I need to print the location for each caller Ip.


CSV file -


Can you help me with the KQL??