Sign in
Submissions

Exporting Root Data to Plain CSV

(introduced: version 1.1)

The above submission endpoints will give you a ZIP file with the submission data in it. This is necessary to provide all the possible related repeat table files, as well as the media files associated with the submissions. But ZIP files can be difficult to work with, and many Forms have no repeats nor media attachments.

To export just the root table (no repeat data nor media files), you can call this endpoint instead, which will directly give you CSV data.

Please see the above endpoint for notes on dealing with Managed Encryption.

get/v1/projects/{projectId}/forms/{xmlFormId}/submissions.csv

Path parameters

projectIdnumber required

The numeric ID of the Project

xmlFormIdstring required

The xmlFormId of the Form being referenced.

Query parameters

$filterstring

If provided, will filter responses to those matching the given OData query. Only certain fields are available to reference. The operators lt, le, eq, neq, ge, gt, not, and, and or are supported, and the built-in functions now, year, month, day, hour, minute, second.

Response

OK

Changes

Changed in 3 of the 54 revisions of this API.15

  • 022694254f0d1See the full diff
    • ○

      api operation id Exporting Root Data to Plain CSV removed and replaced with exportRootDataToPlainCsv

      api-operation-id-removed

  • b11b54eea4872See the full diff
    • ○

      added the media type application/zip for the response with the status 200

      response-media-type-added

    • ○

      removed the non-success response with the status 403

      response-non-success-status-removed

  • e8c2858fd4eb12See the full diff
    • ▲

      removed the media type application/zip for the response with the status 200

      response-media-type-removed

    • ○

      api operation id exportRootDataToPlainCsv removed and replaced with Exporting Root Data to Plain CSV

      api-operation-id-removed

    • ○

      added the non-success response with the status 403

      response-non-success-status-added

    This revision also has 11 changes that name no endpoint, such as unreferenced schemas being removed. See the revision's changelog