SSIS Components for Outreach

Build 24.0.9062

CallDispositions

A 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 '=,IN' operators.
For example, the following query is processed server side:
SELECT * FROM CallDispositions WHERE Id = 1

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

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

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

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

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

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

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

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

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

SELECT * FROM CallDispositions 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 disposition's name.
OrderValue Integer The disposition's display OrderValue within the collection.
Outcome String The disposition's call outcome.

使用できる値は次のとおりです。Answered, Not Answered

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