Hi ,
I am using HTTP request activity to read table from azure through postman.
Response from HTTP request activity is “string”. But the format in the string is “json”.
How to convert it into jsonArray or Jobject.
My response from HTTP request is like below.
{
“odata.metadata”: “https://mailalerts.table.core.windows.net/$metadata#ProcesOutput”,
“value”: [
{
“odata.etag”: “W/"datetime’2020-01-29T08%3A23%3A56.8947122Z’"”,
“PartitionKey”: “000”,
“RowKey”: “111”,
“Timestamp”: “2020-01-29T08:23:56.8947122Z”,
“AlertClassification”: “222”,
“Status”: “333”
},
{
“odata.etag”: “W/"datetime’2020-01-29T08%3A39%3A51.9392822Z’"”,
“PartitionKey”: “111”,
“RowKey”: “3”,
“Timestamp”: “2020-01-29T08:39:51.9392822Z”,
“AlertClassification”: “222”,
“Status”: “444”
},
{
“odata.etag”: “W/"datetime’2020-01-29T08%3A44%3A05.2526657Z’"”,
“PartitionKey”: “333”,
“RowKey”: “4”,
“Timestamp”: “2020-01-29T08:44:05.2526657Z”,
“AlertClassification”: “444”,
“Status”: “555”
},
{
“odata.etag”: “W/"datetime’2020-01-29T08%3A45%3A55.3104311Z’"”,
“PartitionKey”: “444”,
“RowKey”: “5”,
“Timestamp”: “2020-01-29T08:45:55.3104311Z”,
“AlertClassification”: “555”,
“Status”: “666”
},
{
“odata.etag”: “W/"datetime’2020-01-29T08%3A47%3A36.7592558Z’"”,
“PartitionKey”: “555”,
“RowKey”: “6”,
“Timestamp”: “2020-01-29T08:47:36.7592558Z”,
“AlertClassification”: “666”,
“Status”: “777”
},
{
“odata.etag”: “W/"datetime’2020-01-29T08%3A48%3A47.0490224Z’"”,
“PartitionKey”: “666”,
“RowKey”: “7”,
“Timestamp”: “2020-01-29T08:48:47.0490224Z”,
“AlertClassification”: “777”,
“Status”: “888”
},
{
“odata.etag”: “W/"datetime’2020-01-29T08%3A50%3A42.5404337Z’"”,
“PartitionKey”: “777”,
“RowKey”: “8”,
“Timestamp”: “2020-01-29T08:50:42.5404337Z”,
“AlertClassification”: “888”,
“Status”: “999”
},
{
“odata.etag”: “W/"datetime’2020-01-29T09%3A00%3A19.4768494Z’"”,
“PartitionKey”: “990”,
“RowKey”: “12”,
“Timestamp”: “2020-01-29T09:00:19.4768494Z”,
“AlertClassification”: “234”,
“Status”: “124”
},
{
“odata.etag”: “W/"datetime’2020-01-29T09%3A00%3A45.7971803Z’"”,
“PartitionKey”: “991”,
“RowKey”: “13”,
“Timestamp”: “2020-01-29T09:00:45.7971803Z”,
“AlertClassification”: “234”,
“Status”: “124”
},
{
“odata.etag”: “W/"datetime’2020-01-29T09%3A58%3A23.6318201Z’"”,
“PartitionKey”: “992”,
“RowKey”: “14”,
“Timestamp”: “2020-01-29T09:58:23.6318201Z”,
“AlertClassification”: “234”,
“Status”: “124”
},
{
“odata.etag”: “W/"datetime’2020-01-29T10%3A06%3A23.9400991Z’"”,
“PartitionKey”: “993”,
“RowKey”: “15”,
“Timestamp”: “2020-01-29T10:06:23.9400991Z”,
“AlertClassification”: “234”,
“Status”: “124”
},
{
“odata.etag”: “W/"datetime’2020-01-29T10%3A12%3A57.1744301Z’"”,
“PartitionKey”: “994”,
“RowKey”: “16”,
“Timestamp”: “2020-01-29T10:12:57.1744301Z”,
“AlertClassification”: “234”,
“Status”: “124”
},
{
“odata.etag”: “W/"datetime’2020-01-29T10%3A38%3A30.2758967Z’"”,
“PartitionKey”: “994”,
“RowKey”: “17”,
“Timestamp”: “2020-01-29T10:38:30.2758967Z”,
“AlertClassification”: “234”,
“Status”: “124”
},
{
“odata.etag”: “W/"datetime’2020-01-29T10%3A39%3A24.2328095Z’"”,
“PartitionKey”: “995”,
“RowKey”: “18”,
“Timestamp”: “2020-01-29T10:39:24.2328095Z”,
“AlertClassification”: “234”,
“Status”: “124”
},
{
“odata.etag”: “W/"datetime’2020-01-29T10%3A43%3A36.768028Z’"”,
“PartitionKey”: “996”,
“RowKey”: “19”,
“Timestamp”: “2020-01-29T10:43:36.768028Z”,
“AlertClassification”: “234”,
“Status”: “124”
},
{
“odata.etag”: “W/"datetime’2020-01-29T10%3A44%3A38.9712818Z’"”,
“PartitionKey”: “997”,
“RowKey”: “20”,
“Timestamp”: “2020-01-29T10:44:38.9712818Z”,
“AlertClassification”: “234”,
“Status”: “124”
},
{
“odata.etag”: “W/"datetime’2020-01-29T10%3A48%3A51.7970712Z’"”,
“PartitionKey”: “998”,
“RowKey”: “21”,
“Timestamp”: “2020-01-29T10:48:51.7970712Z”,
“AlertClassification”: “234”,
“Status”: “124”
},
{
“odata.etag”: “W/"datetime’2020-01-29T08%3A55%3A25.1585651Z’"”,
“PartitionKey”: “999”,
“RowKey”: “10”,
“Timestamp”: “2020-01-29T08:55:25.1585651Z”,
“AlertClassification”: “234”,
“Status”: “124”
},
{
“odata.etag”: “W/"datetime’2020-01-29T08%3A59%3A20.4549844Z’"”,
“PartitionKey”: “999”,
“RowKey”: “11”,
“Timestamp”: “2020-01-29T08:59:20.4549844Z”,
“AlertClassification”: “234”,
“Status”: “124”
},
{
“odata.etag”: “W/"datetime’2020-01-29T08%3A15%3A30.0628562Z’"”,
“PartitionKey”: “ads”,
“RowKey”: “bsd”,
“Timestamp”: “2020-01-29T08:15:30.0628562Z”,
“AlertClassification”: “hs”,
“Status”: “gssd”
},
{
“odata.etag”: “W/"datetime’2020-01-29T08%3A17%3A46.0373888Z’"”,
“PartitionKey”: “xyz”,
“RowKey”: “abc”,
“Timestamp”: “2020-01-29T08:17:46.0373888Z”,
“AlertClassification”: “123”,
“Status”: “sdf”
}
]
}
I hope because of below lines I am not able to convert into datatable or jarray.
“odata.metadata”: “https://mailalerts.table.core.windows.net/$metadata#ProcesOutput”,
“value”:
Do you have any idea how to get response without getting those line from postman using http request.
Can you please help.