Use of logic App to read JSON file from blob container with dynamic directory

Question

Use of logic App to read JSON file from blob container with dynamic directory

Sandor TOTH 20

Hi,

I am trying to read yml file exported from Log Analytics workspace by using logic app. It fails with 404 do not find the file. I do not see differnce in output and the link to the data in blob

workspace is bound with ER traffic collector give updates every 5 minutes

{ "status": 404, "message": "Specified resource /am-atcexpressroutecircuitipfix/WorkspaceResourceId=/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourcegroups/prd-netcs-erdirect-westeu-01/providers/microsoft.operationalinsights/workspaces/erdirect-ams-trafficcollector-log/y=2025/m=08/d=28/h=07/m=43/PT5M.json not found.\r\nclientRequestId: 7cf43ce9-64b9-4f28-a332-a9bde2c55960", "error": { "message": "Specified resource /am-atcexpressroutecircuitipfix/WorkspaceResourceId=/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourcegroups/prd-netcs-erdirect-westeu-01/providers/microsoft.operationalinsights/workspaces/erdirect-ams-trafficcollector-log/y=2025/m=08/d=28/h=07/m=45/PT5M.json not found." }, "source": "azureblob-we.azconn-we-002.p.azurewebsites.net" }

The URL of the file is
https://ertrafficcollectorsa.blob.core.windows.net/am-atcexpressroutecircuitipfix/WorkspaceResourceId=/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourcegroups/prd-netcs-erdirect-westeu-01/providers/microsoft.operationalinsights/workspaces/erdirect-ams-trafficcollector-log/y=2025/m=08/d=28/h=07/m=45/PT5M.json

Thanks for your review in adv.....
The Logic app code is

