TDV Adapter for Outreach

Build 22.0.8462

Snippets

Piece of an email to be reused in multiple messages.

Select

The adapter will use the API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the adapter.

  • Id supports the '=,IN,>=,<=,>,<' operators.
  • CreatedAt supports the '=,>=,<=,>,<' operators.
  • Name supports the '=,IN' operators.
  • ShareType supports the '=,IN' operators.
  • UpdatedAt supports the '=,>=,<=,>,<' operators.
For example, the following query is processed server side:
SELECT * FROM Snippets WHERE Id = 1

SELECT * FROM Snippets WHERE Id IN (1,2)

SELECT * FROM Snippets WHERE Id >= 1

SELECT * FROM Snippets WHERE Id <= 1

SELECT * FROM Snippets WHERE Id > 1

SELECT * FROM Snippets WHERE Id < 2

SELECT * FROM Snippets WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Snippets WHERE CreatedAt >= '2022-01-25 01:02:02.0' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Snippets WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Snippets WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Snippets WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Snippets WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Snippets WHERE ShareType = 'private'

SELECT * FROM Snippets WHERE Name = 'test'

SELECT * FROM Snippets WHERE UpdatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Snippets WHERE UpdatedAt < '2022-02-25 01:02:02.0'

Columns

Name Type Description
Id [KEY] Integer Id of sequence snippet.
BodyHtml String The HTML of the snippet.
BodyText String The text of the snippet.
ContainsCustomHtml Boolean Contains Custom HTML.
CreatedAt Datetime The date and time the snippet was created.
Name String The name of the snippet.
ShareType String The permissions for sharing the snippet.

The allowed values are private, shared.

Tags String A list of tags associated with the snippet.
UpdatedAt Datetime The date and time the snippet was last updated.
LinksSelf String Link self.
ContentCategoryMembershipsLinks String Content category memberships links.
CreatorId Integer Creator Id.
CreatorType String Creator type.
FavoritesLinks String Favorites links.
OwnerId Integer Owner Id.
OwnerType String Owner type.
UpdaterId Integer Updater Id.
UpdaterType String Updater type.
Type String Type.

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