ODBC Driver for Outreach

Build 24.0.9060

Roles

Get details of where you fall within your organizations structure.

Select

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

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

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

SELECT * FROM Roles WHERE Id >= 1

SELECT * FROM Roles WHERE Id <= 1

SELECT * FROM Roles WHERE Id > 1

SELECT * FROM Roles WHERE Id < 2

SELECT * FROM Roles WHERE Name = 'test'

Columns

Name Type Description
Id [KEY] Integer Id of roles.
CreatedAt Datetime The date and time the team was created.
Name String The name of the role.
UpdatedAt Datetime The date and time the team was last updated.
LinksSelf String Link self.
ParentRoleLinks String Parent role links.
Type String Type.

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