submissions

Creates, updates, deletes, gets or lists a submissions resource.

Overview

Name	submissions
Type	Resource
Id	netlify.forms.submissions

Fields

The following fields are returned by SELECT queries:

list_for_site

Name	Datatype	Description
id	string
name	string
first_name	string
last_name	string
body	string
company	string
created_at	string (dateTime)
data	string	(opaque JSON object)
email	string
number	integer (int32)
site_url	string
summary	string

list

Name	Datatype	Description
id	string
name	string
first_name	string
last_name	string
body	string
company	string
created_at	string (dateTime)
data	string	(opaque JSON object)
email	string
number	integer (int32)
site_url	string
summary	string

get

Name	Datatype	Description
id	string
name	string
first_name	string
last_name	string
body	string
company	string
created_at	string (dateTime)
data	string	(opaque JSON object)
email	string
number	integer (int32)
site_url	string
summary	string

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_for_site	select	site_id	page, per_page
list	select	form_id	page, per_page
get	select	submission_id	query, page, per_page
delete	delete	submission_id

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
form_id	string
site_id	string
submission_id	string
page	integer (int32)
per_page	integer (int32)
query	string

SELECT examples

list_for_site

OK

SELECT
id,
name,
first_name,
last_name,
body,
company,
created_at,
data,
email,
number,
site_url,
summary
FROM netlify.forms.submissions
WHERE site_id = '{{ site_id }}' -- required
AND page = '{{ page }}'
AND per_page = '{{ per_page }}'
;

list

OK

SELECT
id,
name,
first_name,
last_name,
body,
company,
created_at,
data,
email,
number,
site_url,
summary
FROM netlify.forms.submissions
WHERE form_id = '{{ form_id }}' -- required
AND page = '{{ page }}'
AND per_page = '{{ per_page }}'
;

get

OK

SELECT
id,
name,
first_name,
last_name,
body,
company,
created_at,
data,
email,
number,
site_url,
summary
FROM netlify.forms.submissions
WHERE submission_id = '{{ submission_id }}' -- required
AND query = '{{ query }}'
AND page = '{{ page }}'
AND per_page = '{{ per_page }}'
;

DELETE examples

delete

No description available.

DELETE FROM netlify.forms.submissions
WHERE submission_id = '{{ submission_id }}' --required
;