{
    "definition": {
        "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
        "contentVersion": "1.0.0.0",
        "triggers": {
            "When_a_resource_event_occurs": {
                "type": "ApiConnectionWebhook",
                "inputs": {
                    "host": {
                        "connection": {
                            "name": "@parameters('$connections')['azureeventgrid-1']['connectionId']"
                        }
                    },
                    "body": {
                        "properties": {
                            "topic": "/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourceGroups/prd-netcs-erdirect-westeu-01/providers/Microsoft.Storage/storageAccounts/ertrafficcollectorsa",
                            "destination": {
                                "endpointType": "webhook",
                                "properties": {
                                    "endpointUrl": "@listCallbackUrl()"
                                }
                            },
                            "filter": {
                                "includedEventTypes": [
                                    "Microsoft.Storage.BlobCreated"
                                ],
                                "subjectBeginsWith": "/blobServices/default/containers/am-atcexpressroutecircuitipfix/WorkspaceResourceId=/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourcegroups/prd-netcs-erdirect-westeu-01/providers/microsoft.operationalinsights/workspaces/erdirect-ams-trafficcollector-log/",
                                "subjectEndsWith": ".json"
                            }
                        }
                    },
                    "path": "/subscriptions/@{encodeURIComponent('9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2')}/providers/@{encodeURIComponent('Microsoft.Storage.StorageAccounts')}/resource/eventSubscriptions",
                    "queries": {
                        "x-ms-api-version": "2017-09-15-preview"
                    }
                }
            }
        },
        "actions": {
            "Log_Blob_Path": {
                "runAfter": {},
                "type": "Compose",
                "inputs": "@coalesce(triggerBody()?['data']?['url'], 'no-url')"
            },
            "Get_blob_content_(V2)": {
                "runAfter": {
                    "Lists_blobs_(V2)": [
                        "Succeeded"
                    ]
                },
                "trackedProperties": {
                    "BlobData": "@outputs('Get_blob_content_(V2)')"
                },
                "limit": {
                    "timeout": "PT1M"
                },
                "type": "ApiConnection",
                "inputs": {
                    "host": {
                        "connection": {
                            "name": "@parameters('$connections')['azureblob']['connectionId']"
                        }
                    },
                    "method": "get",
                    "path": "/v2/datasets/@{encodeURIComponent(encodeURIComponent('ertrafficcollectorsa'))}/files/@{encodeURIComponent(encodeURIComponent('/am-atcexpressroutecircuitipfix/WorkspaceResourceId=/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourcegroups/prd-netcs-erdirect-westeu-01/providers/microsoft.operationalinsights/workspaces/erdirect-ams-trafficcollector-log/y=',formatDateTime(utcNow(),'yyyy'),'/m=',formatDateTime(utcNow(),'MM'),'/d=',formatDateTime(utcNow(),'dd'),'/h=',formatDateTime(utcNow(),'HH'),'/m=',formatDateTime(utcNow(),'mm'),'/'))}/content",
                    "queries": {
                        "inferContentType": true
                    }
                }
            },
            "HTTP": {
                "runAfter": {
                    "Get_blob_content_(V2)": [
                        "Succeeded"
                    ]
                },
                "trackedProperties": {
                    "StatusCode": "@outputs('HTTP')?['statusCode']"
                },
                "limit": {
                    "timeout": "PT1M"
                },
                "type": "Http",
                "inputs": {
                    "uri": "https://hec-splunk.tnz.nld9.paas.westeurope.prdcur.az.amadeus.net/services/collector/event",
                    "method": "POST",
                    "headers": {
                        "Splunk": "12fdf828-fd10-4796-bba8-09446706ae99",
                        "Content-Type": "application/json"
                    },
                    "body": {
                        "time": "",
                        "host": "fw-ertrafficcollector-log-to-splunk-LApp",
                        "source": "azure_blob",
                        "sourcetype": "_json",
                        "event": "@body('Get_blob_content_(V2)')"
                    }
                },
                "runtimeConfiguration": {
                    "contentTransfer": {
                        "transferMode": "Chunked"
                    }
                }
            },
            "Lists_blobs_(V2)": {
                "runAfter": {
                    "Log_Blob_Path": [
                        "Succeeded"
                    ]
                },
                "metadata": {
                    "JTJmYW0tYXRjZXhwcmVzc3JvdXRlY2lyY3VpdGlwZml4": "/am-atcexpressroutecircuitipfix"
                },
                "type": "ApiConnection",
                "inputs": {
                    "host": {
                        "connection": {
                            "name": "@parameters('$connections')['azureblob']['connectionId']"
                        }
                    },
                    "method": "get",
                    "path": "/v2/datasets/@{encodeURIComponent(encodeURIComponent('AccountNameFromSettings'))}/foldersV2/@{encodeURIComponent(encodeURIComponent('/am-atcexpressroutecircuitipfix/WorkspaceResourceId=/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourcegroups/prd-netcs-erdirect-westeu-01/providers/microsoft.operationalinsights/workspaces/erdirect-ams-trafficcollector-log/y=',formatDateTime(utcNow(),'yyyy'),'/m=',formatDateTime(utcNow(),'MM'),'/d=',formatDateTime(utcNow(),'dd'),'/h=',formatDateTime(utcNow(),'HH'),'/m=',formatDateTime(utcNow(),'mm'),'/PT5M.json'))}",
                    "queries": {
                        "nextPageMarker": "",
                        "useFlatListing": true
                    }
                }
            }
        },
        "outputs": {},
        "parameters": {
            "$connections": {
                "type": "Object",
                "defaultValue": {}
            }
        }
    },
    "parameters": {
        "$connections": {
            "type": "Object",
            "value": {
                "azureeventgrid-1": {
                    "id": "/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/providers/Microsoft.Web/locations/westeurope/managedApis/azureeventgrid",
                    "connectionId": "/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourceGroups/prd-netcs-erdirect-westeu-01/providers/Microsoft.Web/connections/azureeventgrid-1",
                    "connectionName": "azureeventgrid-1"
                },
                "azureblob": {
                    "id": "/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/providers/Microsoft.Web/locations/westeurope/managedApis/azureblob",
                    "connectionId": "/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourceGroups/prd-netcs-erdirect-westeu-01/providers/Microsoft.Web/connections/azureblob",
                    "connectionName": "azureblob"
                }
            }
        }
    }
}
                        "sourcetype": "_json",
                        "event": "@body('Get_blob_content_(V2)')"
                    }
                },
                "runtimeConfiguration": {
                    "contentTransfer": {
                        "transferMode": "Chunked"
                    }
                }
            },
            "Lists_blobs_(V2)": {
                "runAfter": {
                    "Log_Blob_Path": [
                        "Succeeded"
                    ]
                },
                "metadata": {
                    "JTJmYW0tYXRjZXhwcmVzc3JvdXRlY2lyY3VpdGlwZml4": "/am-atcexpressroutecircuitipfix"
                },
                "type": "ApiConnection",
                "inputs": {
                    "host": {
                        "connection": {
                            "name": "@parameters('$connections')['azureblob']['connectionId']"
                        }
                    },
                    "method": "get",
                    "path": "/v2/datasets/@{encodeURIComponent(encodeURIComponent('AccountNameFromSettings'))}/foldersV2/@{encodeURIComponent(encodeURIComponent('/am-atcexpressroutecircuitipfix/WorkspaceResourceId=/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourcegroups/prd-netcs-erdirect-westeu-01/providers/microsoft.operationalinsights/workspaces/erdirect-ams-trafficcollector-log/y=',formatDateTime(utcNow(),'yyyy'),'/m=',formatDateTime(utcNow(),'MM'),'/d=',formatDateTime(utcNow(),'dd'),'/h=',formatDateTime(utcNow(),'HH'),'/m=',formatDateTime(utcNow(),'mm'),'/PT5M.json'))}",
                    "queries": {
                        "nextPageMarker": "",
                        "useFlatListing": true
                    }
                }
            }
        },
        "outputs": {},
        "parameters": {
            "$connections": {
                "type": "Object",
                "defaultValue": {}
            }
        }
    },
    "parameters": {
        "$connections": {
            "type": "Object",
            "value": {
                "azureeventgrid-1": {
                    "id": "/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/providers/Microsoft.Web/locations/westeurope/managedApis/azureeventgrid",
                    "connectionId": "/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourceGroups/prd-netcs-erdirect-westeu-01/providers/Microsoft.Web/connections/azureeventgrid-1",
                    "connectionName": "azureeventgrid-1"
                },
                "azureblob": {
                    "id": "/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/providers/Microsoft.Web/locations/westeurope/managedApis/azureblob",
                    "connectionId": "/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourceGroups/prd-netcs-erdirect-westeu-01/providers/Microsoft.Web/connections/azureblob",
                    "connectionName": "azureblob"
                }
            }
        }
    }
}

