Starred
Lists starred gists for the authenticated user.
Table-Specific Information
Select
The add-in uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:
- Name supports the '=' comparison operator.
- UpdatedAt supports the '>=' comparison operator.
For example, the following queries are processed server-side:
SELECT * FROM [Starred]
SELECT * FROM [Starred] WHERE [Name] = 'Val1'
SELECT * FROM [Starred] WHERE [UpdatedAt] >= '2023-01-01 11:10:00'
The add-in processes other filters client-side within the add-in.
Insert
You can use the following column to create (insert) a new record: Name
INSERT INTO [Starred] ([Name]) VALUES ('d7e43b9c1a285c14f62af9803e1d47c8')
Delete
You can specify the following column to delete a record: Name
DELETE FROM [Starred] WHERE [Name] = 'd7e43b9c1a285c14f62af9803e1d47c8'
Columns
| Name | Type | ReadOnly | References | Description |
| Id | String | True |
The node ID of the gist. | |
| Name [KEY] | String | False |
The gist identifier. | |
| Public | Bool | True |
Indicates whether the gist is public. | |
| Description | String | True |
The gist description. | |
| Url | String | True |
The API URL of the gist. | |
| HtmlUrl | String | True |
The HTML URL of the gist. | |
| GitPullUrl | String | True |
The git pull URL of the gist. | |
| GitPushUrl | String | True |
The git push URL of the gist. | |
| CommitsUrl | String | True |
The API URL for the gist's commits. | |
| ForksUrl | String | True |
The API URL for the gist's forks. | |
| CommentsUrl | String | True |
The API URL for the gist's comments. | |
| CommentsEnabled | Bool | True |
Indicates whether comments are enabled for the gist. | |
| Comments | Int | True |
The number of comments on the gist. | |
| CreatedAt | Datetime | True |
The date and time when the gist was created. | |
| UpdatedAt | Datetime | True |
The date and time when the gist was last updated. | |
| OwnerLogin | String | True |
The username of the gist owner. |