Tableau Connector for Twilio

Build 24.0.8963

OutgoingCallerIds

Insert, update, and query the verified numbers that may be used as a caller Id when making outgoing calls 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 typically be used with only the equals or = comparison. The available columns for OutgoingCallerIds are PhoneNumber, Name, and Sid.

SELECT * FROM OutgoingCallerIds WHERE Sid = 'X123456789'

Insert

To add an OutgoingCallerId use the AddOutgoingCallerIds stored procedure.

EXEC AddOutgoingCallerIds PhoneNumber = '+15105555555'

Update

Twilio allows the Name column to be updated.

UPDATE OutgoingCallerIds SET Name = 'test' WHERE Sid = 'O123456789'

Delete

Twilio does not allow OutgoingCallerIds to be deleted.

Columns

Name Type ReadOnly References Description
Sid [KEY] String True

The Id of the outgoing caller Id.

AccountSid String True

The account Id of the outgoing caller Id.

DateCreated Datetime True

The creation date of the outgoing caller Id.

DateUpdated Datetime True

The modfication date of the outgoing caller Id.

Name String False

The friendly name of the outgoing caller Id. By default, this is a formatted phone number.

PhoneNumber String False

The phone number of the outgoing caller Id.

Uri String True

The URI of the outgoing caller Id.

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