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

Select

The 本製品 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 本製品.

• 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 本製品 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.