Hi,
I have been able to successfully connect to a Web Service and it successfully returns data. The data returned is in JSON format or at least that's what the Web Service documentation says. It kind of looks like CSV formatted data.
I would like to know how to use this data returned by the Web Service. The HTTP Web Request activity exposes it's output as "Content File" to other activities. What is the suggested next steps in using this data?
My goal is to insert this data, row by row, into a SQL table.
Thanks
Sheldon