Convert unicode from API Endpoint (csv) to csv or jason or pydataset

[Mahesh_Madapathi]

I made a HTTP request to a CSV API Endpoint. I used
response = system.net.httpGet(url,'','','','',header)

and the response received is of 'unicode type.

type(response)
<type 'unicode'>

How can I convert it to a dataset?

[bkarabinchak.psi]

It would be helpful to see what the response actually is.

But if it's a CSV, I would imagine it's just a long string with values separated by ',' and '\n' or similar to denote end of lines.

So you could split on '\n' to get the lines and then split on ',' to get the values.

But this is pure speculation unless we can see what the response actually is.

[PGriffith]

You can use Python's csv module to parse the CSV, then construct your dataset yourself:

Perspective onFileReceived - CSV

If you want to use Python’s built-in csv module, you need to construct a file-like object to pass to the reader. Luckily, Python also predicted the idea of interpreting a string in memory as a ‘file-like’ object, so the StringIO module already exists. What you want is probably something like this: from StringIO import StringIO fileContents = event.file.getString("UTF-8") reader = csv.DictReader(StringIO(fileContents)) for row in reader: print row

https://docs.inductiveautomation.com/display/DOC81/system.dataset.toDataSet

[Mahesh_Madapathi]

It started off well, but I see this error

[Mahesh_Madapathi]

this helped.
No errors now.

Csv file import - Error: Cannot create PyString with non-byte value - #3 by PGriffith

I think I am set for now. I just need to convert it to dataset.