Introduction
This API is based on version 1 of the Kobo API with some significant extensions.
To use the examples you will need to enter a user id and password. However if you are already logged on to the server you should see your own data.
- user: api
- password: api
Data
This API gives you access to data that has been submitted to the server
| Service | Format | Description | Version | Example |
|---|---|---|---|---|
| /api/v1/data | JSON | Get a list of services to retrieve form data | 15.12+ | https://sg.smap.com.au/api/v1/data |
| /api/v1/data/{key} | JSON | Get submitted data from a form. {key} is the survey id which can be found in the list of services. | 15.12+ | https://sg.smap.com.au/api/v1/data/1778 |
| /api/v1/data.csv | CSV | Get a list of services to retrieve form data | 15.12+ | https://sg.smap.com.au/api/v1/data.csv |
| /api/v1/data.csv/{key} | CSV | Get submitted data from the specified form in a CSV file. | 15.12+ | https://sg.smap.com.au/api/v1/data.csv/1778 |
Parameters
| Parameter | Description | Version | Example |
|---|---|---|---|
| start | Retrieve data from the specified primary key | 15.12+ | https://sg.smap.com.au/api/v1/data.csv?start=2 |
| limit | The number of records to retrieve | 15.12+ | https://sg.smap.com.au/api/v1/data.csv?start=2&limit=1 |
| form | Retrieve data for a subform. The available forms will be shown when you call /api/v1/data. This call will return the key for the parent form (parkey) so that its data can be combined with that of the main form | 17.06+ | https://sg.smap.com.au/api/v1/data/1778?form=2246 |
| start_parkey | Parent key to start from. Only useful when working with subform data. | 17.06+ | https://sg.smap.com.au/api/v1/data/1778?form=2246&start_parkey=200 |
| parkey | Use to get a data in a subform that is part of a single record from a parent form. | 17.06+ | https://sg.smap.com.au/api/v1/data/1778?form=2246&parkey=200 |
| bad | Set to "yes" to include records marked as bad in the results. Set to "only" to only return records marked as bad. The default is "none" which will exclude records marked as bad. These include records that have been replaced by editing of the original data. | 17.06+ | https://sg.smap.com.au/api/v1/data/1778?bad=yes |
| filename | CSV only. If not set the default name is csv.data (forms.csv when retrieving the list of services) | 17.06+ | https://sg.smap.com.au/api/v1/data.csv/1778?filename=my_data.csv |
| audit | Set to "yes" to include audit data. This data is the time in milliseconds that the user took to answer each question | 17.07+ | https://sg.smap.com.au/api/v1/data.csv/7019?audit=yes And for the sub form https://sg.smap.com.au/api/v1/data.csv/7019?form=11770&audit=yes |
| merge_select_multiple | Set to "yes" to combine all the selected choices for a select multiple into a single column / Json text property. This parameter only applies to surveys created after version 18.03 which use the compressed format for storing select answers | 18.04+ | https://sg.smap.com.au/api/v1/data.csv/7019?form=11770&merge_select_multiple=yes |
| geojson | Set to "yes" for the data to be returned in geoJson format rather than the kobo api format. | 18.07+ | https://sg.smap.com.au/api/v1/data.csv/7019?form=11770&geojson=yes |