How to peek dead letter queues from Azure Service Bus using Data Factory External Call transformation

Anonymous
2023-04-17T02:16:11.7233333+00:00

I have an Azure Data Factory Data Flow. I am trying to use the External Call GET to peek the Dead Letter queue items. I have authorised the Data Factory as an "Azure Service Bus Data Owner" in the role assignments of the Service bus. I have setup the linked service in Data Factory so that I can pass in the Service Bus queue name URL and this works OK for other transformations.
I have set the Relative URL to the following setting in the External call:

concat($QueueName,"/$DeadLetterQueue/messages/head")

Currently I have it with the settings as following: User's image

User's image

User's image

However I keep getting the error "Failed to fetch data preview due to operation timeout." This makes little sense to me, I definitely have access to the Service Bus, though I expect I am doing something else wrong. Can we not use the GET part of the External Call yet??

Azure Service Bus
Azure Service Bus
An Azure service that provides cloud messaging as a service and hybrid integration.
704 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,657 questions
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,491 Reputation points Microsoft Employee Moderator
    2023-04-17T22:27:27.4733333+00:00

    Hello @Brent Leslie , Thanks for the question and using MS Q&A platform. If you try the below dynamic expression does that help ?

    concat($QueueName,"/",$DeadLetter,"Queue/messages/head")
    

    Thanks
    Himanshu

    Please accept as "Yes" if the answer provided is useful , so that you can help others in the community looking for remediation for similar issues. 


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.