releases_latest

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

Overview

Name	releases_latest
Type	Resource
Id	github.repos.releases_latest

Fields

The following fields are returned by SELECT queries:

get_latest_release

Response

Name	Datatype	Description
id	integer
name	string
node_id	string
tag_name	string	The name of the tag. (example: v1.0.0)
assets	array
assets_url	string (uri)
author	object	A GitHub user. (title: Simple User)
body	string
body_html	string
body_text	string
created_at	string (date-time)
discussion_url	string (uri)	The URL of the release discussion.
draft	boolean	true to create a draft (unpublished) release, false to create a published one.
html_url	string (uri)
immutable	boolean	Whether or not the release is immutable.
mentions_count	integer
prerelease	boolean	Whether to identify the release as a prerelease or a full release.
published_at	string (date-time)
reactions	object	(title: Reaction Rollup)
tarball_url	string (uri)
target_commitish	string	Specifies the commitish value that determines where the Git tag is created from. (example: master)
updated_at	string (date-time)
upload_url	string
url	string (uri)
zipball_url	string (uri)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_latest_release	select	owner, repo		View the latest published full release for the repository. The latest release is the most recent non-prerelease, non-draft release, sorted by the created_at attribute. The created_at attribute is the date of the commit used for the release, and not the date when the release was drafted or published.

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
owner	string	The account owner of the repository. The name is not case sensitive.
repo	string	The name of the repository without the .git extension. The name is not case sensitive.

SELECT examples

get_latest_release

View the latest published full release for the repository.

The latest release is the most recent non-prerelease, non-draft release, sorted by the created_at attribute. The created_at attribute is the date of the commit used for the release, and not the date when the release was drafted or published.

SELECT
id,
name,
node_id,
tag_name,
assets,
assets_url,
author,
body,
body_html,
body_text,
created_at,
discussion_url,
draft,
html_url,
immutable,
mentions_count,
prerelease,
published_at,
reactions,
tarball_url,
target_commitish,
updated_at,
upload_url,
url,
zipball_url
FROM github.repos.releases_latest
WHERE owner = '{{ owner }}' -- required
AND repo = '{{ repo }}' -- required
;