Forms

Publish XLSForms, List, Retrieve Published Forms.

Where:

  • pk - is the form unique identifier

Upload XLSForm

To publish and xlsform, you need to provide either the xlsform via xls_file parameter or a link to the xlsform via the xls_url parameter. Optionally, you can specify the target account where the xlsform should be published using the owner parameter, which specifies the username to the account.

  • xls_file: the xlsform file.
  • xls_url: the url to an xlsform
  • dropbox_xls_url: the drop box url to an xlsform
  • owner: username to the target account (Optional)
POST /api/v1/forms

Example

curl -X POST -F xls_file=@/path/to/form.xls https://api.ona.io/api/v1/forms

OR post an xlsform url

curl -X POST -d "xls_url=https://api.ona.io/ukanga/forms/tutorial/form.xls" https://api.ona.io/api/v1/forms

OR post an xlsform via Dropbox url

curl -X POST -d "dropbox_xls_url=https://www.dropbox.com/s/ynenld7xdf1vdlo/tutorial.xls?dl=1" https://api.ona.io/api/v1/forms

Response

{
    "url": "https://api.ona.io/api/v1/forms/28058",
    "formid": 28058,
    "uuid": "853196d7d0a74bca9ecfadbf7e2f5c1f",
    "id_string": "Birds",
    "sms_id_string": "Birds",
    "title": "Birds",
    "allows_sms": false,
    "bamboo_dataset": "",
    "description": "",
    "downloadable": true,
    "encrypted": false,
    "owner": "ona",
    "public": false,
    "public_data": false,
    "date_created": "2013-07-25T14:14:22.892Z",
    "date_modified": "2013-07-25T14:14:22.892Z",
    "last_updated_at": "2013-07-25T14:14:22.892Z"
}

Get list of forms

GET /api/v1/forms

Request

curl -X GET https://api.ona.io/api/v1/forms

Get list of forms filter by owner

GET /api/v1/forms?owner=owner_username

Request

curl -X GET https://api.ona.io/api/v1/forms?owner=ona

Get Form Information

GET /api/v1/forms/{pk}

Example

curl -X GET https://api.ona.io/api/v1/forms/28058

Response

{
    "url": "https://api.ona.io/api/v1/forms/28058",
    "formid": 28058,
    "uuid": "853196d7d0a74bca9ecfadbf7e2f5c1f",
    "id_string": "Birds",
    "sms_id_string": "Birds",
    "title": "Birds",
    "allows_sms": false,
    "bamboo_dataset": "",
    "description": "",
    "downloadable": true,
    "encrypted": false,
    "owner": "https://api.ona.io/api/v1/users/ona",
    "public": false,
    "public_data": false,
    "require_auth": false,
    "date_created": "2013-07-25T14:14:22.892Z",
    "date_modified": "2013-07-25T14:14:22.892Z",
    "last_updated_at": "2013-07-25T14:14:22.892Z"
}

Set Form Information

You can use PUT or PATCH http methods to update or set form data elements. If you are using PUT, you have to provide the uuid, description, downloadable, owner, public, public_data, title fields. With PATCH you only need to provide at least one of the fields.

Replacing a Form

Provide either of the following fields:

  • xls_file or xls_url or dropbox_xls_url

Form can only be updated when there are no submissions.

PATCH /api/v1/forms/{pk}

Example

curl -X PATCH -d "public=True" -d "description=Le description" https://api.ona.io/api/v1/forms/28058

Response

{
    "url": "https://api.ona.io/api/v1/forms/28058",
    "formid": 28058,
    "uuid": "853196d7d0a74bca9ecfadbf7e2f5c1f",
    "id_string": "Birds",
    "sms_id_string": "Birds",
    "title": "Birds",
    "allows_sms": false,
    "bamboo_dataset": "",
    "description": "Le description",
    "downloadable": true,
    "encrypted": false,
    "owner": "https://api.ona.io/api/v1/users/ona",
    "public": true,
    "public_data": false,
    "date_created": "2013-07-25T14:14:22.892Z",
    "date_modified": "2013-07-25T14:14:22.892Z"
}

Delete Form

DELETE /api/v1/forms/{pk}

Example

curl -X DELETE https://api.ona.io/api/v1/forms/28058

Response

HTTP 204 NO CONTENT

