JDBC Driver for Salesloft

Build 22.0.8462

Imports

Create, update, and query the available Imports in SalesLoft.

Select

The driver will use the Salesloft API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.

  • Id supports the following operators: =,IN
  • UserIDs supports the following operators: =,IN
The following queries are processed server side:
    SELECT * FROM Imports WHERE Id IN (1234, 4321)
    SELECT * FROM Imports WHERE UserIDs IN (123, 321)

Insert

To add an Import UserId and Name need to be specified.

  INSERT INTO Imports (UserId, Name)
    VALUES (123, 'ImportTest')

Update

Similarly to the Insert operation, update an Import by specifying the field and the new value.

UPDATE Imports SET Name = 'new test'
        WHERE Id = 123

Delete

In order to delete an Import the Id needs to be specified, for ex.

DELETE FROM Imports WHERE Id = 100

Columns

Name Type ReadOnly Description
Id [KEY] Integer False

The Id of the Import.

CreatedAt Datetime True

The CreatedAt of the Import.

UpdatedAt Datetime True

The UpdatedAt of the Import.

Name String False

The Name of the Import.

CurrentPeopleCount Integer False

The CurrentPeopleCount of the Import.

ImportedPeopleCount Integer False

The ImportedPeopleCount of the Import.

UserIDs String False

The OwnedByGuid property of the Import table.

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