Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: PDI Rest API outputting CSV data can not be processed

  1. #1
    Join Date
    Mar 2016
    Posts
    2

    Default PDI Rest API outputting CSV data can not be processed

    I have a PDI rest api transformation which returns a file consisting of: Result field containing 2 header rows and data in a CSV format. I then need to process this data in another transformation to get a CSV format I can load into a table. The issue, I cannot find a transformation that can process the Result field and separate it out from the CSV file which I need to then load. I have tried several transformation including the Text File Input transformation. The transformation appears to have a problem separating/ removing the result field information. If I remove the Result field information (Result word and related quotes) manually in an editor I can then process the CSV file fine. Any ideas how to approach or a resolution to my problem?

    I did a similar process where I called the rest api transformation retrieving Json data which I successfully transformed into a DB table. However this exercise where the CSV data from the rest api is to be processed has been a challenge.

    Any thoughts or pointers?

  2. #2

    Default

    Could you please attached an example of your CSV file you generated in the first step?

    Hugo

  3. #3
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Text-File-Input isn't able to read a CSV-file from a field.
    You'll have to use Split-Field-To-Rows to separate the lines.
    If you are lucky you can use Split-Fields, then, to separate the fields.
    So long, and thanks for all the fish.

Tags for this Thread

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.