site_assets

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

Overview

Name	site_assets
Type	Resource
Id	netlify.sites.site_assets

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
id	string
name	string
creator_id	string
site_id	string
content_type	string
created_at	string (dateTime)
key	string
size	integer (int64)
state	string
updated_at	string (dateTime)
url	string
visibility	string

list

Name	Datatype	Description
id	string
name	string
creator_id	string
site_id	string
content_type	string
created_at	string (dateTime)
key	string
size	integer (int64)
state	string
updated_at	string (dateTime)
url	string
visibility	string

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	site_id, asset_id
list	select	site_id
create	insert	name, size, content_type, site_id	visibility
update	replace	state, site_id, asset_id
delete	delete	site_id, asset_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
asset_id	string
content_type	string
name	string
site_id	string
size	integer (int64)
state	string
visibility	string

SELECT examples

get

OK

SELECT
id,
name,
creator_id,
site_id,
content_type,
created_at,
key,
size,
state,
updated_at,
url,
visibility
FROM netlify.sites.site_assets
WHERE site_id = '{{ site_id }}' -- required
AND asset_id = '{{ asset_id }}' -- required
;

list

OK

SELECT
id,
name,
creator_id,
site_id,
content_type,
created_at,
key,
size,
state,
updated_at,
url,
visibility
FROM netlify.sites.site_assets
WHERE site_id = '{{ site_id }}' -- required
;

INSERT examples

create

No description available.

INSERT INTO netlify.sites.site_assets (
name,
size,
content_type,
site_id,
visibility
)
SELECT 
'{{ name }}',
'{{ size }}',
'{{ content_type }}',
'{{ site_id }}',
'{{ visibility }}'
RETURNING
asset,
form
;

Manifest

# Description fields are for documentation purposes
- name: site_assets
props:
  - name: name
    value: "{{ name }}"
    description: Required parameter for the site_assets resource.
  - name: size
    value: "{{ size }}"
    description: Required parameter for the site_assets resource.
  - name: content_type
    value: "{{ content_type }}"
    description: Required parameter for the site_assets resource.
  - name: site_id
    value: "{{ site_id }}"
    description: Required parameter for the site_assets resource.
  - name: visibility
    value: "{{ visibility }}"

REPLACE examples

update

No description available.

REPLACE netlify.sites.site_assets
SET 
-- No updatable properties
WHERE 
state = '{{ state }}' --required
AND site_id = '{{ site_id }}' --required
AND asset_id = '{{ asset_id }}' --required
RETURNING
id,
name,
creator_id,
site_id,
content_type,
created_at,
key,
size,
state,
updated_at,
url,
visibility;

DELETE examples

delete

No description available.

DELETE FROM netlify.sites.site_assets
WHERE site_id = '{{ site_id }}' --required
AND asset_id = '{{ asset_id }}' --required
;