Skip to main content

service_instances

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

Overview​

Nameservice_instances
TypeResource
Idnetlify.services.service_instances

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstring
service_namestring
auth_urlstring
configstring(opaque JSON object)
created_atstring (dateTime)
envstring(opaque JSON object)
external_attributesstring(opaque JSON object)
service_pathstring
service_slugstring
snippetsarray
updated_atstring (dateTime)
urlstring

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsite_id, addon, instance_id
listselectsite_id
createinsertsite_id, addon, config
updatereplacesite_id, addon, instance_id, config
deletedeletesite_id, addon, instance_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
addonstring
instance_idstring
site_idstring

SELECT examples​

OK

SELECT
id,
service_name,
auth_url,
config,
created_at,
env,
external_attributes,
service_path,
service_slug,
snippets,
updated_at,
url
FROM netlify.services.service_instances
WHERE site_id = '{{ site_id }}' -- required
AND addon = '{{ addon }}' -- required
AND instance_id = '{{ instance_id }}' -- required
;

INSERT examples​

No description available.

INSERT INTO netlify.services.service_instances (
config,
site_id,
addon
)
SELECT
'{{ config }}' /* required */,
'{{ site_id }}',
'{{ addon }}'
RETURNING
id,
service_name,
auth_url,
config,
created_at,
env,
external_attributes,
service_path,
service_slug,
snippets,
updated_at,
url
;

REPLACE examples​

No description available.

REPLACE netlify.services.service_instances
SET
config = '{{ config }}'
WHERE
site_id = '{{ site_id }}' --required
AND addon = '{{ addon }}' --required
AND instance_id = '{{ instance_id }}' --required
AND config = '{{ config }}' --required;

DELETE examples​

No description available.

DELETE FROM netlify.services.service_instances
WHERE site_id = '{{ site_id }}' --required
AND addon = '{{ addon }}' --required
AND instance_id = '{{ instance_id }}' --required
;