Sandor TOTH 20 Reputation points

2025-08-28T09:09:56.3233333+00:00

In summary, I would like to ask about your experience with Logic Apps working with blob containers that have deeply nested, dynamically built structures.
Praveen Kumar Gudipudi 1,495 Reputation points Microsoft External Staff Moderator

2025-08-28T09:45:31.1433333+00:00

Sandor TOTH,

Could you please share a screenshot of the Logic App Designer showing exactly where you're encountering this error?
Sandor TOTH 20 Reputation points

2025-09-01T07:58:25.4133333+00:00

Screenshot 2025-09-01 095636.png
Sandor TOTH 20 Reputation points

2025-09-01T07:58:47.29+00:00

Screenshot 2025-09-01 095652.png
Sandor TOTH 20 Reputation points

2025-09-01T07:59:52.78+00:00

Screenshot 2025-09-01 095933.png
Sandor TOTH 20 Reputation points

2025-09-01T08:09:56.4466667+00:00

Hi Praveen,

My cents: Because of the 5-minute intervals, it may not find the file immediately. However, I assume the event triggers the read once the blob is updated
Praveen Kumar Gudipudi 1,495 Reputation points Microsoft External Staff Moderator

2025-09-01T09:46:09.9033333+00:00

Sandor TOTH,

Could you please clink on Show Raw outputs and share me the error details that would help us to understand root cause.

If you found uploaded blob name is correct in raw outputs, we can add delay action between event trigger and list blobs action would help you to resolve this issue.

Sandor TOTH 20

Input

