JDBC Driver for Streak

Build 22.0.8462

Snippets

This call lets you get all the snippets for a user, also you can get a single snippet

Table Specific Information

Select

Streak allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only = comparision. The available column for Snippets is SnippetKey. For example:

SELECT * FROM Snippets WHERE SnippetKey='agxzfm1haWxmb29nYWVyLwsSDE9yZ2FuaXphdGlvbgvJY2RhdGEuY29tDAsSB1NuaXBwZXQYgIDsmPfxwAsM'

Columns

Name Type References Description
SnippetKey [KEY] String Key of the snippet.
UserKey String

Users.UserKey

The key of the user that created the snippet.
CreationDate Timestamp The date and time the snippet was created.
PipelineKey String

Pipelines.PipelineKey

Key of the pipeline.
PartOfPipeline Boolean Whether this snippet is part of a pipeline or not.
SnippetText String The text of the snippet.
SnippetName String The name of the snippet.
SnippetKeyShortcut String Shortcut of the snippet key.
Subject String Subject of the snippets.
SnippetType String The type of the snippet, can be TEXT or HTML.
LastSavedTimestamp Timestamp When the snippet was last saved.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462