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 ...
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