{
    "method": "get",
    "queries": {
        "nextPageMarker": "",
        "useFlatListing": "True"
    },
    "path": "/v2/datasets/AccountNameFromSettings/foldersV2/%252Fam-atcexpressroutecircuitipfix%252FWorkspaceResourceId%253D%252Fsubscriptions%252F9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2%252Fresourcegroups%252Fprd-netcs-erdirect-westeu-01%252Fproviders%252Fmicrosoft.operationalinsights%252Fworkspaces%252Ferdirect-ams-trafficcollector-log%252Fy%253D2025%252Fm%253D08%252Fd%253D28%252Fh%253D07%252Fm%253D43%252FPT5M.json",
    "host": {
        "connection": {
            "name": "/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourceGroups/prd-netcs-erdirect-westeu-01/providers/Microsoft.Web/connections/azureblob"
        }
    }
}

Output

{
    "statusCode": 404,
    "headers": {
        "Cache-Control": "no-store, no-cache",
        "Pragma": "no-cache",
        "Set-Cookie": "ARRAffinity=f7a16db6be2f870d36effc44bbd4a537657e5d385d1aa06fd08aa2a9e0840d97;Path=/;HttpOnly;Secure;Domain=azureblob-we.azconn-we-002.p.azurewebsites.net,ARRAffinitySameSite=f7a16db6be2f870d36effc44bbd4a537657e5d385d1aa06fd08aa2a9e0840d97;Path=/;HttpOnly;SameSite=None;Secure;Domain=azureblob-we.azconn-we-002.p.azurewebsites.net",
        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
        "x-ms-request-id": "7cf43ce9-64b9-4f28-a332-a9bde2c55960",
        "X-Content-Type-Options": "nosniff",
        "X-Frame-Options": "DENY",
        "x-ms-connection-parameter-set-name": "keyBasedAuth",
        "x-ms-subscription-id": "9CFC029E-CD84-4BD3-B3BB-7CFA9095E6C2",
        "x-ms-dlp-re": "-|-",
        "x-ms-dlp-gu": "-|-",
        "x-ms-dlp-ef": "-|-/-|-|-",
        "x-ms-mip-sl": "-|-|-|-",
        "x-ms-au-caller-id": "b2d75074-5eef-43ac-864b-2719daf51175",
        "x-ms-au-creator-id": "c0e68448-0a20-4460-8863-169d23cd0e64",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "false",
        "x-ms-apihub-obo": "false",
        "Date": "Thu, 28 Aug 2025 07:43:12 GMT",
        "Content-Length": "796",
        "Content-Type": "application/json",
        "Expires": "-1"
    },
    "body": {
        "status": 404,
        "message": "Specified resource /am-atcexpressroutecircuitipfix/WorkspaceResourceId=/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourcegroups/prd-netcs-erdirect-westeu-01/providers/microsoft.operationalinsights/workspaces/erdirect-ams-trafficcollector-log/y=2025/m=08/d=28/h=07/m=43/PT5M.json not found.\r\nclientRequestId: 7cf43ce9-64b9-4f28-a332-a9bde2c55960",
        "error": {
            "message": "Specified resource /am-atcexpressroutecircuitipfix/WorkspaceResourceId=/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourcegroups/prd-netcs-erdirect-westeu-01/providers/microsoft.operationalinsights/workspaces/erdirect-ams-trafficcollector-log/y=2025/m=08/d=28/h=07/m=43/PT5M.json not found."
        },
        "source": "azureblob-we.azconn-we-002.p.azurewebsites.net"
    }
}

Praveen Kumar Gudipudi 1,495 Reputation points Microsoft External Staff Moderator

2025-09-01T11:34:13.4233333+00:00

Sandor TOTH,

I can confirm you that instead of Blob details you are passing /am-atcexpressroutecircuitipfix/WorkspaceResourceId=/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourcegroups/prd-netcs-erdirect-westeu-01/providers/microsoft.operationalinsights/workspaces/erdirect-ams-trafficcollector-log/y=2025/m=08/d=28/h=07/m=43/PT5M.json this.

If you wanted to read the file, please use blob "get content" connector.

Sandor TOTH 20

The step after List Blobs is Get Blob Content. I removed List Blobs, but got the same error.

