none
Power Query and FTP. Get last modified date RRS feed

  • Question

  • Hi

    I've got a problem and there might be a simple solution to it, but I can't find it.

    On our FTP-server a csv file is updated 5 times daily. I have a power Query that acceeses this file and filters it for a printing purpose.

     Source = Csv.Document(Web.Contents(" ftp:\\xxx.yyy\text "=" ", Columns=11, Encoding=1252, QuoteStyle=QuoteStyle.None]),

     In order to see when this file was last updated, I would like to retrieve the Modified date from the file on the FTP-server.

    Anyone knows how to do this job ??

    Tuesday, February 6, 2018 2:23 PM

Answers

  • Hi Tommy. I'm not sure there's any way to do this. Do you get anything meaningful if you access the folder the file is contained inside of? For example:

    Csv.Document(Web.Contents("ftp:\\xxx.yyy\"))

    Ehren

    Tuesday, February 6, 2018 9:33 PM
    Owner