People
Create, update, and query the available people 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
- AccountId supports the following operators: =,IN
- CreatedAt supports the following operators: >, >=, <, <=
- CrmId supports the following operators: =,IN
- DoNotContact supports the following operator: =
- EmailAddress supports the following operators: =,IN,IS NULL
- ImportId supports the following operators: =, IN,IS NULL
- JobSeniority supports the following operators: =,IN,IS NULL
- LastContactedAt supports the following operators: >, >=, <, <=
- PersonStageId supports the following operators: =,IN,IS NULL
- Tags supports the following operator: =,IN
- Title supports the following operator: =
- UpdatedAt supports the following operators: >, >=, <, <=
- OwnedByGuid supports the following operators: =,IN
- CanEmail supports the following operator: =
- CanCall supports the following operator: =
- TagId supports the following operators: =,IN
- OwnerIsActive supports the following operator: =
- CadenceId supports the following operators: =,IN,IS NULL
- CustomFields* supports the following operator: =. The customFields that are created by Salesloft Admin can be filtered by specifying the name as it is on the UI.
SELECT * FROM People WHERE Id = 123 SELECT * FROM People WHERE AccountId IN (123, 1234) SELECT * FROM People WHERE EmailAddress IS NULL SELECT * FROM People WHERE MyCustomFiled = 'customValue'
Insert
To add a Person, at least the EmailAddress, FirstName and LastName need to be specified. Execute an insert in one of 2 ways.
INSERT INTO People (EmailAddress, Phone, FirstName, LastName) VALUES ('[email protected]', '123456', 'FirstNameTest', 'LastNameTest')Or using Bulk Insert:
INSERT INTO People#TEMP (EmailAddress, Phone, FirstName, LastName) VALUES ('[email protected]', '123456', 'FirstNameTest', 'LastNameTest') INSERT INTO People#TEMP (EmailAddress, Phone, FirstName, LastName) VALUES ('[email protected]', '1234567', 'FirstNameTest1', 'LastNameTest1') INSERT INTO People (EmailAddress, Phone, FirstName, LastName) SELECT EmailAddress, Phone, FirstName, LastName FROM People#TEMP
Update
Similarly, to the Insert operation we can update a Person by specifying the field and the new value.
UPDATE People SET Phone = '123456', Tags = 'tag1,tag2', WorkCity = 'NewCity' WHERE Id = 123
Upsert
To perform an upsert operation, the upsert Key must be provided. Valid options are: ID, CrmId, EmailAddress. Additionally, the 本製品 can perform a batch Upsert for more than 1 record.
UPSERT INTO People (FirstName, Id, Phone) VALUES ('AccountN', 10917448, '123')
Delete
In order to delete a Person, the Id needs to be specified.
DELETE FROM People WHERE Id = 100
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | Integer | True |
The Id property of the People table. |
AccountId | Integer | False |
The AccountId property of the People table. |
Bouncing | Boolean | False |
The Bouncing property of the People table. |
City | String | False |
The City property of the People table. |
ContactRestrictions | String | False |
The ContactRestrictions property of the People table. |
Country | String | False |
The Country property of the People table. |
CountsCalls | Integer | False |
The CountsCalls property of the People table. |
CountsEmailsBounced | Integer | True |
The CountsEmailsBounced property of the People table. |
CountsEmailsClicked | Integer | False |
The CountsEmailsClicked property of the People table. |
CountsEmailsRepliedTo | Integer | False |
The CountsEmailsRepliedTo property of the People table. |
CountsEmailsSent | Integer | False |
The CountsEmailsSent property of the People table. |
CountsEmailsViewed | Integer | False |
The CountsEmailsViewed property of the People table. |
CreatedAt | Datetime | True |
The CreatedAt property of the People table. |
CrmId | String | False |
The CrmId property of the People table. |
CrmObjectType | String | False |
The CrmObjectType property of the People table. |
CrmUrl | String | False |
The CrmUrl property of the People table. |
DisplayName | String | False |
The DisplayName property of the People table. |
DoNotContact | Boolean | False |
The DoNotContact property of the People table. |
EmailAddress | String | False |
The EmailAddress property of the People table. |
FirstName | String | False |
The FirstName property of the People table. |
FullEmailAddress | String | False |
The FullEmailAddress property of the People table. |
HomePhone | String | False |
The HomePhone property of the People table. |
ImportId | Integer | False |
The ImportId property of the People table. |
JobSeniority | String | False |
The JobSeniority property of the People table. |
LastCompletedStepId | Integer | False |
The LastCompletedStepId property of the People table. |
LastCompletedStepCadenceId | Integer | False |
The LastCompletedStepCadenceId property of the People table. |
LastContactedAt | Datetime | True |
The LastContactedAt property of the People table. |
LastContactedById | Integer | False |
The LastContactedById property of the People table. |
LastContactedType | String | False |
The LastContactedType property of the People table. |
LastName | String | False |
The LastName property of the People table. |
LastRepliedAt | Datetime | True |
The LastRepliedAt property of the People table. |
LinkedinUrl | String | False |
The LinkedinUrl property of the People table. |
Locale | String | False |
The Locale property of the People table. |
MobilePhone | String | False |
The MobilePhone property of the People table. |
MostRecentCadenceId | Integer | False |
The MostRecentCadenceId property of the People table. |
OwnerId | Integer | False |
The OwnerId property of the People table. |
OwnerCrmId | String | False |
The OwnerCrmId property of the People table. |
PersonCompanyIndustry | String | False |
The PersonCompanyIndustry property of the People table. |
PersonCompanyName | String | False |
The PersonCompanyName property of the People table. |
PersonCompanyWebsite | String | False |
The PersonCompanyWebsite property of the People table. |
PersonStageId | Integer | False |
The PersonStageId property of the People table. |
PersonalEmailAddress | String | False |
The PersonalEmailAddress property of the People table. |
PersonalWebsite | String | False |
The PersonalWebsite property of the People table. |
Phone | String | False |
The Phone property of the People table. |
PhoneExtension | String | False |
The PhoneExtension property of the People table. |
SecondaryEmailAddress | String | False |
The SecondaryEmailAddress property of the People table. |
State | String | False |
The State property of the People table. |
Tags | String | False |
The Tags property of the People table. |
Title | String | False |
The Title property of the People table. |
TwitterHandle | String | False |
The TwitterHandle property of the People table. |
UpdatedAt | Datetime | True |
The UpdatedAt property of the People table. |
WorkCity | String | False |
The WorkCity property of the People table. |
WorkCountry | String | False |
The WorkCountry property of the People table. |
WorkState | String | False |
The WorkState property of the People table. |
OwnedByGuid | String | False |
The OwnedByGuid property of the People table. |
CanEmail | Boolean | False |
The CanEmail property of the People table. |
CanCall | Boolean | False |
The CanCall property of the People table. |
TagId | Integer | False |
The TagId property of the People table. |
OwnerIsActive | Boolean | False |
The OwnerIsActive property of the People table. |
CadenceId | Integer | False |
The cadenceid property of the People table. |