List of form data exports

Get a list of exports .. raw:: html

<pre class=”prettyprint”> <b>GET</b> /api/v1/export </pre>

Example

curl -X GET https://api.ona.io/api/v1/export

Response

[{
    "id": 1,
    "job_status": "SUCCESS",
    "task_id": "54b7159b-3b53-4e3c-b2a7-a5ed51adcfe9",
    "type": "xls",
    "xform": "http://api.ona.io/api/v1/forms/1"
},
{
    "id": 2,
    "job_status": "PENDING",
    "task_id": "54b7159b-3b53-4e3c-b2a7-a5ed51adcde9",
    "type": "xls",
    "xform": "http://api.ona.io/api/v1/forms/17"
}]

Get a list of exports on a form .. raw:: html

<pre class=”prettyprint”> <b>GET</b> /api/v1/export?xform=<code>{pk}</code> </pre>

Example

curl -X GET https://api.ona.io/api/v1/export?xform=1

Response

[{
    "id": 1,
    "job_status": "SUCCESS",
    "task_id": "54b7159b-3b53-4e3c-b2a7-a5ed51adcfe9",
    "type": "xls",
    "xform": "http://api.ona.io/api/v1/forms/1"
}]

Export form data asynchronously

Supported formats for exports are:

  • csv
  • xls
  • savzip
  • csvzip
  • kml
  • osm
  • gsheets
GET /api/v1/forms/{pk}/export_async?format={format}

Example

curl -X GET https://api.ona.io/api/v1/forms/28058/export_async?format=xls

Response

JSON response could include the job_status, job_uuid and error_message for why an export failed.

HTTP 202 Accepted
{"job_uuid": "d1559e9e-5bab-480d-9804-e32111e8b2b8"}

Google Sheets Export

Google sheets export works similar to the normal async export but with one more step google authorization step. The first time generating google sheets export google authorization is required.

curl -X GET https://api.ona.io/api/v1/forms/28058/export_async?format=gsheets&redirect_uri=<redirect_uri>

Response

HTTP 403 Forbidden
{
    "url":"https://accounts.google.com/o/oauth2/v2/auth?scope=https%3A%2F%2Fdocs.google.com%2Ffeeds%2F+https%3A%2F%2Fspreadsheets.google.com%2Ffeeds%2F+https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fdrive.file&redirect_uri=http%3A%2F%2Flocalhost%3A8000%2Fgwelcome&response_type=code&client_id=example-clientid-df9rktjc2iga992b6p33vasdasdasd.apps.googleusercontent.com&access_type=offline",
    "details":"Google authorization needed"
}

Use that url for authorization.

Google Sheet Authorization

Optional redirect_uri can be provided in this step. This redirect_uri will recieve code from google and with this code pass it to this url https://api.ona.io/api/v1/export/google_auth to finish the authorization steps.

Example

curl -X GET https://api.ona.io/api/v1/export/google_auth?code=<code from google>

Response

HTTP 201 Created

Export submitted data of a specific form version

Use the query parameter to pass in a JSON key/value query.

Example:

Querying data with a specific version

query={"_version": "2014111"}

Example

curl -X GET https://api.ona.io/api/v1/forms/28058/export_async?format=xls&query={"_version": "2014111"}

You can use the job_uuid value to check the progress of data export

Check progress of exporting form data asynchronously

GET /api/v1/forms/{pk}/export_async?job_uuid=UUID

Example

curl -X GET https://api.ona.io/api/v1/forms/28058/export_async?job_uuid=d1559e9e-5bab-480d-9804-e32111e8b2b8

Response

If the job is done:

HTTP 202 Accepted
{
    "job_status": "SUCCESS",
    "export_url": "https://api.ona.io/api/v1/forms/28058.xls"
}

CSV and XLS exports without group name prefixed to the field names

To generate csv or xls export with the group name truncated from the field names set remove_group_name param to true. Default for this param is false.

Example

curl -X GET https://api.ona.io/api/v1/forms/28058/export_async?format=xls&remove_group_name=true

CSV and XLS exports with either ‘.’ or ‘/’ group delimiter in header names

To generate csv or xls export that has either ‘.’ or ‘/’ in header names, you can set group_delimiter param to either ‘.’ or ‘/’. The default group delimeter is /.

