JDBC Driver for Salesloft

Build 22.0.8462

Accounts

Create, update, and query the available accounts 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
  • AccountTierId supports the following operators: =,IN,IS NULL
  • CreatedAt supports the following operators: >, >=, <, <=
  • CrmId supports the following operators: =,IN
  • Domain supports the following operators: =,IN
  • LastContactedAt supports the following operators: >, >=, <, <=
  • OwnerId supports the following operators: =,IN,IS NULL
  • Tags supports the following operators: =,IN
  • UpdatedAt supports the following operators: >, >=, <, <=
  • Website supports the following operators: =,IN,IS NULL
  • Archived supports the following operator: =
  • TagId supports the following operators: =,IN
  • AccountStageId supports the following operators: =,IN,IS NULL
  • OwnerIsActive supports the following operator: =
  • CustomFields* supports the following operator: =. The customFields that are created by the Salesloft Admin can be filtered by specifying the name as it is visible in the UI.
The following queries are processed server side:
    SELECT * FROM Accounts WHERE ID = 123
    SELECT * FROM Accounts WHERE AccountTierId IN ('123', '1234')
    SELECT * FROM Accounts WHERE CreatedAt >= '2022-12-01'
    SELECT * FROM Accounts WHERE CrmId IN ('123', '1234')
    SELECT * FROM Accounts WHERE Domain IN ('domainA', 'domainB')
	SELECT * FROM Accounts WHERE MyCustomFiled = 'customValue'
	,etc.

Insert

To add an Account, at least the Domain and Name need to be specified. The driver is able to execute an insert in two ways.

  INSERT INTO Accounts (Domain, Name, Description)
    VALUES ('DomainTest.com', 'TestAccount', 'Description of test account' )
Or using Bulk Insert:
INSERT INTO Accounts#TEMP (Domain, Name, Description) VALUES ('DomainTest.com', 'TestAccount', 'Description of test account' )
INSERT INTO Accounts#TEMP (Domain, Name, Description) VALUES ('DomainTest1.com', 'TestAccount1', 'Description of test account1' )

INSERT INTO Accounts (Domain, Name, Description)
SELECT Domain, Name, Description FROM Accounts#TEMP

Update

Similarly, to the Insert operation we can update an item by specifying the field and the new value.

UPDATE Accounts SET Description = 'Updated Description', Phone = '123', Country = 'US', State = 'CA'
       WHERE ID = 13391259

Upsert

To perform an upsert operation, the upsert Key must be provided. Valid options are: ID, CrmId, Domain. Additionally, the Salesloft can perform a batch Upsert for more than 1 record.

UPSERT INTO Accounts (name, id, domain, description, Tags, OwnerId)
		VALUES ('AccountN' ,10917448, 'AccountDom.com', 'This is an upsert', 'tag1Upsert,tag2Upsert', 16081 )

Delete

In order to delete an Account the ID needs to be specified, for ex.:

DELETE FROM Accounts WHERE ID = 100

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

The Id property of the Account table.

AccountTierId Integer False

The AccountTierId property of the Account table.

ArchivedAt Datetime True

The ArchivedAt property of the Account table.

City String False

The City property of the Account table.

CompanyStageId Integer False

The CompanyStageId property of the Account table.

CompanyType String False

The CompanyType property of the Account table.

ConversationalName String True

The ConversationalName property of the Account table.

Country String False

The Country property of the Account table.

CountsPeople Integer False

The CountsPeople property of the Account table.

CreatedAt Datetime True

The CreatedAt property of the Account table.

CreatorId Integer False

The CreatorId property of the Account table.

CrmId String False

The CrmId property of the Account table.

CrmObjectType String False

The CrmObjectType property of the Account table.

CrmUrl String False

The CrmUrl property of the Account table.

Description String False

The Description property of the Account table.

DoNotContact Boolean False

The DoNotContact property of the Account table.

Domain String False

The Domain property of the Account table.

Founded String False

The Founded property of the Account table.

Industry String False

The Industry property of the Account table.

LastContactedAt Datetime True

The LastContactedAt property of the Account table.

LastContactedById Integer False

The LastContactedById property of the Account table.

LastContactedPersonId Integer False

The LastContactedPersonId property of the Account table.

LastContactedType String False

The LastContactedType property of the Account table.

LinkedinUrl String False

The LinkedinUrl property of the Account table.

Locale String False

The Locale property of the Account table.

Name String False

The Name property of the Account table.

OwnerId Integer False

The OwnerId property of the Account table.

OwnerCrmId String False

The OwnerCrmId property of the Account table.

Phone String False

The Phone property of the Account table.

PostalCode String False

The PostalCode property of the Account table.

RevenueRange String False

The RevenueRange property of the Account table.

Size String False

The Size property of the Account table.

State String False

The State property of the Account table.

Street String False

The Street property of the Account table.

Tags String False

The Tags property of the Account table.

TwitterHandle String False

The TwitterHandle property of the Account table.

UpdatedAt Datetime True

The UpdatedAt property of the Account table.

Website String False

The Website property of the Account table.

Archived Boolean False

The Archived property of the Account table.

TagId Integer False

The TagId property of the Account table.

AccountStageId Integer False

The AccountStageId property of the Account table.

OwnerIsActive Boolean False

The OwnerIsActive property of the Account table.

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