SSIS Components for Twilio

Build 21.0.7871

FeedbackSummary

Create, delete, and query Feedback Summaries in Twilio.

Select

Twilio allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can be used with only the equals or = comparison. Only Sid is supported in the WHERE clause and it is required.

SELECT * FROM FeedbackSummary WHERE Sid = 'FS123456789'

Insert

To add a FeedbackSummary, specify at least these parameters: StartDate, EndDate, and IncludeSubaccounts.

INSERT INTO FeedbackSummary (StartDate, EndDate,IncludeSubaccounts) VALUES ('2014-06-01','2014-06-30',true)

Update

Twilio does not allow FeedbackSummary to be updated.

Columns

Name Type ReadOnly References Description
Sid [KEY] String False

The Id of the feedback summary.

StartDate Date False

The start date of the feedback summary.

EndDate Date False

The end date of the feedback summary.

AccountSid String True

The account Id of the feedback summary.

IncludeSubaccounts Boolean False

Whether to include subaccounts in feedback summary.

使用できる値は次のとおりです。true, false

Status String True

The status of the feedback summary. One of the following values: queued, in-progress, completed, or failed.

CallCount Integer True

The total call count.

CallFeedbackCount Integer True

The count of calls associated with the feedback summary.

QSAverage Double True

The quality score average of the feedback summary.

QSMedian Double True

The quality score median of the feedback avarage.

QSStandardDeviation Double True

The quality score standard deviation of the feedback summary.

IssuesDescription String True

The issues description of the feedback summary.

IssuesCount Integer True

The issues count of the feedback summary.

IssuesPercentageOfTotalCalls Double True

The percentage of calls that experienced this issue.

DateCreated Datetime True

The creation date of the feedback summary.

DateUpdated Datetime True

The modification date of the feedback summary.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7871