JDBC Driver for Outreach

Build 24.0.9062

CallPurposes

Get details of ready-made collection of call dispositions that help categorize your call logs.

Select

The 本製品 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 本製品.

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

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

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

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

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

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

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

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

SELECT * FROM CallPurposes WHERE Name = 'Answered - Meeting Set'

SELECT * FROM CallPurposes WHERE Name IN ('test', 'ram')

SELECT * FROM CallPurposes WHERE OrderValue = 1

Columns

Name Type Description
Id [KEY] Integer Id.
CreatedAt Datetime The date and time the call disposition was created.
LinksSelf String Links self.
Name String The purpose's name.
OrderValue Integer The purpose's display OrderValue within the collection.
UpdatedAt Datetime The date and time the call disposition was last updated.
CallsLinks String Calls Links.
CreatorId Integer Creator Id.
Type String Type of disposition.

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