โ02-05-2019 09:23 AM
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
โ02-08-2019 11:36 AM
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
โ02-11-2019 12:27 PM
Hi thanks a lot TKโฆ i tried and it worked โฆ much appreciated