sites_assets

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

Overview

Name	sites_assets
Type	Resource
Id	netlify.asset.sites_assets

Fields

The following fields are returned by SELECT queries:

getSiteAssetInfo

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

listSiteAssets

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
getSiteAssetInfo	select	site_id, asset_id
listSiteAssets	select	site_id
createSiteAsset	insert	site_id
deleteSiteAsset	delete	site_id, asset_id
updateSiteAsset	exec	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
site_id	string

SELECT examples

getSiteAssetInfo

OK

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

listSiteAssets

OK

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

INSERT examples

createSiteAsset

No description available.

INSERT INTO netlify.asset.sites_assets (
site_id
)
SELECT 
'{{ site_id }}'
RETURNING
asset,
form
;

Manifest

# Description fields are for documentation purposes
- name: sites_assets
  props:
    - name: site_id
      value: string
      description: Required parameter for the sites_assets resource.

DELETE examples

deleteSiteAsset

No description available.

DELETE FROM netlify.asset.sites_assets
WHERE site_id = '{{ site_id }}' --required
AND asset_id = '{{ asset_id }}' --required
;

Lifecycle Methods

updateSiteAsset

Updated

EXEC netlify.asset.sites_assets.updateSiteAsset 
@site_id='{{ site_id }}' --required, 
@asset_id='{{ asset_id }}' --required
;