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

Select

The cmdlet 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 cmdlet.

• 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.