Skip to main content

snippets

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

Overview

Namesnippets
TypeResource
Idnetlify.sites.snippets

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idinteger (int32)
site_idstring
generalstring
general_positionstring
goalstring
goal_positionstring
titlestring

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsite_id, snippet_id
listselectsite_id
createinsertsite_id
updatereplacesite_id, snippet_id
deletedeletesite_id, snippet_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.

NameDatatypeDescription
site_idstring
snippet_idstring

SELECT examples

OK

SELECT
id,
site_id,
general,
general_position,
goal,
goal_position,
title
FROM netlify.sites.snippets
WHERE site_id = '{{ site_id }}' -- required
AND snippet_id = '{{ snippet_id }}' -- required
;

INSERT examples

No description available.

INSERT INTO netlify.sites.snippets (
id,
site_id,
title,
general,
general_position,
goal,
goal_position,
site_id
)
SELECT
{{ id }},
'{{ site_id }}',
'{{ title }}',
'{{ general }}',
'{{ general_position }}',
'{{ goal }}',
'{{ goal_position }}',
'{{ site_id }}'
RETURNING
id,
site_id,
general,
general_position,
goal,
goal_position,
title
;

REPLACE examples

No description available.

REPLACE netlify.sites.snippets
SET
id = {{ id }},
site_id = '{{ site_id }}',
title = '{{ title }}',
general = '{{ general }}',
general_position = '{{ general_position }}',
goal = '{{ goal }}',
goal_position = '{{ goal_position }}'
WHERE
site_id = '{{ site_id }}' --required
AND snippet_id = '{{ snippet_id }}' --required;

DELETE examples

No description available.

DELETE FROM netlify.sites.snippets
WHERE site_id = '{{ site_id }}' --required
AND snippet_id = '{{ snippet_id }}' --required
;