Azure Data Factory get filename with extension

arkiboys 9,686 Reputation points
2024-02-27T11:38:54.8266667+00:00

Hello, In ADF I have a linked service connection to a website such as https://www.xyz.com/-/data/archive/
In the relative url I am using below expression to get the filename with extension.
This is fine but now I want the linkedservice to behttps://www.xyz.com/ and make the relative url to be dynamic so that which ever path comes after [.com] then I can get the full filename thank you

@concat('MOI-',formatDateTime(dataset().p_CurrentDate,'dd'), '-',formatDateTime(dataset().p_CurrentDate,'MMM'),'-',formatDateTime(dataset().p_CurrentDate,'yyyy'),'.csv')
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,564 questions
{count} votes

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.