Is it possible to export all the data coming from my application insight to Azure sql server?

Akshey 1 Reputation point
2022-05-06T12:14:58.787+00:00

I created an application insight rest service which was fetching the records from events table in Logs Section. The result which i was getting was an Array of Array, over which it was getting difficult for me to iterate over the list. Every time only one entry was getting inserted into my database not the complete list using COPY ACTIVITY.

Is it possible to export certain properties like as in result set i am getting ROWS, so for Rows i wanted to iterate and export this data into my table present in Azure Sql Server?

Sharing my Result set returned from Application Insight rest API.

{
"tables": [
{
"name": "PrimaryResult",
"columns": [
{
"name": "Message",
"type": "dynamic"
}
],
"rows": [
[
"{\"UserId\":\"940f83a5-b69f-467c-bbe1-04372b51fb8a\",\"LoginTimeUtc\":\"2022-04-22T10:48:24.1250000Z\",\"SessionId\":\"2641f229-e988-9854-4e77-f71394e71214\"}"
],
[
"{\"UserId\":\"940f83a5-b69f-467c-bbe1-04372b51fb8a\",\"LoginTimeUtc\":\"2022-04-22T10:49:05.8690000Z\",\"SessionId\":\"0a589ad0-b27c-1705-169a-8308306a35ff\"}"
],
[
"{\"UserId\":\"940f83a5-b69f-467c-bbe1-04372b51fb8a\",\"LoginTimeUtc\":\"2022-04-22T10:50:10.7460000Z\",\"SessionId\":\"f60952cf-7850-56e8-dde1-34a24ef64311\"}"
]
]
}
]
}

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,634 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,179 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Samy Abdul 3,366 Reputation points
    2022-05-06T13:48:55.817+00:00