model.json@snapshot=2021-12-29T13:43:11.8221557Z
model.json@snapshot=2021-12-29T15:42:47.6820754Z
model.json@snapshot=2022-01-02T13:57:44.4572616Z
Then I plan to set that file name to a variable and use as a parameter in a Get Blob Content action.
I should also note that the output from the Lists Blob V2 action is a JSON object, which I then pass to a Create CSV table that generates the lines pasted above. I need to get the JSON member for the most recent datetime (in red below), so maybe it is not necessary to make the csv first. How can I extract/query the member with the recent datetime? Here is the JSON output from the List blobs action:
[
{
"Id": "xxxxx==",
"Name": "model.json@snapshot=2021-12-29T13:43:11.8221557Z",
"DisplayName": "model.json@snapshot=2021-12-29T13:43:11.8221557Z",
"Path": "/powerbi/Azure test/Excel Datasource via Gateway/model.json.snapshots/model.json@snapshot=2021-12-29T13:43:11.8221557Z",
"LastModified": "2021-12-29T13:43:11Z",
"Size": 1267,
"MediaType": "application/octet-stream",
"IsFolder": false,
"ETag": "\"xxxxx\"",
"FileLocator": "xxxxx=="
},
{
"Id": "xxxxx==",
"Name": "model.json@snapshot=2021-12-29T15:42:47.6820754Z",
"DisplayName": "model.json@snapshot=2021-12-29T15:42:47.6820754Z",
"Path": "/powerbi/Azure test/Excel Datasource via Gateway/model.json.snapshots/model.json@snapshot=2021-12-29T15:42:47.6820754Z",
"LastModified": "2021-12-29T15:42:47Z",
"Size": 1587,
"MediaType": "application/octet-stream",
"IsFolder": false,
"ETag": "\"xxxxx\"",
"FileLocator": "xxxxx=="
},
{
"Id": "xxxxx==",
"Name": "model.json@snapshot=2022-01-02T13:57:44.4572616Z",
"DisplayName": "model.json@snapshot=2022-01-02T13:57:44.4572616Z",
"Path": "/powerbi/Azure test/Excel Datasource via Gateway/model.json.snapshots/model.json@snapshot=2022-01-02T13:57:44.4572616Z",
"LastModified": "2022-01-02T13:57:44Z",
"Size": 1587,
"MediaType": "application/octet-stream",
"IsFolder": false,
"ETag": "\"xxxxx\"",
"FileLocator": "xxxxx=="
}
]
