Compose Outputs link in Logic App Run History does not show result. How can I view that result?

Bill House 0 Reputation points
2024-03-14T17:51:54.8633333+00:00

The Logic App accepts an EventGrid storage Blob Create event via a WebHook. A series of Compose actions the parse the rootFolder, inputFolder and inputFile (the blob name). Then there is a Switch action to evaluate the rootFolder and start the appropriate ADF pipeline to process the data into Azure SQL. The Compose uses the subject attribute to try and get those values.

The subject attribute of the WebHook:

"subject": "/blobServices/default/containers/candid-source/blobs/betterlife/input-contracts/betterlife-contracts-2.json"

The rootFolder compose:

"split(triggerBody()?['subject'], '/')[5]"

I need the result of the rootFolder Compose to be "betterlife". Any suggestions will be much appreciated.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,133 questions
{count} votes

1 answer

Sort by: Most helpful
  1. VenkateshDodda-MSFT 20,696 Reputation points Microsoft Employee
    2024-03-20T04:23:36.71+00:00

    @Bill House Thanks for reaching out to Microsoft Q&A, apologize for any inconvenience caused on this.

    If your subject property follows this pattern "/containers/<container-name>/blobs/<blobName>" always then you can use the below expression in compose action of your logic app.

    • Apply the split at /blobs instead of applying split on special character '/'

    split(last(split(string(triggerBody()?['subject']),'/blobs')),'/')[1]

    Hope this helps, let me know if you have any further questions on this.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.