{
    "method": "get",
    "queries": {
        "inferContentType": "True"
    },
    "path": "/v2/datasets/ertrafficcollectorsa/files/%252Fam-atcexpressroutecircuitipfix%252FWorkspaceResourceId%253D%252Fsubscriptions%252F9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2%252Fresourcegroups%252Fprd-netcs-erdirect-westeu-01%252Fproviders%252Fmicrosoft.operationalinsights%252Fworkspaces%252Ferdirect-ams-trafficcollector-log%252Fy%253D2025%252Fm%253D09%252Fd%253D01%252Fh%253D12%252Fm%253D11%252F/content",
    "host": {
        "connection": {
            "name": "/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourceGroups/prd-netcs-erdirect-westeu-01/providers/Microsoft.Web/connections/azureblob"
        }
    }
}

{
    "statusCode": 404,
    "headers": {
        "Cache-Control": "no-store, no-cache",
        "Pragma": "no-cache",
        "Set-Cookie": "ARRAffinity=8484fb3d90c3d36e5b1e48ba2fb9c171f2967b2e02d3fc0cf6ad37cb692fb867;Path=/;HttpOnly;Secure;Domain=azureblob-we.azconn-we-002.p.azurewebsites.net,ARRAffinitySameSite=8484fb3d90c3d36e5b1e48ba2fb9c171f2967b2e02d3fc0cf6ad37cb692fb867;Path=/;HttpOnly;SameSite=None;Secure;Domain=azureblob-we.azconn-we-002.p.azurewebsites.net",
        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
        "x-ms-request-id": "bb2d6b06-9cc9-4779-8f34-fb4aea3f4000",
        "X-Content-Type-Options": "nosniff",
        "X-Frame-Options": "DENY",
        "x-ms-connection-parameter-set-name": "keyBasedAuth",
        "x-ms-subscription-id": "9CFC029E-CD84-4BD3-B3BB-7CFA9095E6C2",
        "x-ms-dlp-re": "-|-",
        "x-ms-dlp-gu": "-|-",
        "x-ms-dlp-ef": "-|-/-|-|-",
        "x-ms-mip-sl": "-|-|-|-",
        "x-ms-au-caller-id": "b2d75074-5eef-43ac-864b-2719daf51175",
        "x-ms-au-creator-id": "c0e68448-0a20-4460-8863-169d23cd0e64",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "false",
        "x-ms-apihub-obo": "false",
        "Date": "Mon, 01 Sep 2025 12:11:29 GMT",
        "Content-Length": "778",
        "Content-Type": "application/json",
        "Expires": "-1"
    },
    "body": {
        "status": 404,
        "message": "Specified resource /am-atcexpressroutecircuitipfix/WorkspaceResourceId=/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourcegroups/prd-netcs-erdirect-westeu-01/providers/microsoft.operationalinsights/workspaces/erdirect-ams-trafficcollector-log/y=2025/m=09/d=01/h=12/m=11/ not found.\r\nclientRequestId: bb2d6b06-9cc9-4779-8f34-fb4aea3f4000",
        "error": {
            "message": "Specified resource /am-atcexpressroutecircuitipfix/WorkspaceResourceId=/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourcegroups/prd-netcs-erdirect-westeu-01/providers/microsoft.operationalinsights/workspaces/erdirect-ams-trafficcollector-log/y=2025/m=09/d=01/h=12/m=11/ not found."
        },
        "source": "azureblob-we.azconn-we-002.p.azurewebsites.net"
    }
}

Sandor TOTH 20 Reputation points

2025-09-01T12:13:29.31+00:00
Praveen Kumar Gudipudi 1,495 Reputation points Microsoft External Staff Moderator

2025-09-01T12:25:14.6733333+00:00

Sandor TOTH,

Could you please check the Container name and blob name that you're passing in the get blob connector.

Pass the correct dynamic value to identify the correct blob.
Sandor TOTH 20 Reputation points

2025-09-01T12:52:33.5333333+00:00
Sandor TOTH 20 Reputation points

2025-09-01T12:53:37.6566667+00:00
Sandor TOTH 20 Reputation points

2025-09-01T12:54:47+00:00
Praveen Kumar Gudipudi 1,495 Reputation points Microsoft External Staff Moderator

2025-09-01T14:14:57.79+00:00

Sandor TOTH,

We need to pass only blob name: am-atcexpressroutecircuititipfix

And remove remaining data using function expressions.

Example: /am-atcexpressroutecircuititipfix/extradata
Use split(split('/am-atcexpressroutecircuititipfix/extradata','/')[1],'/')[0]

