question

Akshey-9810 avatar image
0 Votes"
Akshey-9810 asked ShaikMaheer-MSFT commented

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

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-data-factoryazure-blob-storage
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Samy-7940 avatar image
0 Votes"
Samy-7940 answered ShaikMaheer-MSFT commented
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Akshey-9810 ,

Just checking in to see if the above answer helped. If this answers your query, do click 130616-image.png and upvote 130671-image.png for the same. And, if you have any further query do let us know.

0 Votes 0 ·