Files

Lists up to three hundred files for each gist at their most recent revisions, including up to one megabyte of content per file.

Table-Specific Information

The add-in uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:

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

SELECT * FROM [Files]
SELECT * FROM [Files] WHERE [GistName] = 'Val1'

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

You can use the following columns to upsert a record:

UPSERT INTO [Files] ([GistName], [Name], [Content]) VALUES ('d7e43b9c1a285c14f62af9803e1d47c8', 'Test.txt', 'Text')

You can use the following column to update a record:

UPDATE [Files] SET [Name] = 'Changed.txt' WHERE ([Name] = 'Test.txt') AND ([GistName] = 'd7e43b9c1a285c14f62af9803e1d47c8')

You can specify the following columns to delete a record:

DELETE FROM [Files] WHERE ([Name] = 'Test.txt') AND ([GistName] = 'd7e43b9c1a285c14f62af9803e1d47c8')


Name	Type	ReadOnly	References	Description
GistName [KEY]	String	False	Gists.Name	The gist identifier.
Name [KEY]	String	False		The file name.
Size	Int	True		The file size in bytes.
Type	String	True		The type of the file.
Language	String	True		The programming language of the file.
Encoding	String	True		The character encoding of the file.
Truncated	Bool	True		Indicates whether the file content has been truncated. If truncated, only up to one megabyte of content is returned.
Content	String	False		The file content.
RawUrl	String	True		The raw content URL of the file.
OwnerLogin	String	True		The username of the gist owner.