Skip to content

connector-twilio.md

Latest commit

 

History

History
118 lines (80 loc) · 4.83 KB

connector-twilio.md

File metadata and controls

118 lines (80 loc) · 4.83 KB
title Transform data in Twilio (Preview)
titleSuffix Azure Data Factory & Azure Synapse
description Learn how to transform data in Twilio (Preview) by using Data Factory or Azure Synapse Analytics.
ms.author jianleishen
author jianleishen
ms.subservice data-movement
ms.topic how-to
ms.custom synapse
ms.date 01/05/2024

Transform data in Twilio (Preview) using Azure Data Factory or Synapse Analytics

[!INCLUDEappliesto-adf-asa-md]

This article outlines how to use Data Flow to transform data in Twilio (Preview). To learn more, read the introductory article for Azure Data Factory or Azure Synapse Analytics.

Important

This connector is currently in preview. You can try it out and give us feedback. If you want to take a dependency on preview connectors in your solution, please contact Azure support.

Supported capabilities

This Twilio connector is supported for the following capabilities:

Supported capabilities IR
Mapping data flow (source/-) ①

① Azure integration runtime ② Self-hosted integration runtime

For a list of data stores that are supported as sources/sinks, see the Supported data stores table.

Create a Twilio linked service using UI

Use the following steps to create a Twilio linked service in the Azure portal UI.

  1. Browse to the Manage tab in your Azure Data Factory or Synapse workspace and select Linked Services, then select New:

    Azure Data Factory

    :::image type="content" source="media/doc-common-process/new-linked-service.png" alt-text="Screenshot of creating a new linked service with Azure Data Factory U I.":::

    Azure Synapse

    :::image type="content" source="media/doc-common-process/new-linked-service-synapse.png" alt-text="Screenshot of creating a new linked service with Azure Synapse U I.":::

  2. Search for Twilio (Preview) and select the Twilio (Preview) connector.

    :::image type="content" source="media/connector-twilio/twilio-connector.png" alt-text="Screenshot showing selecting Twilio connector.":::

  3. Configure the service details, test the connection, and create the new linked service.

    :::image type="content" source="media/connector-twilio/configure-twilio-linked-service.png" alt-text="Screenshot of configuration for Twilio linked service.":::

Connector configuration details

The following sections provide information about properties that are used to define Data Factory and Synapse pipeline entities specific to Twilio.

Linked service properties

The following properties are supported for the Twilio linked service:

Property Description Required
type The type property must be set to Twilio. Yes
userName The account SID of your Twilio account. No
password The auth token of your Twilio account. Mark this field as SecureString to store it securely. Or, you can reference a secret stored in Azure Key Vault. Yes

Example:

{
    "name": "TwilioLinkedService",
    "properties": {
        "type": "Twilio",
        "typeProperties": {
            "userName": "<account SID>",
            "password": {
                "type": "SecureString",
                "value": "<auth token>"
            }
        }
    }
}

Mapping data flow properties

When transforming data in mapping data flow, you can read resources from Twilio. For more information, see the source transformation in mapping data flows. You can only use an inline dataset as source type.

Source transformation

The below table lists the properties supported by Twilio source. You can edit these properties in the Source options tab.

Name Description Required Allowed values Data flow script property
Resource The type of resources that data flow fetch from Twilio. Yes Messages
Calls		 resource
From The phone number with country code, for example +17755425856. No String from
To The phone number with country code, for example +17755425856. No String to

Twilio source script example

When you use Twilio as source type, the associated data flow script is:

source(allowSchemaDrift: true,
	validateSchema: false,
	store: 'twilio',
	format: 'rest',
	resource: 'Messages',
	from: '+17755425856') ~> TwilioSource

Related content

For a list of data stores supported as sources and sinks by the copy activity, see Supported data stores.