CSV

CSV (comma separated text file) provides an easy way of storing simple tabular data. CSV datasources allow you to create a data service using a CSV file as the data storage type.

You can get the Add New Datasource screen shown below on the management console by executing steps 1 to 3 in creating a data service. Then, select CSV as the Datasource Type. It opens the CSV-specific options as shown below: 

  The fields in the above page are as follows:

• CSV File Location: The sample csv file used in the above example is hosted by USGS, the science organization that hosts latest earthquake information in CSV files online. We use a sample file hosted online but you can also use one in your local machine.
•  Column separator values:
  
  • Single Character = "X" (X is any character), e.g. ","
  • Tab = "\t"
  • Space = "\s"
  • Any Unicode Character = "\uXXXX" (XXXX is the hexadecimal unicode value)
• Start Reading From Row: 
• Max. Rows to Read: 
• Contains Column Header Row: If this is true, the first row will be considered as the header. It is ignored and the data from the next row is taken. 

To write a query to this data source, see Writing Data Service Queries.

Also, see a demonstration of service enabling a CSV file in CSV Sample.