Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Web service as input

  1. #1
    Join Date
    Oct 2007
    Posts
    15

    Default Web service as input

    Hi,

    I have a csv file located on http server.

    What input object should i put in the transformation to get the data from it ?

    Adi.

  2. #2
    Join Date
    Jul 2007
    Posts
    247

    Default

    Depends.

    If it's really a csv file and you can download it, use a http (or maybe better ftp) job entry to get the file and then use the text file input step.

    If it's just some kind of spreadsheet data (html table etc.) it might also work but you'll need a lot of filtering (e.g. html tags).

    Good luck!


    Regards,
    Ben

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    It gets better: you can just use the "Text file input" step directly.
    Ever since version 2.5 we use VFS (Virtual File System from Apache commons) to read from and write to files.

    So basically, the text file input step doesn't care where the file is located: on a webserver, an FTP server, inside a zip file, etc.

    HTH,

    Matt

  4. #4
    Join Date
    Jul 2007
    Posts
    247

    Default

    Cool, didn't think of that


    Impressed - as always,
    Ben

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.