Forum Discussion

andre_mangatal's avatar
andre_mangatal
New Contributor
7 years ago

Help Needed! Best Snap/Technique To Process Incoming Raw CSV Data

Good day Snaplogic Community,

I am querying a Rest API which returns a text string which represent a delimited list with commas(,) but the list doesn’t have the header/column names but I know what the data represents.

What is the best method and snaps to use to convert this incoming string delimited by commas and convert it to JSON

Thanks so much!

Best regards
Andre

2 Replies

  • tk42's avatar
    tk42
    New Contributor III
    7 years ago

    Assuming that you have a response from the api that has a field with the value as a CSV string, you can map that field to $[‘content’] in a Mapper, then use a Document to Binary Snap to convert to “binary” and then use a CSV Parser to create the JSON docs (SL documents).

    hope this helps.

    TK

    • andre_mangatal's avatar
      andre_mangatal
      New Contributor
      7 years ago

      Hi thanks a lot TK… i tried and it worked … much appreciated