If you need any assistance, please feel free contact with us.

Sandor TOTH 20

Screenshot 2025-09-01 165337

{
    "method": "get",
    "queries": {
        "inferContentType": "True"
    },
    "path": "/v2/datasets/ertrafficcollectorsa/files/%2528split%2528%2527%252Fam-atcexpressroutecircuitipfix%2527%252C%2527%252F%2527%2529%255B1%255D%252C%2527%252F%2527%2529%255B0%255D/content",
    "host": {
        "connection": {
            "name": "/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourceGroups/prd-netcs-erdirect-westeu-01/providers/Microsoft.Web/connections/azureblob"
        }
    }
}

output

{
    "statusCode": 400,
    "headers": {
        "Cache-Control": "no-store, no-cache",
        "Pragma": "no-cache",
        "Set-Cookie": "ARRAffinity=bd6c882710cca13120e54acd4193c5c104f43f065c365902bc979074d224293f;Path=/;HttpOnly;Secure;Domain=azureblob-we.azconn-we-002.p.azurewebsites.net,ARRAffinitySameSite=bd6c882710cca13120e54acd4193c5c104f43f065c365902bc979074d224293f;Path=/;HttpOnly;SameSite=None;Secure;Domain=azureblob-we.azconn-we-002.p.azurewebsites.net",
        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
        "x-ms-request-id": "3999db70-0194-4b08-b4c3-cd8a36a389c2",
        "X-Content-Type-Options": "nosniff",
        "X-Frame-Options": "DENY",
        "x-ms-connection-parameter-set-name": "keyBasedAuth",
        "x-ms-subscription-id": "9CFC029E-CD84-4BD3-B3BB-7CFA9095E6C2",
        "x-ms-dlp-re": "-|-",
        "x-ms-dlp-gu": "-|-",
        "x-ms-dlp-ef": "-|-/-|-|-",
        "x-ms-mip-sl": "-|-|-|-",
        "x-ms-au-caller-id": "b2d75074-5eef-43ac-864b-2719daf51175",
        "x-ms-au-creator-id": "c0e68448-0a20-4460-8863-169d23cd0e64",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "false",
        "x-ms-apihub-obo": "false",
        "Date": "Mon, 01 Sep 2025 14:53:15 GMT",
        "Content-Length": "236",
        "Content-Type": "application/json",
        "Expires": "-1"
    },
    "body": {
        "status": 400,
        "message": "InvalidResourceName\r\nclientRequestId: 3999db70-0194-4b08-b4c3-cd8a36a389c2",
        "error": {
            "message": "InvalidResourceName"
        },
        "source": "azureblob-we.azconn-we-002.p.azurewebsites.net"
    }
}

{
    "statusCode": 400,
    "headers": {
        "Cache-Control": "no-store, no-cache",
        "Pragma": "no-cache",
        "Set-Cookie": "ARRAffinity=bd6c882710cca13120e54acd4193c5c104f43f065c365902bc979074d224293f;Path=/;HttpOnly;Secure;Domain=azureblob-we.azconn-we-002.p.azurewebsites.net,ARRAffinitySameSite=bd6c882710cca13120e54acd4193c5c104f43f065c365902bc979074d224293f;Path=/;HttpOnly;SameSite=None;Secure;Domain=azureblob-we.azconn-we-002.p.azurewebsites.net",
        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
        "x-ms-request-id": "3999db70-0194-4b08-b4c3-cd8a36a389c2",
        "X-Content-Type-Options": "nosniff",
        "X-Frame-Options": "DENY",
        "x-ms-connection-parameter-set-name": "keyBasedAuth",
        "x-ms-subscription-id": "9CFC029E-CD84-4BD3-B3BB-7CFA9095E6C2",
        "x-ms-dlp-re": "-|-",
        "x-ms-dlp-gu": "-|-",
        "x-ms-dlp-ef": "-|-/-|-|-",
        "x-ms-mip-sl": "-|-|-|-",
        "x-ms-au-caller-id": "b2d75074-5eef-43ac-864b-2719daf51175",
        "x-ms-au-creator-id": "c0e68448-0a20-4460-8863-169d23cd0e64",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "false",
        "x-ms-apihub-obo": "false",
        "Date": "Mon, 01 Sep 2025 14:53:15 GMT",
        "Content-Length": "236",
        "Content-Type": "application/json",
        "Expires": "-1"
    },
    "body": {
        "status": 400,
        "message": "InvalidResourceName\r\nclientRequestId: 3999db70-0194-4b08-b4c3-cd8a36a389c2",
        "error": {
            "message": "InvalidResourceName"
        },
        "source": "azureblob-we.azconn-we-002.p.azurewebsites.net"
    }
}

