ADO.NET Provider for Outreach

Build 24.0.9060

Personas

A descriptor of a person used for categorizing prospects.

Select

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

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

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

SELECT * FROM Personas WHERE Id >= 1

SELECT * FROM Personas WHERE Id <= 1

SELECT * FROM Personas WHERE Id > 1

SELECT * FROM Personas WHERE Id < 2

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

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

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

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

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

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

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

SELECT * FROM Personas WHERE Name = 'Prospecting'

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

Columns

Name Type Description
Id [KEY] Integer Id of persona.
CreatedAt Datetime The date and time the persona was created.
Description String A description of the persona.
Name String The name of the persona.
UpdatedAt Datetime The date and time the persona was last updated.
LinksSelf String Link self.
ProspectsLinks String The prospects with this persona.
Type String Type.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060