Imports
Create, update, and query the available Imports 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
- UserIDs supports the following operators: =,IN
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. |