Share via

Azure Data Factory get filename with extension

arkiboys 9,711 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.


Your answer

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