Sandor TOTH 20 Reputation points

2025-09-01T15:00:23.2233333+00:00

I guess in case of the path this is what you suggested...
/v2/datasets/ertrafficcollectorsa/files/(split('/am-atcexpressroutecircuitipfix','/')[1],'/')[0]/content
Praveen Kumar Gudipudi 1,495 Reputation points Microsoft External Staff Moderator

2025-09-01T16:02:31.6366667+00:00

Sandor TOTH,

Please share me the raw output of event connector. I will guide on configuration.
Krishna Chowdary Paricharla 2,915 Reputation points Microsoft External Staff Moderator

2025-09-01T16:18:53.18+00:00

Sandor TOTH,

Could you please check the private message and provide the required details for troubleshooting the issue further.

Here is the reference link on how to access & data retention policy of private messages in Microsoft Q&A.
Sandor TOTH 20 Reputation points

2025-09-04T07:46:43.91+00:00

Hi, thanks for getting back to me.

I also think it's best to handle this issue privately.

The reason I'm using this platform is that opening a service request (SR) related to Logic Apps doesn’t seem possible—or at least, I'm not aware of how to do it.

I suggest we start by sharing my email and setting up a session. If that’s acceptable to you, please let me know. Otherwise, we can continue this conversation privately here.

The first link didn’t work for me.
Praveen Kumar Gudipudi 1,495 Reputation points Microsoft External Staff Moderator

2025-09-15T16:05:16.87+00:00

Sandor TOTH,

Could you please check the private message and provide the required details for troubleshooting the issue further.

Here is the reference link on how to access & data retention policy of private messages in Microsoft Q&A.

Answer accepted by question author

0 additional answers

Your answer

Sandor TOTH 20 Reputation points

2025-08-28T09:09:56.3233333+00:00

In summary, I would like to ask about your experience with Logic Apps working with blob containers that have deeply nested, dynamically built structures.
Praveen Kumar Gudipudi 1,495 Reputation points Microsoft External Staff Moderator

2025-08-28T09:45:31.1433333+00:00

Sandor TOTH,

Could you please share a screenshot of the Logic App Designer showing exactly where you're encountering this error?
Sandor TOTH 20 Reputation points

2025-09-01T07:58:25.4133333+00:00

Screenshot 2025-09-01 095636.png
Sandor TOTH 20 Reputation points

2025-09-01T07:58:47.29+00:00

Screenshot 2025-09-01 095652.png
Sandor TOTH 20 Reputation points

2025-09-01T07:59:52.78+00:00

Screenshot 2025-09-01 095933.png
Sandor TOTH 20 Reputation points

2025-09-01T08:09:56.4466667+00:00

Hi Praveen,

My cents: Because of the 5-minute intervals, it may not find the file immediately. However, I assume the event triggers the read once the blob is updated
Praveen Kumar Gudipudi 1,495 Reputation points Microsoft External Staff Moderator

2025-09-01T09:46:09.9033333+00:00

Sandor TOTH,

Could you please clink on Show Raw outputs and share me the error details that would help us to understand root cause.

If you found uploaded blob name is correct in raw outputs, we can add delay action between event trigger and list blobs action would help you to resolve this issue.
Praveen Kumar Gudipudi 1,495 Reputation points Microsoft External Staff Moderator

2025-09-01T11:34:13.4233333+00:00

Sandor TOTH,

I can confirm you that instead of Blob details you are passing /am-atcexpressroutecircuitipfix/WorkspaceResourceId=/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourcegroups/prd-netcs-erdirect-westeu-01/providers/microsoft.operationalinsights/workspaces/erdirect-ams-trafficcollector-log/y=2025/m=08/d=28/h=07/m=43/PT5M.json this.

