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

Sangeetha Priya S 210 Reputation points
2023-04-10T05:16:36.9233333+00:00

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 User's image
  5. Header tab User's image
  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"
   }
Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
487 questions
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 79,141 Reputation points Microsoft Employee
    2023-04-11T09:18:07.67+00:00

    @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).

    User's image

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

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

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

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful