JDBC Driver for Slack

Build 22.0.8462

Calls

Register,update,end or return information about a Call.

Select

You must specify the Id column in the WHERE clause to query the Calls table.

The driver will use the Slack API to process search criteria that refer to the Id column. This column supports server-side processing for the = operator. The driver processes other filters client-side within the driver.

For example, the following query is processed server side:

SELECT * FROM Calls WHERE Id='R04HH525YBS'

Insert

Inserts are allowed when you specify the ExternalUniqueId and JoinURL. For example:

INSERT INTO Calls(ExternalUniqueId, JoinURL) VALUES(uniqId, joinurl)

Update

Updates are allowed when you specify the Id.

UPDATE Calls SET JoinURL='join', Title='t' WHERE Id='R04HH525YBS'

Delete

You can delete a pin by providing the Id.

DELETE FROM Calls WHERE id='R04HH525YBS' 

Columns

Name Type ReadOnly Description
Id [KEY] String True

Id of the call.

DateStart Datetime True

Start time of the call.

DesktopAppJoinURL String False

The desktop app join url of the call.

ExternalDisplayId String False

The external display of the call.

ExternalUniqueId String False

The external unique Id of the call.

JoinURL String False

The joining url of the call.

Title String False

The title of the call.

Users String True

The users involved in the call.

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