1

Hi I have some data in azure log analytics workspace, and have a requirement where we need to display the data retrieved from azure to my UI. Below is the query that i tried

"<tablename> | take 2"

And the result i received is

{
    "tables": [
      {
        "name": "PrimaryResult",
        "columns": [
          {
            "name": "TenantId",
            "type": "string"
          },
          {
            "name": "TimeGenerated",
            "type": "datetime"
          },
          {
            "name": "Message",
            "type": "string"
          },
          {
            "name": "SeverityLevel",
            "type": "int"
          },
          {
            "name": "Properties",
            "type": "dynamic"
          }
        ],
        "rows": [
          [
            "242d7831-a5b0-4f0d-8324-acf22f51a9aa",
            "2023-06-07T16:11:35.834Z",
            "In Hanlder/getRolesDetailByRolename",
            1,
            "{\"service_name\":\"tenant-service\",\"environment\":\"dev\"}"
          
          ],
            [
            "242d7831-a5b0-4f0d-8324-acf22f51a9aa",
            "2023-06-07T16:15:40.834Z",
            "In Hanlder",
            1,
            "{\"service_name\":\"language-service\",\"environment\":\"dev\"}"
          
          ]
        ]
      }
    ]
  }

My requirement here is to performed pagination and send the data result as below to my UI

{
  "columns": [
    {
      "name": "TenantId",
      "type": "string"
    },
    {
      "name": "TimeGenerated",
      "type": "datetime"
    },
    {
      "name": "Message",
      "type": "string"
    },
    {
      "name": "SeverityLevel",
      "type": "int"
    },
    {
      "name": "Properties",
      "type": "dynamic"
    }
  ],
  "docs": [
    {
      "TenantId": "242d7831-a5b0-4f0d-8324-acf22f51a9aa",
      "TimeGenerated": "2023-06-07T16:11:35.834Z",
      "Message": "In Hanlder/getRolesDetailByRolename",
      "SeverityLevel": 1,
      "Properties": "{\"service_name\":\"tenant-service\",\"environment\":\"dev\"}"
    },
    {
      "TenantId": "242d7831-a5b0-4f0d-8324-acf22f51a9aa",
      "TimeGenerated": "2023-06-07T16:15:40.834Z",
      "Message": "In Hanlder",
      "SeverityLevel": 1,
      "Properties": "{\"service_name\":\"language-service\",\"environment\":\"dev\"}"
    }
  ],
  "totalDocs": 122,
  "limit": 10,
  "totalPages": 13,
  "page": 1,
  "pagingCounter": 1,
  "hasPrevPage": false,
  "hasNextPage": true,
  "prevPage": null,
  "nextPage": 2
}


I came across some thing called https://learn.microsoft.com/en-us/azure/data-explorer/kusto/management/stored-query-results ,But i am stuck as how to achieve it. Kindly guide as how to proceed further

Sindhu1990
  • 85
  • 6

0 Answers0