Support for ODATA, Socrata, CKAN endpoints
Options
UserBird
Dataiker, Alpha Tester Posts: 535 Dataiker
Hi there - Im on the trial version and wanted to connect to a dataset that is hosted on a Socrata open data platform. Ex: https://data.smgov.net/Public-Services/Water-Usage/4nnq-5vzx
which has multiple endpoints like:
ODATA: https://data.smgov.net/OData.svc/4nnq-5vzx
JSON: https://data.smgov.net/resource/4nnq-5vzx.json
or even connect via HTTP to a CSV: https://data.smgov.net/api/views/4nnq-5vzx/rows.csv?accessType=DOWNLOAD
Similar question for accessing datasets in data.gov or other hosted open data platforms.
Thanks!
which has multiple endpoints like:
ODATA: https://data.smgov.net/OData.svc/4nnq-5vzx
JSON: https://data.smgov.net/resource/4nnq-5vzx.json
or even connect via HTTP to a CSV: https://data.smgov.net/api/views/4nnq-5vzx/rows.csv?accessType=DOWNLOAD
Similar question for accessing datasets in data.gov or other hosted open data platforms.
Thanks!
Tagged:
Answers
-
In a Project, go to the datasets list, then click the "+ New Dataset" button, then Network > FTP / HTTP / SSH / SFTP. You can then add URLs of files to use as source for your dataset.
See the documentation on HTTP datasets.
For open data platform that require an API to fetch the data, you can write your own Dataiku DSS plugin to achieve that. -
Thanks!
Here is the error I get on trying :
https://data.smgov.net/OData.svc/4nnq-5vzx
or
https://data.smgov.net/api/views/4nnq-5vzx/rows.csv?accessType=DOWNLOAD
hostname in certificate didn't match: != <2014bonds.cityofws.org> OR <2014bonds.cityofws.org> -
I can reproduce, we'll look into this
-
Thanks much! I believe ticket #2270 was created for this
http://support.dataiku.com/public/tickets/92d7eb001ff97e628c538715566bb18fccd037d75efb13bc250fe96000314f16
