Connecting to Guru

Using Basic Authentication

Guru uses Basic authentication with your username (email address) and an API token. To generate an API token:

1. Log in to your Guru account
2. Navigate to Settings > API
3. Click "Create New API Token"
4. Copy the generated API token (it will only be shown once)

After obtaining your API token, set the following connection properties:

• AuthScheme: Set this to Basic.
• User: Set this to your Guru username (email address).
• Password: Set this to your API token.

Connecting to Guru

Once the authentication is configured, you can connect to Guru and query data from any of the available tables such as Cards, Collections, Folders, Teams, and more.

Available Tables

The Guru API Profile provides access to the following tables:

• Teams: Retrieve teams in the Guru organization
• Cards: Access knowledge cards with content and metadata
• Collections: Query knowledge collections
• Folders: Access folder structures
• UserGroups: Retrieve user groups and their members
• Announcements: Query announcements and their statistics
• Tags: Access tags and tag categories
• Analytics: Retrieve usage analytics and statistics

API Documentation

For more information about the Guru API, see the official Guru API documentation.

Usage Examples

Analytics:

SELECT * FROM Analytics WHERE TeamId = '847c53c0-ea6c-40c2-87c3-f6775911b07d'

Announcements:

SELECT * FROM Announcements

AnnouncementStatsFull:

SELECT * FROM AnnouncementStatsFull WHERE AlertId = '391891da-af1a-4511-a296-31ca0a5d0b4a'

AnnouncementStatsSummary:

SELECT * FROM AnnouncementStatsSummary WHERE AlertId = '391891da-af1a-4511-a296-31ca0a5d0b4a'

AnnouncementStatsUsers:

SELECT * FROM AnnouncementStatsUsers WHERE AlertId = '391891da-af1a-4511-a296-31ca0a5d0b4a'

CardComments:

SELECT * FROM CardComments WHERE CardId = 'ab004609-9101-404f-af29-90c2c68c7ee8'

CardFavoriteLists:

SELECT * FROM CardFavoriteLists WHERE CardId = 'e8a38a84-db11-4151-b115-5636f6472cc0'

CardFolders:

SELECT * FROM CardFolders WHERE CardId = '3eddb5db-84cd-4881-a8d7-ae36ae5fde4e'

Cards:

SELECT * FROM Cards WHERE CardId = 'ab004609-9101-404f-af29-90c2c68c7ee8'

CardTemplates:

SELECT * FROM CardTemplates WHERE TemplateId = 'ec1c4520-c0ae-4afe-95e3-805fa7bfb664'

CardVerifiers:

SELECT * FROM CardVerifiers WHERE CardId = 'ab004609-9101-404f-af29-90c2c68c7ee8' AND VerifierId = '[email protected]'

CollectionAccess:

SELECT * FROM CollectionAccess WHERE CollectionId = '0412727f-a273-48c7-9639-69416e181996'

Collections:

SELECT * FROM Collections WHERE CollectionId = '0412727f-a273-48c7-9639-69416e181996'

DirectReports:

SELECT * FROM DirectReports WHERE ManagerId = '78ac0188-f31f-4877-a2ae-a353cbe91d6e'

FolderEffectivePermissions:

SELECT * FROM FolderEffectivePermissions WHERE FolderId = 'fc417076-e197-4409-a2cd-bcc965d92417'

FolderItems:

SELECT * FROM FolderItems WHERE FolderId = 'f992196b-7074-4b62-828b-fbaf8fc27a92'

FolderParent:

SELECT * FROM FolderParent WHERE FolderId = 'fc417076-e197-4409-a2cd-bcc965d92417'

FolderPermissions:

SELECT * FROM FolderPermissions WHERE FolderId = 'ed741ab7-edb8-44de-a594-5a586dc1f2e4'

Folders:

SELECT * FROM Folders
SELECT * FROM Folders WHERE FolderId = '98e52516-787f-4a37-bc6f-f626331744ea'

FolderSearch:

SELECT * FROM FolderSearch WHERE Terms = 'sample'

GroupCollections:

SELECT * FROM GroupCollections WHERE GroupId = '92320d89-4fe1-42aa-a30f-b8a554fdf394'

GroupMembers:

SELECT * FROM GroupMembers WHERE GroupId = '92320d89-4fe1-42aa-a30f-b8a554fdf394'

KnowledgeAssistants:

SELECT * FROM KnowledgeAssistants

People:

SELECT * FROM People WHERE Id = '39d09d8a-b935-4250-9f8a-880c2688d052'

SearchCardMgr:

SELECT * FROM SearchCardMgr

SearchCards:

SELECT * FROM SearchCards

TagCategories:

SELECT * FROM TagCategories WHERE TeamId = '847c53c0-ea6c-40c2-87c3-f6775911b07d'

Tags:

SELECT * FROM Tags WHERE TeamId = '847c53c0-ea6c-40c2-87c3-f6775911b07d' AND TagId = '39b74613-ddf4-42cf-b6be-d1ca21500f79'

TeamMembers:

SELECT * FROM TeamMembers

TeamStats:

SELECT * FROM TeamStats WHERE TeamId = '847c53c0-ea6c-40c2-87c3-f6775911b07d'

UnverifiedCards:

SELECT * FROM UnverifiedCards

UserGroups:

SELECT * FROM UserGroups

WhoAmI:

SELECT * FROM WhoAmI

Connection Properties

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider.

---

Property	Description
AuthScheme	The scheme used for authentication. Accepted entries are Basic or None. Allowed values are: BASIC, NONE, NTLM, OAUTH, APIKEY, OAUTH_CLIENT
Password	The API token used to authenticate to Guru.
User	The Guru account username or email address used to authenticate.