Comments

Lists comments on gists.

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:

GistId supports the '=,IN' comparison operators.
Id supports the '=,IN' comparison operators.

For example, the following queries are processed server-side:

SELECT * FROM [Comments]
SELECT * FROM [Comments] WHERE [GistId] = 'Val1'
SELECT * FROM [Comments] WHERE [Id] = 'Val1'

The add-in processes other filters client-side within the add-in.

Insert

You can use the following columns to create (insert) a new record:

GistName
Body

INSERT INTO [Comments] ([GistName], [Body]) VALUES ('d7e43b9c1a285c14f62af9803e1d47c8', 'Forked.')

Update

You can use the following column to update a record:

Body

UPDATE [Comments] SET [Body] = 'Changed' WHERE ([GistName] = 'd7e43b9c1a285c14f62af9803e1d47c8') AND ([DatabaseId] = '5797577')

Delete

You can specify the following columns to delete a record:

GistName
DatabaseId

DELETE FROM [Comments] WHERE ([GistName] = 'd7e43b9c1a285c14f62af9803e1d47c8') AND ([DatabaseId] = '5797583')

Columns


Name	Type	ReadOnly	References	Description
GistId	String	True		The node ID of the gist.
GistName	String	False	Gists.Name	The gist identifier.
Id [KEY]	String	True		The Node ID of the GistComment object.
DatabaseId	Int	True		Identifies the primary key from the database.
Body	String	False		The comment body.
BodyText	String	True		The comment body rendered to text.
BodyHTML	String	True		The comment body rendered to HTML.
Author	String	True		The username of the actor who authored the comment.
AuthorAssociation	String	True		Author's association with the gist.
Editor	String	True		The username of the actor who edited the comment.
IsMinimized	Bool	True		Returns whether or not a comment has been minimized.
MinimizedReason	String	True		Returns why the comment was minimized.
CreatedViaEmail	Bool	True		Check if this comment was created via an email reply.
IncludesCreatedEdit	Bool	True		Check if this comment was edited and includes an edit with the creation data.
CreatedAt	Datetime	True		Identifies the date and time when the object was created.
UpdatedAt	Datetime	True		Identifies the date and time when the object was last updated.
PublishedAt	Datetime	True		Identifies when the comment was published at.
LastEditedAt	Datetime	True		The moment the editor made the last edit.
ViewerDidAuthor	Bool	True		Did the viewer author this comment.
ViewerCanDelete	Bool	True		Check if the current viewer can delete this object.
ViewerCanMinimize	Bool	True		Check if the current viewer can minimize this object.
ViewerCanUnminimize	Bool	True		Check if the current viewer can unminimize this object.
ViewerCanUpdate	Bool	True		Check if the current viewer can update this object.
ViewerCannotUpdateReasons	String	True		Reasons why the current viewer can not update this comment.
OwnerLogin	String	True		The username of the gist owner.

Excel Add-In for GitHub