How to get Azure data explorer data to Angular UI using rest API or by Angular Java

Question

Hi, I am trying to show Azure data explorer data in (Angular Java) UI interface. I found that data explorer provides REST API to get the data from table using Kusto query. https://learn.microsoft.com/en-us/azure/data-explorer/kusto/api/rest/request I have tried the same using GET Method from postman but ended up with 400 bad request. I could not resolve this issue and could not find any example for the same. I have attached snaps. Can you please help here to fetch data from ADX table using rest api.

1. I have generated Bearer token using app registration in Azure portal. I can generate token successfully.
2. I have used GET method using bearer token
3. GET https://CLUSTERNAME.LOCATION.kusto.windows.net/v1/rest/query?db=TestDatabase&csl=print "Hello, World!"
4. Query Parameter tab
5. Header tab
6. response of bearer token

   {
       "token_type": "Bearer",
       "expires_in": "3599",
       "ext_expires_in": "3599",
       "expires_on": "1681024277",
       "not_before": "1681020377",
       "resource": "https://api.kusto.windows.net",
       "access_token": "eyJ0e........7C8QHbyQ"
   }

Answer 1

@Sangeetha Priya S - Thanks for the question and using MS Q&A platform.

The HTTP response status line follows the HTTP standard response codes. . For example, code 400 BadRequest Request is badly formed and failed (permanently).

Here are the steps to Query/management HTTP request using postman. Step1: Obtain a token for authentication.

Step2: HTTP POST request for a query. Note: Request body should be as shown below.

Hope this helps. Do let us know if you any further queries.