Skip to content

Big-Data/data-converters

 
 

Repository files navigation

Data Converters

Web services for converting data from one format to another. The converters accept data as a query parameter named url. There's already CORS support and JSOP (add callback parameter to the URL). Empty column names will be auto-generated with column_1, column_2, etc. Duplicate column names will have _n added as well. For instance, two columns with name date will be date_1, date_2.

User stories are on Google Docs, if you want to add more, please file an issue.

Please bugs for any issues you see.

CSV -> JSON

Converter automatically detects mime-type, if your file's mime-type is not "text/csv" or "text/comma-separated-values", add type=csv to the url.

Example - http://converter.dev.okfn.org/api/convert/json?url=http://resources.opendatalabs.org/u/nigelb/data-converters/csv/simple.csv

Example with type - http://converter.dev.okfn.org/api/convert/json?url=http://resources.opendatalabs.org/u/nigelb/data-converters/csv/simple.csv&type=csv

Example with JSONP - http://converter.dev.okfn.org/api/convert/json?url=http://resources.opendatalabs.org/u/nigelb/data-converters/csv/simple.csv&callback=callback

XLS(X) -> JSON

If your file's mime-type is not "application/excel", "application/vnd.ms-excel", or 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', add type=xls to the url. If your file is an xls file, add type=xls&excel_type=xlsx.

Example - http://converter.dev.okfn.org/api/convert/json?url=http://resources.opendatalabs.org/u/nigelb/data-converters/xls/simple.xls

Example with type - http://converter.dev.okfn.org/api/convert/json?url=http://resources.opendatalabs.org/u/nigelb/data-converters/xls/simple.xls&type=xls

Example of xlsx file with type - http://converter.dev.okfn.org/api/convert/json?url=http://resources.opendatalabs.org/u/nigelb/data-converters/xls/simple.xlsx&type=xls&excel_type=xlsx

About

Web services for converting data from one format to another

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published