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

APPLIES TO: Azure Data Factory Azure Synapse Analytics

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

This AppFigures connector is supported for the following capabilities:

① 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.

Use the following steps to create an AppFigures 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
   • Azure Synapse

   

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

   

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

   

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

The following properties are supported for the AppFigures linked service:

Example:

{
    "name": "AppFiguresLinkedService",
    "properties": {
        "type": "AppFigures",
        "typeProperties": {
            "userName": "<username>",
            "password": "<password>",
            "clientKey": "<client key>"
        }
    }
}

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

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

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

source(allowSchemaDrift: true,
	validateSchema: false,
	store: 'appfigures',
	format: 'rest',
	entityType: 'products') ~> AppFiguresSource

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