Tableau Connector for Twilio

Build 24.0.8963

ServiceLists

Create, update, delete, and query the available Lists for a specific Service in Twilio Sync.

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. The available columns for ServiceLists are Sid, and ServiceSid.

SELECT * FROM ServiceLists WHERE Sid = 'ES5efaf437f5274d89a79' AND ServiceSid = 'ISbd3a2af64'

SELECT * FROM ServiceLists WHERE ServiceSid = 'ISbd3a2af64'

Insert

To add a ServiceList, specify at least the ServiceSid and UniqueName.

INSERT INTO ServiceLists (ServiceSid, UniqueName) VALUES ('ISbd3a2af64e5c39', 'Denis') 

Update


UPDATE ServiceLists SET TimeToLive = 10 WHERE Sid='ES5efaf437f5274d89a79' AND ServiceSid='ISbd3a2af64'

Delete


DELETE FROM ServiceLists  WHERE Sid='ES5efaf437f5274d89a79' AND ServiceSid='ISbd3a2af64'

Columns

Name Type ReadOnly References Description
Sid [KEY] String False

The unique string that identifies the Sync List resource.

ServiceSid String False

Services.Sid

The SID of the Sync Service the resource is associated with.

AccountSid String True

Accounts.Sid

The SID of the Account that created the Sync List resource.

UniqueName String False

An application-defined string that uniquely identifies the resource. It can be used in place of the resource's sid in the URL to address the resource. This column will work only with INSERT.

Url String True

The absolute URL of the Sync List resource.

Revision String True

The current revision of the Sync List, represented as a string.

DateCreated Datetime True

The date and time when the resource was created.

DateUpdated Datetime True

The date and time when the resource was last updated.

DateExpires Datetime True

The date and time when the Sync List expires and will be deleted. If the Sync List does not expire, this value is null. The Sync List might not be deleted immediately after it expires.

CreatedBy String True

The identity of the Sync List's creator. If the Sync List was created from inserting into ServiceLists table, the value is system.

TimeToLive Integer False

This column is used only when updating. It specifies how long, in seconds, before the Sync List expires and is deleted. Can be an integer from 0 to 31,536,000 (1 year). The default value is 0, which means the Sync List does not expire. The Sync List will be deleted automatically after it expires, but there can be a delay between the expiration time and the resources's deletion.

Links String True

The URLs of the Sync List's nested resources.

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