Page 1 of 1

Data Mapping CSV Data with a HEADER ROW ???

Posted: Sun May 05, 2013 3:34 pm
by J

Let's just suppose for arguments sake that we have an HTTP data source that returns CSV data containing a header row.

How do we

intercept the first row

get the field count

apply them as labels

take the balance of the records and load them as a table.

The question revolves around how best to leverage the pe-existing functionality of the appery platform. Clearly there is an interface to parse json responses and build the data map for UI reference.

How do we port CSV line data with CRLF to the interface?

Is there an engine that carries some of this functionality?

Thanks


Data Mapping CSV Data with a HEADER ROW ???

Posted: Sun May 05, 2013 4:37 pm
by maxkatz

The data returned has to be in JSON or XML format. Assuming you do get JSON or XML - you can pretty much do everything in JavaScript.