Example

curl -X GET https://api.ona.io/api/v1/forms/28058/export_async?format=xls&group_delimiter=.

CSV and XLS exports with option to split multiple select fields

To generate csv or xls export whose mutliple select fields are not split you can pass do_not_split_select_multiples. If this is not passed the default occurs and select multiples are split.

Example

curl -X GET https://api.ona.io/api/v1/forms/28058/export_async?format=xls&do_not_split_select_multiples

Include labels in CSV, SAVZIP, XLS and zipped CSV exports

By default labels are not included in exports. To include labels in the exports, use
the include_labels param, acceptable values are true and false.

Example

curl -X GET https://api.ona.io/api/v1/forms/28058/export_async?format=xls&include_labels=true
curl -X GET https://api.ona.io/api/v1/forms/28058.xls?include_labels=true

Include labels as column headers in CSV, SAVZIP, XLS and zipped CSV exports

By default labels are not included in exports. To include labels as column headers in the exports, use
the include_labels_only param, acceptable values are true and false.

Example

curl -X GET https://api.ona.io/api/v1/forms/28058/export_async?format=xls&include_labels_only=true
curl -X GET https://api.ona.io/api/v1/forms/28058.xls?include_labels_only=true

CSV and XLS exports with either ‘.’ or ‘/’ group delimiter in header names

Example

curl -X GET https://api.ona.io/api/v1/forms/28058/export_async?format=xls&include_images=false
curl -X GET https://api.ona.io/api/v1/forms/28058.xls?include_images=false

Include HXL row in exports

By default the HXL row is included for forms that have instance::HXL in exports. To exclude the HXL row in the exports, use
the include_hxl param, acceptable values are true and false.

Example

curl -X GET https://api.ona.io/api/v1/forms/28058/export_async?format=xls&include_hxl=false
curl -X GET https://api.ona.io/api/v1/forms/28058.xls?include_hxl=false

Windows Excel compatible unicode CSV exports

For a Windows Excel compatible unicode CSV export use the win_excel_utf8
param, acceptable values are true and false. This allows you to open the CSV file in Windows Excel by default without following the data import from file process which allows you to select the encoding format. The default value is false.

Example

curl -X GET https://api.ona.io/api/v1/forms/28058/export_async?format=csv&win_excel_utf8=true
curl -X GET https://api.ona.io/api/v1/forms/28058.csv?win_excel_utf8=true

Delete an XLS form asynchronously

POST /api/v1/forms/{pk}/delete_async

Example

curl -X DELETE https://api.ona.io/api/v1/forms/28058/delete_async

Response

HTTP 202 Accepted
{"job_uuid": "d1559e9e-5bab-480d-9804-e32111e8b2b8"}

You can use the job_uuid value to check on the upload progress (see below)

Check on XLS form deletion progress

GET /api/v1/forms/{pk}/delete_async?job_uuid=UUID

Example

curl -X GET https://api.ona.io/api/v1/forms/28058/delete_async?job_uuid=d1559e9e-5bab-480d-9804-e32111e8b2b8

Response

If the job is done:

HTTP 202 Accepted
{"job_status": "SUCCESS"}

List Forms

GET /api/v1/forms

Example

curl -X GET https://api.ona.io/api/v1/forms

Response

[
    {
        "url": "https://api.ona.io/api/v1/forms/28058",
        "formid": 28058,
        "uuid": "853196d7d0a74bca9ecfadbf7e2f5c1f",
        "id_string": "Birds",
        "sms_id_string": "Birds",
        "title": "Birds",
        ...
    },
    ...
]

Get JSON | XML | XLS Form Representation

GET /api/v1/forms/{pk}/form.{format}

JSON Example

curl -X GET https://api.ona.io/api/v1/forms/28058/form.json

Response

{
    "name": "Birds",
    "title": "Birds",
    "default_language": "default",
    "id_string": "Birds",
    "type": "survey",
    "children": [
        {
            "type": "text",
            "name": "name",
            "label": "1. What is your name?"
        },
        ...
        ]
}

XML Example

curl -X GET https://api.ona.io/api/v1/forms/28058/form.xml

Response

