Data360 Analyze

 View Only

  • 1.  connect the HTTP node to the Excel File node

    Employee
    Posted 05-01-2019 10:10
    Dear all,
     
    Hope you can help me work through this problem.
     
    If I want to use the HTTP node to download the file directly through URL and then connect the HTTP node to the Excel File node for further reading, how can I do that? I have tried but failed with errors. I guess I should set some properties to be certain values but still failed. 
     
     
     
    Sincerely,
    Loretta


  • 2.  RE: connect the HTTP node to the Excel File node

    Employee
    Posted 05-01-2019 15:24

    Hi Loretta - attached sample below.

    I did try to download the file link you provided but had problems with a security exception - so the root url may have certification against it which I didnt add into my trusted certs in d360. However the attached flow does work by using the http node to get the file, load locally and then passes the file name into the excel node for reading.

    there are a couple of errors but maybe someone else can help out on them.

    Thanks

    Martin

     

    Attached files

    http-2-excel - 1 May 2019.lna

     



  • 3.  RE: connect the HTTP node to the Excel File node

    Employee
    Posted 05-01-2019 19:00

    Thank you for your help, Martin! I guess this is something tricky. I also have the security problem of reading your file and an ssh certificate needs to be added.