History of submissions

This query returns a list of new form submissions.

Developer info

API endpoint slug: jotform.history_of_submissions
Runtime method: performQuery("jotform.history_of_submissions")

Query fields

Form ID Dropdown list

Label: Form
Helper text: Choose a form
Slug: form_id
Required: true
Can have default value: false

Question filter Text input > Other

Label: Question Filter
Helper text: Optional question filter (label text) e.g. Name, Email, Address
Slug: question_filter
Required: true
Can have default value: true

Ingredients

IpThe form respondent's detected IP address.

Slug: ip
Filter code: Jotform.historyOfSubmissions.IP
Type: String
Example: 192.168.0.100

Form titleThe form title.

Slug: form_title
Filter code: Jotform.historyOfSubmissions.FormTitle
Type: String
Example: My Contact Form

Submission date timeThe date and time of the form submission.

Slug: submission_date_time
Filter code: Jotform.historyOfSubmissions.SubmissionDateTime
Type: Date with time (ISO8601)
Example: 2020-07-08T04:17:06.000+05:00

Total submissionsThe total submission count.

Slug: total_submissions
Filter code: Jotform.historyOfSubmissions.TotalSubmissions
Type: String
Example: 8

Form IDA number that uniquely identifies the form.

Slug: form_id
Filter code: Jotform.historyOfSubmissions.FormID
Type: String
Example: 1234567890

Submission IDA number that uniquely identifies the form submission.

Slug: submission_id
Filter code: Jotform.historyOfSubmissions.SubmissionID
Type: String
Example: 850507727987654321

Rich text dataThe form data in a tabulated HTML format.

Slug: rich_text_data
Filter code: Jotform.historyOfSubmissions.RichTextData
Type: String
Example: <table><tr><td>E-mail</td>johndoe@mail.com<td></td></tr></table>

Spreadsheet dataThe form data in a CSV format.

Slug: spreadsheet_data
Filter code: Jotform.historyOfSubmissions.SpreadsheetData
Type: String
Example: []

Filtered rich text dataThe filtered form data in a tabulated HTML format.

Slug: filtered_rich_text_data
Filter code: Jotform.historyOfSubmissions.FilteredRichTextData
Type: String
Example: <table><tr><td>E-mail</td>johndoe@mail.com<td></td></tr></table>

Filtered spreadsheet dataThe filtered form data in a CSV format.

Slug: filtered_spreadsheet_data
Filter code: Jotform.historyOfSubmissions.FilteredSpreadsheetData
Type: String
Example: []

File URLThe URL of the file(s) uploaded on your form.

Slug: file_url
Filter code: Jotform.historyOfSubmissions.FileUrl
Type: String
Example: http://www.jotform.com/uploads/user/1234567890/9876543210/images.zip