<?xml version="1.0" encoding="utf-8"?>
<h:html xmlns="http://www.w3.org/2002/xforms" ...>
  <h:head>
    <h:title>Birds</h:title>
    <model>
      <itext>
         .....
  </h:body>
</h:html>

XLS Example

curl -X GET https://api.ona.io/api/v1/forms/28058/form.xls

Response

XLS file downloaded

Get list of forms with specific tag(s)

Use the tags query parameter to filter the list of forms, tags should be a comma separated list of tags.

GET /api/v1/forms?tags=tag1,tag2

List forms tagged smart or brand new or both.

Request

curl -X GET https://api.ona.io/api/v1/forms?tag=smart,brand+new

Response

HTTP 200 OK

Response

[
    {
        "url": "https://api.ona.io/api/v1/forms/28058",
        "formid": 28058,
        "uuid": "853196d7d0a74bca9ecfadbf7e2f5c1f",
        "id_string": "Birds",
        "sms_id_string": "Birds",
        "title": "Birds",
        ...
    },
    ...
]

Get list of Tags for a specific Form

GET /api/v1/forms/{pk}/labels

Request

curl -X GET https://api.ona.io/api/v1/forms/28058/labels

Response

["old", "smart", "clean house"]

Tag forms

A POST payload of parameter tags with a comma separated list of tags.

Examples

  • animal fruit denim - space delimited, no commas
  • animal, fruit denim - comma delimited
POST /api/v1/forms/{pk}/labels

Payload

{"tags": "tag1, tag2"}

Delete a specific tag

DELETE /api/v1/forms/{pk}/labels/tag_name

Request

curl -X DELETE https://api.ona.io/api/v1/forms/28058/labels/tag1

or to delete the tag “hello world”

curl -X DELETE https://api.ona.io/api/v1/forms/28058/labels/hello%20world

Response

HTTP 204 NO CONTENT

Get list of forms containing data with osm files

Use the instances_with__osm query parameter to filter the list of forms
that has osm file submissions. Accepted values are True and False.
GET /api/v1/forms?instances_with_osm=True
HTTP 200 OK

Get form data in xls, csv format.

Get form data exported as xls, csv, csv zip, sav zip format.

Where:

  • pk - is the form unique identifier
  • format - is the data export format i.e csv, xls, csvzip, savzip, osm

Params for the custom xls report

  • meta - the metadata id containing the template url
  • token - the template url
  • data_id - the unique id of the submission
GET /api/v1/forms/{pk}.{format}

Example

curl -X GET https://api.ona.io/api/v1/forms/28058.xls

Binary file export of the format specified is returned as the response for the download.

Response

HTTP 200 OK

Example 2 Custom XLS reports (beta)

curl -X GET https://api.ona.io/api/v1/forms/28058.xls?meta=12121

or

curl -X GET https://api.ona.io/api/v1/forms/28058.xls?token={url}

XLS file is downloaded

Response

HTTP 200 OK

Example 3 Custom XLS reports with meta or token and data_id(beta)

GET /api/v1/forms/{pk}.{format}?{meta}&{data_id} -L -o {filename.xls}
curl "https://api.ona.io/api/v1/forms/2.xls?meta=19&data_id=7" -L -o data.xlsx

or

curl "https://api.ona.io/api/v1/forms/2.xls?token={url}&data_id=7" -L -o data.xlsx

XLS file is downloaded

Response

HTTP 200 OK

Get list of public forms

GET /api/v1/forms/public

Share a form with a specific username or usernames

You can share a form with a specific username or a list of usernames using POST with a payload of

  • username OR usernames of the usernames you want to share the form with, multiple usernames should be comma separated, and
  • role you want the user to have on the form. Available roles are readonly, dataentry, editor, manager.
POST /api/v1/forms/{pk}/share

Example

curl -X POST -d '{"username": "alice", "role": "readonly"}' https://api.ona.io/api/v1/forms/123.json

Example

curl -X POST -d '{"usernames": "alice,bob,eve", "role": "readonly"}' https://api.ona.io/api/v1/forms/123.json

Response

HTTP 204 NO CONTENT

Preview a survey draft

This endpoint used to retrieve an xml representation of a survey draft. You will need to make a POST request with the survey draft data in a body variable for a survey draft file to be created. The repsonse is a json object with 2 keys, unique_string and username. The unique_string‘s value is the name of the survey draft file created and the username is the user’s username. Both should be added as query params when making a GET request to the same url inorder to retrieve the xml representation of the survey draft.