If you wanted to read the file, please use blob "get content" connector.
Sandor TOTH 20 Reputation points

2025-09-01T12:13:29.31+00:00
Praveen Kumar Gudipudi 1,495 Reputation points Microsoft External Staff Moderator

2025-09-01T12:25:14.6733333+00:00

Sandor TOTH,

Could you please check the Container name and blob name that you're passing in the get blob connector.

Pass the correct dynamic value to identify the correct blob.
Sandor TOTH 20 Reputation points

2025-09-01T12:52:33.5333333+00:00
Sandor TOTH 20 Reputation points

2025-09-01T12:53:37.6566667+00:00
Praveen Kumar Gudipudi 1,495 Reputation points Microsoft External Staff Moderator

2025-09-01T14:14:57.79+00:00

Sandor TOTH,

We need to pass only blob name: am-atcexpressroutecircuititipfix

And remove remaining data using function expressions.

Example: /am-atcexpressroutecircuititipfix/extradata
Use split(split('/am-atcexpressroutecircuititipfix/extradata','/')[1],'/')[0]

If you need any assistance, please feel free contact with us.
Sandor TOTH 20 Reputation points

2025-09-01T15:00:23.2233333+00:00

I guess in case of the path this is what you suggested...
/v2/datasets/ertrafficcollectorsa/files/(split('/am-atcexpressroutecircuitipfix','/')[1],'/')[0]/content
Praveen Kumar Gudipudi 1,495 Reputation points Microsoft External Staff Moderator

2025-09-01T16:02:31.6366667+00:00

Sandor TOTH,

Please share me the raw output of event connector. I will guide on configuration.
Krishna Chowdary Paricharla 2,915 Reputation points Microsoft External Staff Moderator

2025-09-01T16:18:53.18+00:00

Sandor TOTH,

Could you please check the private message and provide the required details for troubleshooting the issue further.

Here is the reference link on how to access & data retention policy of private messages in Microsoft Q&A.
Sandor TOTH 20 Reputation points

2025-09-04T07:46:43.91+00:00

Hi, thanks for getting back to me.

I also think it's best to handle this issue privately.

The reason I'm using this platform is that opening a service request (SR) related to Logic Apps doesn’t seem possible—or at least, I'm not aware of how to do it.

I suggest we start by sharing my email and setting up a session. If that’s acceptable to you, please let me know. Otherwise, we can continue this conversation privately here.

The first link didn’t work for me.
Praveen Kumar Gudipudi 1,495 Reputation points Microsoft External Staff Moderator

2025-09-15T16:05:16.87+00:00

Sandor TOTH,

Could you please check the private message and provide the required details for troubleshooting the issue further.

Here is the reference link on how to access & data retention policy of private messages in Microsoft Q&A.

Answer 1

Sandor TOTH,,

Issue: { "status": 404, "message": "Specified resource /am-atcexpressroutecircuitipfix/WorkspaceResourceId=/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourcegroups/prd-netcs-erdirect-westeu-01/providers/microsoft.operationalinsights/workspaces/erdirect-ams-trafficcollector-log/y=2025/m=08/d=28/h=07/m=43/PT5M.json not found.\r\nclientRequestId: 7cf43ce9-64b9-4f28-a332-a9bde2c55960", "error": { "message": "Specified resource /am-atcexpressroutecircuitipfix/WorkspaceResourceId=/subscriptions/9cfc029e-cd84-4bd3-b3bb-7cfa9095e6c2/resourcegroups/prd-netcs-erdirect-westeu-01/providers/microsoft.operationalinsights/workspaces/erdirect-ams-trafficcollector-log/y=2025/m=08/d=28/h=07/m=45/PT5M.json not found." }, "source": "azureblob-we.azconn-we-002.p.azurewebsites.net" } error in blob connector.

Resolution: By increasing the action time out limit to PT10M issue got resolved.

Please accept as answer and do a Thumbs-up to upvote this response if you are satisfied with the community help. Your upvote will be beneficial for the community users facing similar issues.

User's image

Share via

Use of logic App to read JSON file from blob container with dynamic directory

0 additional answers

Your answer