Rest API Sink FileName-Definition RRS feed

  • Question

  • Hi,

    i get Data from a REST-API. I save this Date in a Data Lake Gen2 Folder. 

    After the file was created, this name was given


    Can I assign a different name for this file myself like this? "SapData_2019-06-05"



    Nicole ;)

    Answer from MSDN

    Thursday, June 6, 2019 9:30 AM


  • Can you please check the filename which you are passing to the activity ? We have seen that when NO filename is passed its creates a GUID ( as in this case ) , please check .

    To the second part of the question you can use the dynamic expression like this .

    @concat('SapData_',formatDateTime(utcnow(),'yyyy'),'/',formatDateTime(utcnow(),'MM'),'/',formatDateTime(utcnow(),'dd'),'/',formatDateTime(addhours(utcnow(),-1),'hh')  )

    as file/folder name and it should work .

    Please do let us know how it goes .

    Thanks Himanshu

    • Proposed as answer by HimanshuSinha-msft Thursday, June 6, 2019 10:42 PM
    • Marked as answer by Nicole44 Thursday, June 13, 2019 5:50 PM
    Thursday, June 6, 2019 10:42 PM