POST /api/v1/forms/survey_preview

Example

curl -X POST -d '{"body": <unicode-string-with-csv-text>}' https://api.ona.io/api/v1/forms/survey_preview

Response

HTTP 200 OK
GET /api/v1/forms/survey_preview.xml?filename={unique_string}&username={username}

Example

curl -X GET https://api.ona.io/api/v1/forms/survey_preview.xml\?filename\=<unique_string>&username=<username>

Response

HTTP 200 OK

Clone a form to a specific user account

You can clone a form to a specific user account using POST with

  • username of the user you want to clone the form to
  • project_id of the specific project you want to assign the form to (optional)
POST /api/v1/forms/{pk}/clone

Example

curl -X POST https://api.ona.io/api/v1/forms/123/clone -d username=alice

Response

HTTP 201 CREATED

Response

{
    "url": "https://api.ona.io/api/v1/forms/124",
    "formid": 124,
    "uuid": "853196d7d0a74bca9ecfadbf7e2f5c1e",
    "id_string": "Birds_cloned_1",
    "sms_id_string": "Birds_cloned_1",
    "title": "Birds_cloned_1",
    ...
}
POST /api/v1/forms/{pk}/clone

Example

curl -X POST https://api.ona.io/api/v1/forms/123/clone -d username=alice project_id=7003

Response

HTTP 201 CREATED

Response

{
    "url": "https://api.ona.io/api/v1/forms/124",
    "formid": 124,
    "uuid": "853196d7d0a74bca9ecfadbf7e2f5c1e",
    "id_string": "Birds_cloned_1",
    "sms_id_string": "Birds_cloned_1",
    "title": "Birds_cloned_1",
    "project": 'https://api.ona.io/api/v1/projects/7000'
    ...
}

Import CSV data to existing form

  • csv_file a valid csv file with exported data (instance/submission per row)
POST /api/v1/forms/{pk}/csv_import

Example

curl -X POST https://api.ona.io/api/v1/forms/123/csv_import -F csv_file=@/path/to/csv_import.csv

If the job was executed immediately:

Response

HTTP 200 OK
{
    "additions": 9,
    "updates": 0
}

If the import is a long running task:

Response

HTTP 200 OK
{"task_id": "04874cee-5fea-4552-a6c1-3c182b8b511f"}

You can use the task_id value to check on the import progress (see below)

Check on CSV data import progress

  • job_uuid a valid csv import job_uuid returned by a long running import

    previous call

GET /api/v1/forms/{pk}/csv_import?job_uuid=UUID

Example

curl -X GET https://api.ona.io/api/v1/forms/123/csv_import?job_uuid=UUID

Response

If the job is done:

HTTP 200 OK
{
    "additions": 90000,
    "updates": 10000
}

If the import is still running:

HTTP 200 OK
{
    "current": 100,
    "total": 100000
}

Upload a XLS form async

POST /api/v1/forms/create_async

Example

curl -X POST https://api.ona.io/api/v1/forms/create_async -F xls_file=@/path/to/xls_file

Response

HTTP 202 Accepted
{"job_uuid": "d1559e9e-5bab-480d-9804-e32111e8b2b8"}

You can use the job_uuid value to check on the upload progress (see below)

Check on XLS form upload progress

GET /api/v1/forms/create_async/?job_uuid=UUID

Example

curl -X GET https://api.ona.io/api/v1/forms/create_async?job_uuid=UUID

Response

If the job is done:

{
     "url": "https://api.ona.io/api/v1/forms/28058",
     "formid": 28058,
     "uuid": "853196d7d0a74bca9ecfadbf7e2f5c1f",
     "id_string": "Birds",
     "sms_id_string": "Birds",
     "title": "Birds",
     "allows_sms": false,
     "bamboo_dataset": "",
     "description": "",
     "downloadable": true,
     "encrypted": false,
     "owner": "ona",
     "public": false,
     "public_data": false,
     "date_created": "2013-07-25T14:14:22.892Z",
     "date_modified": "2013-07-25T14:14:22.892Z"
}

If the upload is still running:

HTTP 202 Accepted
{
    "job_status": "PENDING"
}