Table of Contents
Appflow.
Client
¶A low-level client representing Amazon Appflow
Welcome to the Amazon AppFlow API reference. This guide is for developers who need detailed information about the Amazon AppFlow API operations, data types, and errors.
Amazon AppFlow is a fully managed integration service that enables you to securely transfer data between software as a service (SaaS) applications like Salesforce, Marketo, Slack, and ServiceNow, and Amazon Web Services like Amazon S3 and Amazon Redshift.
Use the following links to get started on the Amazon AppFlow API:
If you're new to Amazon AppFlow, we recommend that you review the Amazon AppFlow User Guide.
Amazon AppFlow API users can use vendor-specific mechanisms for OAuth, and include applicable OAuth attributes (such as auth-code
and redirecturi
) with the connector-specific ConnectorProfileProperties
when creating a new connector profile using Amazon AppFlow API operations. For example, Salesforce users can refer to the Authorize Apps with OAuth documentation.
import boto3
client = boto3.client('appflow')
These are the available methods:
can_paginate()
close()
create_connector_profile()
create_flow()
delete_connector_profile()
delete_flow()
describe_connector()
describe_connector_entity()
describe_connector_profiles()
describe_connectors()
describe_flow()
describe_flow_execution_records()
get_paginator()
get_waiter()
list_connector_entities()
list_connectors()
list_flows()
list_tags_for_resource()
register_connector()
start_flow()
stop_flow()
tag_resource()
unregister_connector()
untag_resource()
update_connector_profile()
update_connector_registration()
update_flow()
can_paginate
(operation_name)¶Check if an operation can be paginated.
create_foo
, and you'd normally invoke the
operation as client.create_foo(**kwargs)
, if the
create_foo
operation can be paginated, you can use the
call client.get_paginator("create_foo")
.True
if the operation can be paginated,
False
otherwise.close
()¶Closes underlying endpoint connections.
create_connector_profile
(**kwargs)¶Creates a new connector profile associated with your Amazon Web Services account. There is a soft quota of 100 connector profiles per Amazon Web Services account. If you need more connector profiles than this quota allows, you can submit a request to the Amazon AppFlow team through the Amazon AppFlow support channel. In each connector profile that you create, you can provide the credentials and properties for only one connector.
See also: AWS API Documentation
Request Syntax
response = client.create_connector_profile(
connectorProfileName='string',
kmsArn='string',
connectorType='Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
connectorLabel='string',
connectionMode='Public'|'Private',
connectorProfileConfig={
'connectorProfileProperties': {
'Amplitude': {}
,
'Datadog': {
'instanceUrl': 'string'
},
'Dynatrace': {
'instanceUrl': 'string'
},
'GoogleAnalytics': {}
,
'Honeycode': {}
,
'InforNexus': {
'instanceUrl': 'string'
},
'Marketo': {
'instanceUrl': 'string'
},
'Redshift': {
'databaseUrl': 'string',
'bucketName': 'string',
'bucketPrefix': 'string',
'roleArn': 'string',
'dataApiRoleArn': 'string',
'isRedshiftServerless': True|False,
'clusterIdentifier': 'string',
'workgroupName': 'string',
'databaseName': 'string'
},
'Salesforce': {
'instanceUrl': 'string',
'isSandboxEnvironment': True|False
},
'ServiceNow': {
'instanceUrl': 'string'
},
'Singular': {}
,
'Slack': {
'instanceUrl': 'string'
},
'Snowflake': {
'warehouse': 'string',
'stage': 'string',
'bucketName': 'string',
'bucketPrefix': 'string',
'privateLinkServiceName': 'string',
'accountName': 'string',
'region': 'string'
},
'Trendmicro': {}
,
'Veeva': {
'instanceUrl': 'string'
},
'Zendesk': {
'instanceUrl': 'string'
},
'SAPOData': {
'applicationHostUrl': 'string',
'applicationServicePath': 'string',
'portNumber': 123,
'clientNumber': 'string',
'logonLanguage': 'string',
'privateLinkServiceName': 'string',
'oAuthProperties': {
'tokenUrl': 'string',
'authCodeUrl': 'string',
'oAuthScopes': [
'string',
]
}
},
'CustomConnector': {
'profileProperties': {
'string': 'string'
},
'oAuth2Properties': {
'tokenUrl': 'string',
'oAuth2GrantType': 'CLIENT_CREDENTIALS'|'AUTHORIZATION_CODE',
'tokenUrlCustomProperties': {
'string': 'string'
}
}
}
},
'connectorProfileCredentials': {
'Amplitude': {
'apiKey': 'string',
'secretKey': 'string'
},
'Datadog': {
'apiKey': 'string',
'applicationKey': 'string'
},
'Dynatrace': {
'apiToken': 'string'
},
'GoogleAnalytics': {
'clientId': 'string',
'clientSecret': 'string',
'accessToken': 'string',
'refreshToken': 'string',
'oAuthRequest': {
'authCode': 'string',
'redirectUri': 'string'
}
},
'Honeycode': {
'accessToken': 'string',
'refreshToken': 'string',
'oAuthRequest': {
'authCode': 'string',
'redirectUri': 'string'
}
},
'InforNexus': {
'accessKeyId': 'string',
'userId': 'string',
'secretAccessKey': 'string',
'datakey': 'string'
},
'Marketo': {
'clientId': 'string',
'clientSecret': 'string',
'accessToken': 'string',
'oAuthRequest': {
'authCode': 'string',
'redirectUri': 'string'
}
},
'Redshift': {
'username': 'string',
'password': 'string'
},
'Salesforce': {
'accessToken': 'string',
'refreshToken': 'string',
'oAuthRequest': {
'authCode': 'string',
'redirectUri': 'string'
},
'clientCredentialsArn': 'string'
},
'ServiceNow': {
'username': 'string',
'password': 'string'
},
'Singular': {
'apiKey': 'string'
},
'Slack': {
'clientId': 'string',
'clientSecret': 'string',
'accessToken': 'string',
'oAuthRequest': {
'authCode': 'string',
'redirectUri': 'string'
}
},
'Snowflake': {
'username': 'string',
'password': 'string'
},
'Trendmicro': {
'apiSecretKey': 'string'
},
'Veeva': {
'username': 'string',
'password': 'string'
},
'Zendesk': {
'clientId': 'string',
'clientSecret': 'string',
'accessToken': 'string',
'oAuthRequest': {
'authCode': 'string',
'redirectUri': 'string'
}
},
'SAPOData': {
'basicAuthCredentials': {
'username': 'string',
'password': 'string'
},
'oAuthCredentials': {
'clientId': 'string',
'clientSecret': 'string',
'accessToken': 'string',
'refreshToken': 'string',
'oAuthRequest': {
'authCode': 'string',
'redirectUri': 'string'
}
}
},
'CustomConnector': {
'authenticationType': 'OAUTH2'|'APIKEY'|'BASIC'|'CUSTOM',
'basic': {
'username': 'string',
'password': 'string'
},
'oauth2': {
'clientId': 'string',
'clientSecret': 'string',
'accessToken': 'string',
'refreshToken': 'string',
'oAuthRequest': {
'authCode': 'string',
'redirectUri': 'string'
}
},
'apiKey': {
'apiKey': 'string',
'apiSecretKey': 'string'
},
'custom': {
'customAuthenticationType': 'string',
'credentialsMap': {
'string': 'string'
}
}
}
}
}
)
[REQUIRED]
The name of the connector profile. The name is unique for each ConnectorProfile
in your Amazon Web Services account.
[REQUIRED]
The type of connector, such as Salesforce, Amplitude, and so on.
ConnectorRegistration
in your Amazon Web Services account. Only needed if calling for CUSTOMCONNECTOR connector type/.[REQUIRED]
Indicates the connection mode and specifies whether it is public or private. Private flows use Amazon Web Services PrivateLink to route data over Amazon Web Services infrastructure without exposing it to the public internet.
[REQUIRED]
Defines the connector-specific configuration and credentials.
The connector-specific properties of the profile configuration.
The connector-specific properties required by Amplitude.
The connector-specific properties required by Datadog.
The location of the Datadog resource.
The connector-specific properties required by Dynatrace.
The location of the Dynatrace resource.
The connector-specific properties required Google Analytics.
The connector-specific properties required by Amazon Honeycode.
The connector-specific properties required by Infor Nexus.
The location of the Infor Nexus resource.
The connector-specific properties required by Marketo.
The location of the Marketo resource.
The connector-specific properties required by Amazon Redshift.
The JDBC URL of the Amazon Redshift cluster.
A name for the associated Amazon S3 bucket.
The object key for the destination bucket in which Amazon AppFlow places the files.
The Amazon Resource Name (ARN) of IAM role that grants Amazon Redshift read-only access to Amazon S3. For more information, and for the polices that you attach to this role, see Allow Amazon Redshift to access your Amazon AppFlow data in Amazon S3.
The Amazon Resource Name (ARN) of an IAM role that permits Amazon AppFlow to access your Amazon Redshift database through the Data API. For more information, and for the polices that you attach to this role, see Allow Amazon AppFlow to access Amazon Redshift databases with the Data API.
Indicates whether the connector profile defines a connection to an Amazon Redshift Serverless data warehouse.
The unique ID that's assigned to an Amazon Redshift cluster.
The name of an Amazon Redshift workgroup.
The name of an Amazon Redshift database.
The connector-specific properties required by Salesforce.
The location of the Salesforce resource.
Indicates whether the connector profile applies to a sandbox or production environment.
The connector-specific properties required by serviceNow.
The location of the ServiceNow resource.
The connector-specific properties required by Singular.
The connector-specific properties required by Slack.
The location of the Slack resource.
The connector-specific properties required by Snowflake.
The name of the Snowflake warehouse.
The name of the Amazon S3 stage that was created while setting up an Amazon S3 stage in the Snowflake account. This is written in the following format: < Database>< Schema><Stage Name>.
The name of the Amazon S3 bucket associated with Snowflake.
The bucket path that refers to the Amazon S3 bucket associated with Snowflake.
The Snowflake Private Link service name to be used for private data transfers.
The name of the account.
The Amazon Web Services Region of the Snowflake account.
The connector-specific properties required by Trend Micro.
The connector-specific properties required by Veeva.
The location of the Veeva resource.
The connector-specific properties required by Zendesk.
The location of the Zendesk resource.
The connector-specific profile properties required when using SAPOData.
The location of the SAPOData resource.
The application path to catalog service.
The port number of the SAPOData instance.
The client number for the client creating the connection.
The logon language of SAPOData instance.
The SAPOData Private Link service name to be used for private data transfers.
The SAPOData OAuth properties required for OAuth type authentication.
The token url required to fetch access/refresh tokens using authorization code and also to refresh expired access token using refresh token.
The authorization code url required to redirect to SAP Login Page to fetch authorization code for OAuth type authentication.
The OAuth scopes required for OAuth type authentication.
The properties required by the custom connector.
A map of properties that are required to create a profile for the custom connector.
The OAuth 2.0 properties required for OAuth 2.0 authentication.
The token URL required for OAuth 2.0 authentication.
The OAuth 2.0 grant type used by connector for OAuth 2.0 authentication.
Associates your token URL with a map of properties that you define. Use this parameter to provide any additional details that the connector requires to authenticate your request.
The connector-specific credentials required by each connector.
The connector-specific credentials required when using Amplitude.
A unique alphanumeric identifier used to authenticate a user, developer, or calling program to your API.
The Secret Access Key portion of the credentials.
The connector-specific credentials required when using Datadog.
A unique alphanumeric identifier used to authenticate a user, developer, or calling program to your API.
Application keys, in conjunction with your API key, give you full access to Datadog’s programmatic API. Application keys are associated with the user account that created them. The application key is used to log all requests made to the API.
The connector-specific credentials required when using Dynatrace.
The API tokens used by Dynatrace API to authenticate various API calls.
The connector-specific credentials required when using Google Analytics.
The identifier for the desired client.
The client secret used by the OAuth client to authenticate to the authorization server.
The credentials used to access protected Google Analytics resources.
The credentials used to acquire new access tokens. This is required only for OAuth2 access tokens, and is not required for OAuth1 access tokens.
The OAuth requirement needed to request security tokens from the connector endpoint.
The code provided by the connector when it has been authenticated via the connected app.
The URL to which the authentication server redirects the browser after authorization has been granted.
The connector-specific credentials required when using Amazon Honeycode.
The credentials used to access protected Amazon Honeycode resources.
The credentials used to acquire new access tokens.
Used by select connectors for which the OAuth workflow is supported, such as Salesforce, Google Analytics, Marketo, Zendesk, and Slack.
The code provided by the connector when it has been authenticated via the connected app.
The URL to which the authentication server redirects the browser after authorization has been granted.
The connector-specific credentials required when using Infor Nexus.
The Access Key portion of the credentials.
The identifier for the user.
The secret key used to sign requests.
The encryption keys used to encrypt data.
The connector-specific credentials required when using Marketo.
The identifier for the desired client.
The client secret used by the OAuth client to authenticate to the authorization server.
The credentials used to access protected Marketo resources.
The OAuth requirement needed to request security tokens from the connector endpoint.
The code provided by the connector when it has been authenticated via the connected app.
The URL to which the authentication server redirects the browser after authorization has been granted.
The connector-specific credentials required when using Amazon Redshift.
The name of the user.
The password that corresponds to the user name.
The connector-specific credentials required when using Salesforce.
The credentials used to access protected Salesforce resources.
The credentials used to acquire new access tokens.
The OAuth requirement needed to request security tokens from the connector endpoint.
The code provided by the connector when it has been authenticated via the connected app.
The URL to which the authentication server redirects the browser after authorization has been granted.
The secret manager ARN, which contains the client ID and client secret of the connected app.
The connector-specific credentials required when using ServiceNow.
The name of the user.
The password that corresponds to the user name.
The connector-specific credentials required when using Singular.
A unique alphanumeric identifier used to authenticate a user, developer, or calling program to your API.
The connector-specific credentials required when using Slack.
The identifier for the client.
The client secret used by the OAuth client to authenticate to the authorization server.
The credentials used to access protected Slack resources.
The OAuth requirement needed to request security tokens from the connector endpoint.
The code provided by the connector when it has been authenticated via the connected app.
The URL to which the authentication server redirects the browser after authorization has been granted.
The connector-specific credentials required when using Snowflake.
The name of the user.
The password that corresponds to the user name.
The connector-specific credentials required when using Trend Micro.
The Secret Access Key portion of the credentials.
The connector-specific credentials required when using Veeva.
The name of the user.
The password that corresponds to the user name.
The connector-specific credentials required when using Zendesk.
The identifier for the desired client.
The client secret used by the OAuth client to authenticate to the authorization server.
The credentials used to access protected Zendesk resources.
The OAuth requirement needed to request security tokens from the connector endpoint.
The code provided by the connector when it has been authenticated via the connected app.
The URL to which the authentication server redirects the browser after authorization has been granted.
The connector-specific profile credentials required when using SAPOData.
The SAPOData basic authentication credentials.
The username to use to connect to a resource.
The password to use to connect to a resource.
The SAPOData OAuth type authentication credentials.
The identifier for the desired client.
The client secret used by the OAuth client to authenticate to the authorization server.
The access token used to access protected SAPOData resources.
The refresh token used to refresh expired access token.
The OAuth requirement needed to request security tokens from the connector endpoint.
The code provided by the connector when it has been authenticated via the connected app.
The URL to which the authentication server redirects the browser after authorization has been granted.
The connector-specific profile credentials that are required when using the custom connector.
The authentication type that the custom connector uses for authenticating while creating a connector profile.
The basic credentials that are required for the authentication of the user.
The username to use to connect to a resource.
The password to use to connect to a resource.
The OAuth 2.0 credentials required for the authentication of the user.
The identifier for the desired client.
The client secret used by the OAuth client to authenticate to the authorization server.
The access token used to access the connector on your behalf.
The refresh token used to refresh an expired access token.
Used by select connectors for which the OAuth workflow is supported, such as Salesforce, Google Analytics, Marketo, Zendesk, and Slack.
The code provided by the connector when it has been authenticated via the connected app.
The URL to which the authentication server redirects the browser after authorization has been granted.
The API keys required for the authentication of the user.
The API key required for API key authentication.
The API secret key required for API key authentication.
If the connector uses the custom authentication mechanism, this holds the required credentials.
The custom authentication type that the connector uses.
A map that holds custom authentication credentials.
dict
Response Syntax
{
'connectorProfileArn': 'string'
}
Response Structure
(dict) --
connectorProfileArn (string) --
The Amazon Resource Name (ARN) of the connector profile.
Exceptions
Appflow.Client.exceptions.ValidationException
Appflow.Client.exceptions.ConflictException
Appflow.Client.exceptions.ServiceQuotaExceededException
Appflow.Client.exceptions.ConnectorAuthenticationException
Appflow.Client.exceptions.InternalServerException
create_flow
(**kwargs)¶Enables your application to create a new flow using Amazon AppFlow. You must create a connector profile before calling this API. Please note that the Request Syntax below shows syntax for multiple destinations, however, you can only transfer data to one item in this list at a time. Amazon AppFlow does not currently support flows to multiple destinations at once.
See also: AWS API Documentation
Request Syntax
response = client.create_flow(
flowName='string',
description='string',
kmsArn='string',
triggerConfig={
'triggerType': 'Scheduled'|'Event'|'OnDemand',
'triggerProperties': {
'Scheduled': {
'scheduleExpression': 'string',
'dataPullMode': 'Incremental'|'Complete',
'scheduleStartTime': datetime(2015, 1, 1),
'scheduleEndTime': datetime(2015, 1, 1),
'timezone': 'string',
'scheduleOffset': 123,
'firstExecutionFrom': datetime(2015, 1, 1),
'flowErrorDeactivationThreshold': 123
}
}
},
sourceFlowConfig={
'connectorType': 'Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
'apiVersion': 'string',
'connectorProfileName': 'string',
'sourceConnectorProperties': {
'Amplitude': {
'object': 'string'
},
'Datadog': {
'object': 'string'
},
'Dynatrace': {
'object': 'string'
},
'GoogleAnalytics': {
'object': 'string'
},
'InforNexus': {
'object': 'string'
},
'Marketo': {
'object': 'string'
},
'S3': {
'bucketName': 'string',
'bucketPrefix': 'string',
's3InputFormatConfig': {
's3InputFileType': 'CSV'|'JSON'
}
},
'Salesforce': {
'object': 'string',
'enableDynamicFieldUpdate': True|False,
'includeDeletedRecords': True|False,
'dataTransferApi': 'AUTOMATIC'|'BULKV2'|'REST_SYNC'
},
'ServiceNow': {
'object': 'string'
},
'Singular': {
'object': 'string'
},
'Slack': {
'object': 'string'
},
'Trendmicro': {
'object': 'string'
},
'Veeva': {
'object': 'string',
'documentType': 'string',
'includeSourceFiles': True|False,
'includeRenditions': True|False,
'includeAllVersions': True|False
},
'Zendesk': {
'object': 'string'
},
'SAPOData': {
'objectPath': 'string'
},
'CustomConnector': {
'entityName': 'string',
'customProperties': {
'string': 'string'
}
}
},
'incrementalPullConfig': {
'datetimeTypeFieldName': 'string'
}
},
destinationFlowConfigList=[
{
'connectorType': 'Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
'apiVersion': 'string',
'connectorProfileName': 'string',
'destinationConnectorProperties': {
'Redshift': {
'object': 'string',
'intermediateBucketName': 'string',
'bucketPrefix': 'string',
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
}
},
'S3': {
'bucketName': 'string',
'bucketPrefix': 'string',
's3OutputFormatConfig': {
'fileType': 'CSV'|'JSON'|'PARQUET',
'prefixConfig': {
'prefixType': 'FILENAME'|'PATH'|'PATH_AND_FILENAME',
'prefixFormat': 'YEAR'|'MONTH'|'DAY'|'HOUR'|'MINUTE',
'pathPrefixHierarchy': [
'EXECUTION_ID'|'SCHEMA_VERSION',
]
},
'aggregationConfig': {
'aggregationType': 'None'|'SingleFile',
'targetFileSize': 123
},
'preserveSourceDataTyping': True|False
}
},
'Salesforce': {
'object': 'string',
'idFieldNames': [
'string',
],
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
},
'writeOperationType': 'INSERT'|'UPSERT'|'UPDATE'|'DELETE',
'dataTransferApi': 'AUTOMATIC'|'BULKV2'|'REST_SYNC'
},
'Snowflake': {
'object': 'string',
'intermediateBucketName': 'string',
'bucketPrefix': 'string',
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
}
},
'EventBridge': {
'object': 'string',
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
}
},
'LookoutMetrics': {}
,
'Upsolver': {
'bucketName': 'string',
'bucketPrefix': 'string',
's3OutputFormatConfig': {
'fileType': 'CSV'|'JSON'|'PARQUET',
'prefixConfig': {
'prefixType': 'FILENAME'|'PATH'|'PATH_AND_FILENAME',
'prefixFormat': 'YEAR'|'MONTH'|'DAY'|'HOUR'|'MINUTE',
'pathPrefixHierarchy': [
'EXECUTION_ID'|'SCHEMA_VERSION',
]
},
'aggregationConfig': {
'aggregationType': 'None'|'SingleFile',
'targetFileSize': 123
}
}
},
'Honeycode': {
'object': 'string',
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
}
},
'CustomerProfiles': {
'domainName': 'string',
'objectTypeName': 'string'
},
'Zendesk': {
'object': 'string',
'idFieldNames': [
'string',
],
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
},
'writeOperationType': 'INSERT'|'UPSERT'|'UPDATE'|'DELETE'
},
'Marketo': {
'object': 'string',
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
}
},
'CustomConnector': {
'entityName': 'string',
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
},
'writeOperationType': 'INSERT'|'UPSERT'|'UPDATE'|'DELETE',
'idFieldNames': [
'string',
],
'customProperties': {
'string': 'string'
}
},
'SAPOData': {
'objectPath': 'string',
'successResponseHandlingConfig': {
'bucketPrefix': 'string',
'bucketName': 'string'
},
'idFieldNames': [
'string',
],
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
},
'writeOperationType': 'INSERT'|'UPSERT'|'UPDATE'|'DELETE'
}
}
},
],
tasks=[
{
'sourceFields': [
'string',
],
'connectorOperator': {
'Amplitude': 'BETWEEN',
'Datadog': 'PROJECTION'|'BETWEEN'|'EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Dynatrace': 'PROJECTION'|'BETWEEN'|'EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'GoogleAnalytics': 'PROJECTION'|'BETWEEN',
'InforNexus': 'PROJECTION'|'BETWEEN'|'EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Marketo': 'PROJECTION'|'LESS_THAN'|'GREATER_THAN'|'BETWEEN'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'S3': 'PROJECTION'|'LESS_THAN'|'GREATER_THAN'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Salesforce': 'PROJECTION'|'LESS_THAN'|'CONTAINS'|'GREATER_THAN'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'ServiceNow': 'PROJECTION'|'CONTAINS'|'LESS_THAN'|'GREATER_THAN'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Singular': 'PROJECTION'|'EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Slack': 'PROJECTION'|'LESS_THAN'|'GREATER_THAN'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Trendmicro': 'PROJECTION'|'EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Veeva': 'PROJECTION'|'LESS_THAN'|'GREATER_THAN'|'CONTAINS'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Zendesk': 'PROJECTION'|'GREATER_THAN'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'SAPOData': 'PROJECTION'|'LESS_THAN'|'CONTAINS'|'GREATER_THAN'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'CustomConnector': 'PROJECTION'|'LESS_THAN'|'GREATER_THAN'|'CONTAINS'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP'
},
'destinationField': 'string',
'taskType': 'Arithmetic'|'Filter'|'Map'|'Map_all'|'Mask'|'Merge'|'Passthrough'|'Truncate'|'Validate'|'Partition',
'taskProperties': {
'string': 'string'
}
},
],
tags={
'string': 'string'
},
metadataCatalogConfig={
'glueDataCatalog': {
'roleArn': 'string',
'databaseName': 'string',
'tablePrefix': 'string'
}
}
)
[REQUIRED]
The specified name of the flow. Spaces are not allowed. Use underscores (_) or hyphens (-) only.
[REQUIRED]
The trigger settings that determine how and when the flow runs.
Specifies the type of flow trigger. This can be OnDemand
, Scheduled
, or Event
.
Specifies the configuration details of a schedule-triggered flow as defined by the user. Currently, these settings only apply to the Scheduled
trigger type.
Specifies the configuration details of a schedule-triggered flow as defined by the user.
The scheduling expression that determines the rate at which the schedule will run, for example rate(5minutes)
.
Specifies whether a scheduled flow has an incremental data transfer or a complete data transfer for each flow run.
The time at which the scheduled flow starts. The time is formatted as a timestamp that follows the ISO 8601 standard, such as 2022-04-26T13:00:00-07:00
.
The time at which the scheduled flow ends. The time is formatted as a timestamp that follows the ISO 8601 standard, such as 2022-04-27T13:00:00-07:00
.
Specifies the time zone used when referring to the dates and times of a scheduled flow, such as America/New_York
. This time zone is only a descriptive label. It doesn't affect how Amazon AppFlow interprets the timestamps that you specify to schedule the flow.
If you want to schedule a flow by using times in a particular time zone, indicate the time zone as a UTC offset in your timestamps. For example, the UTC offsets for the America/New_York
timezone are -04:00
EDT and -05:00 EST
.
Specifies the optional offset that is added to the time interval for a schedule-triggered flow.
Specifies the date range for the records to import from the connector in the first flow run.
Defines how many times a scheduled flow fails consecutively before Amazon AppFlow deactivates it.
[REQUIRED]
The configuration that controls how Amazon AppFlow retrieves data from the source connector.
The type of connector, such as Salesforce, Amplitude, and so on.
The API version of the connector when it's used as a source in the flow.
The name of the connector profile. This name must be unique for each connector profile in the Amazon Web Services account.
Specifies the information that is required to query a particular source connector.
Specifies the information that is required for querying Amplitude.
The object specified in the Amplitude flow source.
Specifies the information that is required for querying Datadog.
The object specified in the Datadog flow source.
Specifies the information that is required for querying Dynatrace.
The object specified in the Dynatrace flow source.
Specifies the information that is required for querying Google Analytics.
The object specified in the Google Analytics flow source.
Specifies the information that is required for querying Infor Nexus.
The object specified in the Infor Nexus flow source.
Specifies the information that is required for querying Marketo.
The object specified in the Marketo flow source.
Specifies the information that is required for querying Amazon S3.
The Amazon S3 bucket name where the source files are stored.
The object key for the Amazon S3 bucket in which the source files are stored.
When you use Amazon S3 as the source, the configuration format that you provide the flow input data.
The file type that Amazon AppFlow gets from your Amazon S3 bucket.
Specifies the information that is required for querying Salesforce.
The object specified in the Salesforce flow source.
The flag that enables dynamic fetching of new (recently added) fields in the Salesforce objects while running a flow.
Indicates whether Amazon AppFlow includes deleted files in the flow run.
Specifies which Salesforce API is used by Amazon AppFlow when your flow transfers data from Salesforce.
AUTOMATIC
The default. Amazon AppFlow selects which API to use based on the number of records that your flow transfers from Salesforce. If your flow transfers fewer than 1,000,000 records, Amazon AppFlow uses Salesforce REST API. If your flow transfers 1,000,000 records or more, Amazon AppFlow uses Salesforce Bulk API 2.0.
Each of these Salesforce APIs structures data differently. If Amazon AppFlow selects the API automatically, be aware that, for recurring flows, the data output might vary from one flow run to the next. For example, if a flow runs daily, it might use REST API on one day to transfer 900,000 records, and it might use Bulk API 2.0 on the next day to transfer 1,100,000 records. For each of these flow runs, the respective Salesforce API formats the data differently. Some of the differences include how dates are formatted and null values are represented. Also, Bulk API 2.0 doesn't transfer Salesforce compound fields.
By choosing this option, you optimize flow performance for both small and large data transfers, but the tradeoff is inconsistent formatting in the output.
BULKV2
Amazon AppFlow uses only Salesforce Bulk API 2.0. This API runs asynchronous data transfers, and it's optimal for large sets of data. By choosing this option, you ensure that your flow writes consistent output, but you optimize performance only for large data transfers.
Note that Bulk API 2.0 does not transfer Salesforce compound fields.
REST_SYNC
Amazon AppFlow uses only Salesforce REST API. By choosing this option, you ensure that your flow writes consistent output, but you decrease performance for large data transfers that are better suited for Bulk API 2.0. In some cases, if your flow attempts to transfer a vary large set of data, it might fail wituh a timed out error.
Specifies the information that is required for querying ServiceNow.
The object specified in the ServiceNow flow source.
Specifies the information that is required for querying Singular.
The object specified in the Singular flow source.
Specifies the information that is required for querying Slack.
The object specified in the Slack flow source.
Specifies the information that is required for querying Trend Micro.
The object specified in the Trend Micro flow source.
Specifies the information that is required for querying Veeva.
The object specified in the Veeva flow source.
The document type specified in the Veeva document extract flow.
Boolean value to include source files in Veeva document extract flow.
Boolean value to include file renditions in Veeva document extract flow.
Boolean value to include All Versions of files in Veeva document extract flow.
Specifies the information that is required for querying Zendesk.
The object specified in the Zendesk flow source.
The properties that are applied when using SAPOData as a flow source.
The object path specified in the SAPOData flow source.
The properties that are applied when the custom connector is being used as a source.
The entity specified in the custom connector as a source in the flow.
Custom properties that are required to use the custom connector as a source.
Defines the configuration for a scheduled incremental data pull. If a valid configuration is provided, the fields specified in the configuration are used when querying for the incremental data pull.
A field that specifies the date time or timestamp field as the criteria to use when importing incremental records from the source.
[REQUIRED]
The configuration that controls how Amazon AppFlow places data in the destination connector.
Contains information about the configuration of destination connectors present in the flow.
The type of connector, such as Salesforce, Amplitude, and so on.
The API version that the destination connector uses.
The name of the connector profile. This name must be unique for each connector profile in the Amazon Web Services account.
This stores the information that is required to query a particular connector.
The properties required to query Amazon Redshift.
The object specified in the Amazon Redshift flow destination.
The intermediate bucket that Amazon AppFlow uses when moving data into Amazon Redshift.
The object key for the bucket in which Amazon AppFlow places the destination files.
The settings that determine how Amazon AppFlow handles an error when placing data in the Amazon Redshift destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The properties required to query Amazon S3.
The Amazon S3 bucket name in which Amazon AppFlow places the transferred data.
The object key for the destination bucket in which Amazon AppFlow places the files.
The configuration that determines how Amazon AppFlow should format the flow output data when Amazon S3 is used as the destination.
Indicates the file type that Amazon AppFlow places in the Amazon S3 bucket.
Determines the prefix that Amazon AppFlow applies to the folder name in the Amazon S3 bucket. You can name folders according to the flow frequency and date.
Determines the format of the prefix, and whether it applies to the file name, file path, or both.
Determines the level of granularity for the date and time that's included in the prefix.
Specifies whether the destination file path includes either or both of the following elements:
EXECUTION_ID
The ID that Amazon AppFlow assigns to the flow run.
SCHEMA_VERSION
The version number of your data schema. Amazon AppFlow assigns this version number. The version number increases by one when you change any of the following settings in your flow configuration:
The aggregation settings that you can use to customize the output format of your flow data.
Specifies whether Amazon AppFlow aggregates the flow records into a single file, or leave them unaggregated.
The desired file size, in MB, for each output file that Amazon AppFlow writes to the flow destination. For each file, Amazon AppFlow attempts to achieve the size that you specify. The actual file sizes might differ from this target based on the number and size of the records that each file contains.
If your file output format is Parquet, use this parameter to set whether Amazon AppFlow preserves the data types in your source data when it writes the output to Amazon S3.
true
: Amazon AppFlow preserves the data types when it writes to Amazon S3. For example, an integer or 1
in your source data is still an integer in your output.false
: Amazon AppFlow converts all of the source data into strings when it writes to Amazon S3. For example, an integer of 1
in your source data becomes the string "1"
in the output.The properties required to query Salesforce.
The object specified in the Salesforce flow destination.
The name of the field that Amazon AppFlow uses as an ID when performing a write operation such as update or delete.
The settings that determine how Amazon AppFlow handles an error when placing data in the Salesforce destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
This specifies the type of write operation to be performed in Salesforce. When the value is UPSERT
, then idFieldNames
is required.
Specifies which Salesforce API is used by Amazon AppFlow when your flow transfers data to Salesforce.
AUTOMATIC
The default. Amazon AppFlow selects which API to use based on the number of records that your flow transfers to Salesforce. If your flow transfers fewer than 1,000 records, Amazon AppFlow uses Salesforce REST API. If your flow transfers 1,000 records or more, Amazon AppFlow uses Salesforce Bulk API 2.0.
Each of these Salesforce APIs structures data differently. If Amazon AppFlow selects the API automatically, be aware that, for recurring flows, the data output might vary from one flow run to the next. For example, if a flow runs daily, it might use REST API on one day to transfer 900 records, and it might use Bulk API 2.0 on the next day to transfer 1,100 records. For each of these flow runs, the respective Salesforce API formats the data differently. Some of the differences include how dates are formatted and null values are represented. Also, Bulk API 2.0 doesn't transfer Salesforce compound fields.
By choosing this option, you optimize flow performance for both small and large data transfers, but the tradeoff is inconsistent formatting in the output.
BULKV2
Amazon AppFlow uses only Salesforce Bulk API 2.0. This API runs asynchronous data transfers, and it's optimal for large sets of data. By choosing this option, you ensure that your flow writes consistent output, but you optimize performance only for large data transfers.
Note that Bulk API 2.0 does not transfer Salesforce compound fields.
REST_SYNC
Amazon AppFlow uses only Salesforce REST API. By choosing this option, you ensure that your flow writes consistent output, but you decrease performance for large data transfers that are better suited for Bulk API 2.0. In some cases, if your flow attempts to transfer a vary large set of data, it might fail with a timed out error.
The properties required to query Snowflake.
The object specified in the Snowflake flow destination.
The intermediate bucket that Amazon AppFlow uses when moving data into Snowflake.
The object key for the destination bucket in which Amazon AppFlow places the files.
The settings that determine how Amazon AppFlow handles an error when placing data in the Snowflake destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The properties required to query Amazon EventBridge.
The object specified in the Amazon EventBridge flow destination.
The settings that determine how Amazon AppFlow handles an error when placing data in the destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The properties required to query Amazon Lookout for Metrics.
The properties required to query Upsolver.
The Upsolver Amazon S3 bucket name in which Amazon AppFlow places the transferred data.
The object key for the destination Upsolver Amazon S3 bucket in which Amazon AppFlow places the files.
The configuration that determines how data is formatted when Upsolver is used as the flow destination.
Indicates the file type that Amazon AppFlow places in the Upsolver Amazon S3 bucket.
Specifies elements that Amazon AppFlow includes in the file and folder names in the flow destination.
Determines the format of the prefix, and whether it applies to the file name, file path, or both.
Determines the level of granularity for the date and time that's included in the prefix.
Specifies whether the destination file path includes either or both of the following elements:
EXECUTION_ID
The ID that Amazon AppFlow assigns to the flow run.
SCHEMA_VERSION
The version number of your data schema. Amazon AppFlow assigns this version number. The version number increases by one when you change any of the following settings in your flow configuration:
The aggregation settings that you can use to customize the output format of your flow data.
Specifies whether Amazon AppFlow aggregates the flow records into a single file, or leave them unaggregated.
The desired file size, in MB, for each output file that Amazon AppFlow writes to the flow destination. For each file, Amazon AppFlow attempts to achieve the size that you specify. The actual file sizes might differ from this target based on the number and size of the records that each file contains.
The properties required to query Amazon Honeycode.
The object specified in the Amazon Honeycode flow destination.
The settings that determine how Amazon AppFlow handles an error when placing data in the destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The properties required to query Amazon Connect Customer Profiles.
The unique name of the Amazon Connect Customer Profiles domain.
The object specified in the Amazon Connect Customer Profiles flow destination.
The properties required to query Zendesk.
The object specified in the Zendesk flow destination.
A list of field names that can be used as an ID field when performing a write operation.
The settings that determine how Amazon AppFlow handles an error when placing data in the destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The possible write operations in the destination connector. When this value is not provided, this defaults to the INSERT
operation.
The properties required to query Marketo.
The object specified in the Marketo flow destination.
The settings that determine how Amazon AppFlow handles an error when placing data in the destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The properties that are required to query the custom Connector.
The entity specified in the custom connector as a destination in the flow.
The settings that determine how Amazon AppFlow handles an error when placing data in the custom connector as destination.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
Specifies the type of write operation to be performed in the custom connector when it's used as destination.
The name of the field that Amazon AppFlow uses as an ID when performing a write operation such as update, delete, or upsert.
The custom properties that are specific to the connector when it's used as a destination in the flow.
The properties required to query SAPOData.
The object path specified in the SAPOData flow destination.
Determines how Amazon AppFlow handles the success response that it gets from the connector after placing data.
For example, this setting would determine where to write the response from a destination connector upon a successful insert operation.
The Amazon S3 bucket prefix.
The name of the Amazon S3 bucket.
A list of field names that can be used as an ID field when performing a write operation.
The settings that determine how Amazon AppFlow handles an error when placing data in the destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The possible write operations in the destination connector. When this value is not provided, this defaults to the INSERT
operation.
[REQUIRED]
A list of tasks that Amazon AppFlow performs while transferring the data in the flow run.
A class for modeling different type of tasks. Task implementation varies based on the TaskType
.
The source fields to which a particular task is applied.
The operation to be performed on the provided source fields.
The operation to be performed on the provided Amplitude source fields.
The operation to be performed on the provided Datadog source fields.
The operation to be performed on the provided Dynatrace source fields.
The operation to be performed on the provided Google Analytics source fields.
The operation to be performed on the provided Infor Nexus source fields.
The operation to be performed on the provided Marketo source fields.
The operation to be performed on the provided Amazon S3 source fields.
The operation to be performed on the provided Salesforce source fields.
The operation to be performed on the provided ServiceNow source fields.
The operation to be performed on the provided Singular source fields.
The operation to be performed on the provided Slack source fields.
The operation to be performed on the provided Trend Micro source fields.
The operation to be performed on the provided Veeva source fields.
The operation to be performed on the provided Zendesk source fields.
The operation to be performed on the provided SAPOData source fields.
Operators supported by the custom connector.
A field in a destination connector, or a field value against which Amazon AppFlow validates a source field.
Specifies the particular task implementation that Amazon AppFlow performs.
A map used to store task-related information. The execution service looks for particular information based on the TaskType
.
The tags used to organize, track, or control access for your flow.
Specifies the configuration that Amazon AppFlow uses when it catalogs the data that's transferred by the associated flow. When Amazon AppFlow catalogs the data from a flow, it stores metadata in a data catalog.
Specifies the configuration that Amazon AppFlow uses when it catalogs your data with the Glue Data Catalog.
The Amazon Resource Name (ARN) of an IAM role that grants Amazon AppFlow the permissions it needs to create Data Catalog tables, databases, and partitions.
For an example IAM policy that has the required permissions, see Identity-based policy examples for Amazon AppFlow.
The name of the Data Catalog database that stores the metadata tables that Amazon AppFlow creates in your Amazon Web Services account. These tables contain metadata for the data that's transferred by the flow that you configure with this parameter.
Note
When you configure a new flow with this parameter, you must specify an existing database.
A naming prefix for each Data Catalog table that Amazon AppFlow creates for the flow that you configure with this setting. Amazon AppFlow adds the prefix to the beginning of the each table name.
dict
Response Syntax
{
'flowArn': 'string',
'flowStatus': 'Active'|'Deprecated'|'Deleted'|'Draft'|'Errored'|'Suspended'
}
Response Structure
(dict) --
flowArn (string) --
The flow's Amazon Resource Name (ARN).
flowStatus (string) --
Indicates the current status of the flow.
Exceptions
Appflow.Client.exceptions.ValidationException
Appflow.Client.exceptions.InternalServerException
Appflow.Client.exceptions.ResourceNotFoundException
Appflow.Client.exceptions.ServiceQuotaExceededException
Appflow.Client.exceptions.ConflictException
Appflow.Client.exceptions.ConnectorAuthenticationException
Appflow.Client.exceptions.ConnectorServerException
delete_connector_profile
(**kwargs)¶Enables you to delete an existing connector profile.
See also: AWS API Documentation
Request Syntax
response = client.delete_connector_profile(
connectorProfileName='string',
forceDelete=True|False
)
[REQUIRED]
The name of the connector profile. The name is unique for each ConnectorProfile
in your account.
dict
Response Syntax
{}
Response Structure
Exceptions
Appflow.Client.exceptions.ResourceNotFoundException
Appflow.Client.exceptions.ConflictException
Appflow.Client.exceptions.InternalServerException
delete_flow
(**kwargs)¶Enables your application to delete an existing flow. Before deleting the flow, Amazon AppFlow validates the request by checking the flow configuration and status. You can delete flows one at a time.
See also: AWS API Documentation
Request Syntax
response = client.delete_flow(
flowName='string',
forceDelete=True|False
)
[REQUIRED]
The specified name of the flow. Spaces are not allowed. Use underscores (_) or hyphens (-) only.
dict
Response Syntax
{}
Response Structure
Exceptions
Appflow.Client.exceptions.ResourceNotFoundException
Appflow.Client.exceptions.ConflictException
Appflow.Client.exceptions.InternalServerException
describe_connector
(**kwargs)¶Describes the given custom connector registered in your Amazon Web Services account. This API can be used for custom connectors that are registered in your account and also for Amazon authored connectors.
See also: AWS API Documentation
Request Syntax
response = client.describe_connector(
connectorType='Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
connectorLabel='string'
)
[REQUIRED]
The connector type, such as CUSTOMCONNECTOR, Saleforce, Marketo. Please choose CUSTOMCONNECTOR for Lambda based custom connectors.
ConnectorRegistration
in your Amazon Web Services account. Only needed if calling for CUSTOMCONNECTOR connector type/.dict
Response Syntax
{
'connectorConfiguration': {
'canUseAsSource': True|False,
'canUseAsDestination': True|False,
'supportedDestinationConnectors': [
'Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
],
'supportedSchedulingFrequencies': [
'BYMINUTE'|'HOURLY'|'DAILY'|'WEEKLY'|'MONTHLY'|'ONCE',
],
'isPrivateLinkEnabled': True|False,
'isPrivateLinkEndpointUrlRequired': True|False,
'supportedTriggerTypes': [
'Scheduled'|'Event'|'OnDemand',
],
'connectorMetadata': {
'Amplitude': {},
'Datadog': {},
'Dynatrace': {},
'GoogleAnalytics': {
'oAuthScopes': [
'string',
]
},
'InforNexus': {},
'Marketo': {},
'Redshift': {},
'S3': {},
'Salesforce': {
'oAuthScopes': [
'string',
],
'dataTransferApis': [
'AUTOMATIC'|'BULKV2'|'REST_SYNC',
]
},
'ServiceNow': {},
'Singular': {},
'Slack': {
'oAuthScopes': [
'string',
]
},
'Snowflake': {
'supportedRegions': [
'string',
]
},
'Trendmicro': {},
'Veeva': {},
'Zendesk': {
'oAuthScopes': [
'string',
]
},
'EventBridge': {},
'Upsolver': {},
'CustomerProfiles': {},
'Honeycode': {
'oAuthScopes': [
'string',
]
},
'SAPOData': {}
},
'connectorType': 'Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
'connectorLabel': 'string',
'connectorDescription': 'string',
'connectorOwner': 'string',
'connectorName': 'string',
'connectorVersion': 'string',
'connectorArn': 'string',
'connectorModes': [
'string',
],
'authenticationConfig': {
'isBasicAuthSupported': True|False,
'isApiKeyAuthSupported': True|False,
'isOAuth2Supported': True|False,
'isCustomAuthSupported': True|False,
'oAuth2Defaults': {
'oauthScopes': [
'string',
],
'tokenUrls': [
'string',
],
'authCodeUrls': [
'string',
],
'oauth2GrantTypesSupported': [
'CLIENT_CREDENTIALS'|'AUTHORIZATION_CODE',
],
'oauth2CustomProperties': [
{
'key': 'string',
'isRequired': True|False,
'label': 'string',
'description': 'string',
'isSensitiveField': True|False,
'connectorSuppliedValues': [
'string',
],
'type': 'TOKEN_URL'|'AUTH_URL'
},
]
},
'customAuthConfigs': [
{
'customAuthenticationType': 'string',
'authParameters': [
{
'key': 'string',
'isRequired': True|False,
'label': 'string',
'description': 'string',
'isSensitiveField': True|False,
'connectorSuppliedValues': [
'string',
]
},
]
},
]
},
'connectorRuntimeSettings': [
{
'key': 'string',
'dataType': 'string',
'isRequired': True|False,
'label': 'string',
'description': 'string',
'scope': 'string',
'connectorSuppliedValueOptions': [
'string',
]
},
],
'supportedApiVersions': [
'string',
],
'supportedOperators': [
'PROJECTION'|'LESS_THAN'|'GREATER_THAN'|'CONTAINS'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
],
'supportedWriteOperations': [
'INSERT'|'UPSERT'|'UPDATE'|'DELETE',
],
'connectorProvisioningType': 'LAMBDA',
'connectorProvisioningConfig': {
'lambda': {
'lambdaArn': 'string'
}
},
'logoURL': 'string',
'registeredAt': datetime(2015, 1, 1),
'registeredBy': 'string'
}
}
Response Structure
(dict) --
connectorConfiguration (dict) --
Configuration info of all the connectors that the user requested.
canUseAsSource (boolean) --
Specifies whether the connector can be used as a source.
canUseAsDestination (boolean) --
Specifies whether the connector can be used as a destination.
supportedDestinationConnectors (list) --
Lists the connectors that are available for use as destinations.
supportedSchedulingFrequencies (list) --
Specifies the supported flow frequency for that connector.
isPrivateLinkEnabled (boolean) --
Specifies if PrivateLink is enabled for that connector.
isPrivateLinkEndpointUrlRequired (boolean) --
Specifies if a PrivateLink endpoint URL is required.
supportedTriggerTypes (list) --
Specifies the supported trigger types for the flow.
connectorMetadata (dict) --
Specifies connector-specific metadata such as oAuthScopes
, supportedRegions
, privateLinkServiceUrl
, and so on.
Amplitude (dict) --
The connector metadata specific to Amplitude.
Datadog (dict) --
The connector metadata specific to Datadog.
Dynatrace (dict) --
The connector metadata specific to Dynatrace.
GoogleAnalytics (dict) --
The connector metadata specific to Google Analytics.
oAuthScopes (list) --
The desired authorization scope for the Google Analytics account.
InforNexus (dict) --
The connector metadata specific to Infor Nexus.
Marketo (dict) --
The connector metadata specific to Marketo.
Redshift (dict) --
The connector metadata specific to Amazon Redshift.
S3 (dict) --
The connector metadata specific to Amazon S3.
Salesforce (dict) --
The connector metadata specific to Salesforce.
oAuthScopes (list) --
The desired authorization scope for the Salesforce account.
dataTransferApis (list) --
The Salesforce APIs that you can have Amazon AppFlow use when your flows transfers data to or from Salesforce.
ServiceNow (dict) --
The connector metadata specific to ServiceNow.
Singular (dict) --
The connector metadata specific to Singular.
Slack (dict) --
The connector metadata specific to Slack.
oAuthScopes (list) --
The desired authorization scope for the Slack account.
Snowflake (dict) --
The connector metadata specific to Snowflake.
supportedRegions (list) --
Specifies the supported Amazon Web Services Regions when using Snowflake.
Trendmicro (dict) --
The connector metadata specific to Trend Micro.
Veeva (dict) --
The connector metadata specific to Veeva.
Zendesk (dict) --
The connector metadata specific to Zendesk.
oAuthScopes (list) --
The desired authorization scope for the Zendesk account.
EventBridge (dict) --
The connector metadata specific to Amazon EventBridge.
Upsolver (dict) --
The connector metadata specific to Upsolver.
CustomerProfiles (dict) --
The connector metadata specific to Amazon Connect Customer Profiles.
Honeycode (dict) --
The connector metadata specific to Amazon Honeycode.
oAuthScopes (list) --
The desired authorization scope for the Amazon Honeycode account.
SAPOData (dict) --
The connector metadata specific to SAPOData.
connectorType (string) --
The connector type.
connectorLabel (string) --
The label used for registering the connector.
connectorDescription (string) --
A description about the connector.
connectorOwner (string) --
The owner who developed the connector.
connectorName (string) --
The connector name.
connectorVersion (string) --
The connector version.
connectorArn (string) --
The Amazon Resource Name (ARN) for the registered connector.
connectorModes (list) --
The connection modes that the connector supports.
authenticationConfig (dict) --
The authentication config required for the connector.
isBasicAuthSupported (boolean) --
Indicates whether basic authentication is supported by the connector.
isApiKeyAuthSupported (boolean) --
Indicates whether API key authentication is supported by the connector
isOAuth2Supported (boolean) --
Indicates whether OAuth 2.0 authentication is supported by the connector.
isCustomAuthSupported (boolean) --
Indicates whether custom authentication is supported by the connector
oAuth2Defaults (dict) --
Contains the default values required for OAuth 2.0 authentication.
oauthScopes (list) --
OAuth 2.0 scopes that the connector supports.
tokenUrls (list) --
Token URLs that can be used for OAuth 2.0 authentication.
authCodeUrls (list) --
Auth code URLs that can be used for OAuth 2.0 authentication.
oauth2GrantTypesSupported (list) --
OAuth 2.0 grant types supported by the connector.
oauth2CustomProperties (list) --
List of custom parameters required for OAuth 2.0 authentication.
(dict) --
Custom parameter required for OAuth 2.0 authentication.
key (string) --
The key of the custom parameter required for OAuth 2.0 authentication.
isRequired (boolean) --
Indicates whether the custom parameter for OAuth 2.0 authentication is required.
label (string) --
The label of the custom parameter used for OAuth 2.0 authentication.
description (string) --
A description about the custom parameter used for OAuth 2.0 authentication.
isSensitiveField (boolean) --
Indicates whether this authentication custom parameter is a sensitive field.
connectorSuppliedValues (list) --
Contains default values for this authentication parameter that are supplied by the connector.
type (string) --
Indicates whether custom parameter is used with TokenUrl or AuthUrl.
customAuthConfigs (list) --
Contains information required for custom authentication.
(dict) --
Configuration information required for custom authentication.
customAuthenticationType (string) --
The authentication type that the custom connector uses.
authParameters (list) --
Information about authentication parameters required for authentication.
(dict) --
Information about required authentication parameters.
key (string) --
The authentication key required to authenticate with the connector.
isRequired (boolean) --
Indicates whether this authentication parameter is required.
label (string) --
Label used for authentication parameter.
description (string) --
A description about the authentication parameter.
isSensitiveField (boolean) --
Indicates whether this authentication parameter is a sensitive field.
connectorSuppliedValues (list) --
Contains default values for this authentication parameter that are supplied by the connector.
connectorRuntimeSettings (list) --
The required connector runtime settings.
(dict) --
Contains information about the connector runtime settings that are required for flow execution.
key (string) --
Contains value information about the connector runtime setting.
dataType (string) --
Data type of the connector runtime setting.
isRequired (boolean) --
Indicates whether this connector runtime setting is required.
label (string) --
A label used for connector runtime setting.
description (string) --
A description about the connector runtime setting.
scope (string) --
Indicates the scope of the connector runtime setting.
connectorSuppliedValueOptions (list) --
Contains default values for the connector runtime setting that are supplied by the connector.
supportedApiVersions (list) --
A list of API versions that are supported by the connector.
supportedOperators (list) --
A list of operators supported by the connector.
supportedWriteOperations (list) --
A list of write operations supported by the connector.
(string) --
The possible write operations in the destination connector. When this value is not provided, this defaults to the INSERT
operation.
connectorProvisioningType (string) --
The provisioning type used to register the connector.
connectorProvisioningConfig (dict) --
The configuration required for registering the connector.
lambda (dict) --
Contains information about the configuration of the lambda which is being registered as the connector.
lambdaArn (string) --
Lambda ARN of the connector being registered.
logoURL (string) --
Logo URL of the connector.
registeredAt (datetime) --
The date on which the connector was registered.
registeredBy (string) --
Information about who registered the connector.
Exceptions
Appflow.Client.exceptions.ValidationException
Appflow.Client.exceptions.InternalServerException
Appflow.Client.exceptions.ResourceNotFoundException
describe_connector_entity
(**kwargs)¶Provides details regarding the entity used with the connector, with a description of the data model for each field in that entity.
See also: AWS API Documentation
Request Syntax
response = client.describe_connector_entity(
connectorEntityName='string',
connectorType='Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
connectorProfileName='string',
apiVersion='string'
)
[REQUIRED]
The entity name for that connector.
ConnectorProfile
in the Amazon Web Services account.dict
Response Syntax
{
'connectorEntityFields': [
{
'identifier': 'string',
'parentIdentifier': 'string',
'label': 'string',
'isPrimaryKey': True|False,
'defaultValue': 'string',
'isDeprecated': True|False,
'supportedFieldTypeDetails': {
'v1': {
'fieldType': 'string',
'filterOperators': [
'PROJECTION'|'LESS_THAN'|'GREATER_THAN'|'CONTAINS'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
],
'supportedValues': [
'string',
],
'valueRegexPattern': 'string',
'supportedDateFormat': 'string',
'fieldValueRange': {
'maximum': 123.0,
'minimum': 123.0
},
'fieldLengthRange': {
'maximum': 123.0,
'minimum': 123.0
}
}
},
'description': 'string',
'sourceProperties': {
'isRetrievable': True|False,
'isQueryable': True|False,
'isTimestampFieldForIncrementalQueries': True|False
},
'destinationProperties': {
'isCreatable': True|False,
'isNullable': True|False,
'isUpsertable': True|False,
'isUpdatable': True|False,
'isDefaultedOnCreate': True|False,
'supportedWriteOperations': [
'INSERT'|'UPSERT'|'UPDATE'|'DELETE',
]
},
'customProperties': {
'string': 'string'
}
},
]
}
Response Structure
(dict) --
connectorEntityFields (list) --
Describes the fields for that connector entity. For example, for an account entity, the fields would be account name , account ID , and so on.
(dict) --
Describes the data model of a connector field. For example, for an account entity, the fields would be account name , account ID , and so on.
identifier (string) --
The unique identifier of the connector field.
parentIdentifier (string) --
The parent identifier of the connector field.
label (string) --
The label applied to a connector entity field.
isPrimaryKey (boolean) --
Booelan value that indicates whether this field can be used as a primary key.
defaultValue (string) --
Default value that can be assigned to this field.
isDeprecated (boolean) --
Booelan value that indicates whether this field is deprecated or not.
supportedFieldTypeDetails (dict) --
Contains details regarding the supported FieldType
, including the corresponding filterOperators
and supportedValues
.
v1 (dict) --
The initial supported version for fieldType
. If this is later changed to a different version, v2 will be introduced.
fieldType (string) --
The type of field, such as string, integer, date, and so on.
filterOperators (list) --
The list of operators supported by a field.
supportedValues (list) --
The list of values that a field can contain. For example, a Boolean fieldType
can have two values: "true" and "false".
valueRegexPattern (string) --
The regular expression pattern for the field name.
supportedDateFormat (string) --
The date format that the field supports.
fieldValueRange (dict) --
The range of values this field can hold.
maximum (float) --
Maximum value supported by the field.
minimum (float) --
Minimum value supported by the field.
fieldLengthRange (dict) --
This is the allowable length range for this field's value.
maximum (float) --
Maximum value supported by the field.
minimum (float) --
Minimum value supported by the field.
description (string) --
A description of the connector entity field.
sourceProperties (dict) --
The properties that can be applied to a field when the connector is being used as a source.
isRetrievable (boolean) --
Indicates whether the field can be returned in a search result.
isQueryable (boolean) --
Indicates if the field can be queried.
isTimestampFieldForIncrementalQueries (boolean) --
Indicates if this timestamp field can be used for incremental queries.
destinationProperties (dict) --
The properties applied to a field when the connector is being used as a destination.
isCreatable (boolean) --
Specifies if the destination field can be created by the current user.
isNullable (boolean) --
Specifies if the destination field can have a null value.
isUpsertable (boolean) --
Specifies if the flow run can either insert new rows in the destination field if they do not already exist, or update them if they do.
isUpdatable (boolean) --
Specifies whether the field can be updated during an UPDATE
or UPSERT
write operation.
isDefaultedOnCreate (boolean) --
Specifies whether the field can use the default value during a Create operation.
supportedWriteOperations (list) --
A list of supported write operations. For each write operation listed, this field can be used in idFieldNames
when that write operation is present as a destination option.
(string) --
The possible write operations in the destination connector. When this value is not provided, this defaults to the INSERT
operation.
customProperties (dict) --
A map that has specific properties related to the ConnectorEntityField.
Exceptions
Appflow.Client.exceptions.ValidationException
Appflow.Client.exceptions.ResourceNotFoundException
Appflow.Client.exceptions.ConnectorAuthenticationException
Appflow.Client.exceptions.ConnectorServerException
Appflow.Client.exceptions.InternalServerException
describe_connector_profiles
(**kwargs)¶Returns a list of connector-profile
details matching the provided connector-profile
names and connector-types
. Both input lists are optional, and you can use them to filter the result.
If no names or connector-types
are provided, returns all connector profiles in a paginated form. If there is no match, this operation returns an empty list.
See also: AWS API Documentation
Request Syntax
response = client.describe_connector_profiles(
connectorProfileNames=[
'string',
],
connectorType='Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
connectorLabel='string',
maxResults=123,
nextToken='string'
)
The name of the connector profile. The name is unique for each ConnectorProfile
in the Amazon Web Services account.
ConnectorRegistration
in your Amazon Web Services account. Only needed if calling for CUSTOMCONNECTOR connector type/.maxResults
is 20 (for all paginated API operations).dict
Response Syntax
{
'connectorProfileDetails': [
{
'connectorProfileArn': 'string',
'connectorProfileName': 'string',
'connectorType': 'Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
'connectorLabel': 'string',
'connectionMode': 'Public'|'Private',
'credentialsArn': 'string',
'connectorProfileProperties': {
'Amplitude': {},
'Datadog': {
'instanceUrl': 'string'
},
'Dynatrace': {
'instanceUrl': 'string'
},
'GoogleAnalytics': {},
'Honeycode': {},
'InforNexus': {
'instanceUrl': 'string'
},
'Marketo': {
'instanceUrl': 'string'
},
'Redshift': {
'databaseUrl': 'string',
'bucketName': 'string',
'bucketPrefix': 'string',
'roleArn': 'string',
'dataApiRoleArn': 'string',
'isRedshiftServerless': True|False,
'clusterIdentifier': 'string',
'workgroupName': 'string',
'databaseName': 'string'
},
'Salesforce': {
'instanceUrl': 'string',
'isSandboxEnvironment': True|False
},
'ServiceNow': {
'instanceUrl': 'string'
},
'Singular': {},
'Slack': {
'instanceUrl': 'string'
},
'Snowflake': {
'warehouse': 'string',
'stage': 'string',
'bucketName': 'string',
'bucketPrefix': 'string',
'privateLinkServiceName': 'string',
'accountName': 'string',
'region': 'string'
},
'Trendmicro': {},
'Veeva': {
'instanceUrl': 'string'
},
'Zendesk': {
'instanceUrl': 'string'
},
'SAPOData': {
'applicationHostUrl': 'string',
'applicationServicePath': 'string',
'portNumber': 123,
'clientNumber': 'string',
'logonLanguage': 'string',
'privateLinkServiceName': 'string',
'oAuthProperties': {
'tokenUrl': 'string',
'authCodeUrl': 'string',
'oAuthScopes': [
'string',
]
}
},
'CustomConnector': {
'profileProperties': {
'string': 'string'
},
'oAuth2Properties': {
'tokenUrl': 'string',
'oAuth2GrantType': 'CLIENT_CREDENTIALS'|'AUTHORIZATION_CODE',
'tokenUrlCustomProperties': {
'string': 'string'
}
}
}
},
'createdAt': datetime(2015, 1, 1),
'lastUpdatedAt': datetime(2015, 1, 1),
'privateConnectionProvisioningState': {
'status': 'FAILED'|'PENDING'|'CREATED',
'failureMessage': 'string',
'failureCause': 'CONNECTOR_AUTHENTICATION'|'CONNECTOR_SERVER'|'INTERNAL_SERVER'|'ACCESS_DENIED'|'VALIDATION'
}
},
],
'nextToken': 'string'
}
Response Structure
(dict) --
connectorProfileDetails (list) --
Returns information about the connector profiles associated with the flow.
(dict) --
Describes an instance of a connector. This includes the provided name, credentials ARN, connection-mode, and so on. To keep the API intuitive and extensible, the fields that are common to all types of connector profiles are explicitly specified at the top level. The rest of the connector-specific properties are available via the connectorProfileProperties
field.
connectorProfileArn (string) --
The Amazon Resource Name (ARN) of the connector profile.
connectorProfileName (string) --
The name of the connector profile. The name is unique for each ConnectorProfile
in the Amazon Web Services account.
connectorType (string) --
The type of connector, such as Salesforce, Amplitude, and so on.
connectorLabel (string) --
The label for the connector profile being created.
connectionMode (string) --
Indicates the connection mode and if it is public or private.
credentialsArn (string) --
The Amazon Resource Name (ARN) of the connector profile credentials.
connectorProfileProperties (dict) --
The connector-specific properties of the profile configuration.
Amplitude (dict) --
The connector-specific properties required by Amplitude.
Datadog (dict) --
The connector-specific properties required by Datadog.
instanceUrl (string) --
The location of the Datadog resource.
Dynatrace (dict) --
The connector-specific properties required by Dynatrace.
instanceUrl (string) --
The location of the Dynatrace resource.
GoogleAnalytics (dict) --
The connector-specific properties required Google Analytics.
Honeycode (dict) --
The connector-specific properties required by Amazon Honeycode.
InforNexus (dict) --
The connector-specific properties required by Infor Nexus.
instanceUrl (string) --
The location of the Infor Nexus resource.
Marketo (dict) --
The connector-specific properties required by Marketo.
instanceUrl (string) --
The location of the Marketo resource.
Redshift (dict) --
The connector-specific properties required by Amazon Redshift.
databaseUrl (string) --
The JDBC URL of the Amazon Redshift cluster.
bucketName (string) --
A name for the associated Amazon S3 bucket.
bucketPrefix (string) --
The object key for the destination bucket in which Amazon AppFlow places the files.
roleArn (string) --
The Amazon Resource Name (ARN) of IAM role that grants Amazon Redshift read-only access to Amazon S3. For more information, and for the polices that you attach to this role, see Allow Amazon Redshift to access your Amazon AppFlow data in Amazon S3.
dataApiRoleArn (string) --
The Amazon Resource Name (ARN) of an IAM role that permits Amazon AppFlow to access your Amazon Redshift database through the Data API. For more information, and for the polices that you attach to this role, see Allow Amazon AppFlow to access Amazon Redshift databases with the Data API.
isRedshiftServerless (boolean) --
Indicates whether the connector profile defines a connection to an Amazon Redshift Serverless data warehouse.
clusterIdentifier (string) --
The unique ID that's assigned to an Amazon Redshift cluster.
workgroupName (string) --
The name of an Amazon Redshift workgroup.
databaseName (string) --
The name of an Amazon Redshift database.
Salesforce (dict) --
The connector-specific properties required by Salesforce.
instanceUrl (string) --
The location of the Salesforce resource.
isSandboxEnvironment (boolean) --
Indicates whether the connector profile applies to a sandbox or production environment.
ServiceNow (dict) --
The connector-specific properties required by serviceNow.
instanceUrl (string) --
The location of the ServiceNow resource.
Singular (dict) --
The connector-specific properties required by Singular.
Slack (dict) --
The connector-specific properties required by Slack.
instanceUrl (string) --
The location of the Slack resource.
Snowflake (dict) --
The connector-specific properties required by Snowflake.
warehouse (string) --
The name of the Snowflake warehouse.
stage (string) --
The name of the Amazon S3 stage that was created while setting up an Amazon S3 stage in the Snowflake account. This is written in the following format: < Database>< Schema><Stage Name>.
bucketName (string) --
The name of the Amazon S3 bucket associated with Snowflake.
bucketPrefix (string) --
The bucket path that refers to the Amazon S3 bucket associated with Snowflake.
privateLinkServiceName (string) --
The Snowflake Private Link service name to be used for private data transfers.
accountName (string) --
The name of the account.
region (string) --
The Amazon Web Services Region of the Snowflake account.
Trendmicro (dict) --
The connector-specific properties required by Trend Micro.
Veeva (dict) --
The connector-specific properties required by Veeva.
instanceUrl (string) --
The location of the Veeva resource.
Zendesk (dict) --
The connector-specific properties required by Zendesk.
instanceUrl (string) --
The location of the Zendesk resource.
SAPOData (dict) --
The connector-specific profile properties required when using SAPOData.
applicationHostUrl (string) --
The location of the SAPOData resource.
applicationServicePath (string) --
The application path to catalog service.
portNumber (integer) --
The port number of the SAPOData instance.
clientNumber (string) --
The client number for the client creating the connection.
logonLanguage (string) --
The logon language of SAPOData instance.
privateLinkServiceName (string) --
The SAPOData Private Link service name to be used for private data transfers.
oAuthProperties (dict) --
The SAPOData OAuth properties required for OAuth type authentication.
tokenUrl (string) --
The token url required to fetch access/refresh tokens using authorization code and also to refresh expired access token using refresh token.
authCodeUrl (string) --
The authorization code url required to redirect to SAP Login Page to fetch authorization code for OAuth type authentication.
oAuthScopes (list) --
The OAuth scopes required for OAuth type authentication.
CustomConnector (dict) --
The properties required by the custom connector.
profileProperties (dict) --
A map of properties that are required to create a profile for the custom connector.
oAuth2Properties (dict) --
The OAuth 2.0 properties required for OAuth 2.0 authentication.
tokenUrl (string) --
The token URL required for OAuth 2.0 authentication.
oAuth2GrantType (string) --
The OAuth 2.0 grant type used by connector for OAuth 2.0 authentication.
tokenUrlCustomProperties (dict) --
Associates your token URL with a map of properties that you define. Use this parameter to provide any additional details that the connector requires to authenticate your request.
createdAt (datetime) --
Specifies when the connector profile was created.
lastUpdatedAt (datetime) --
Specifies when the connector profile was last updated.
privateConnectionProvisioningState (dict) --
Specifies the private connection provisioning state.
status (string) --
Specifies the private connection provisioning status.
failureMessage (string) --
Specifies the private connection provisioning failure reason.
failureCause (string) --
Specifies the private connection provisioning failure cause.
nextToken (string) --
The pagination token for the next page of data. If nextToken=null
, this means that all records have been fetched.
Exceptions
Appflow.Client.exceptions.ValidationException
Appflow.Client.exceptions.InternalServerException
describe_connectors
(**kwargs)¶Describes the connectors vended by Amazon AppFlow for specified connector types. If you don't specify a connector type, this operation describes all connectors vended by Amazon AppFlow. If there are more connectors than can be returned in one page, the response contains a nextToken
object, which can be be passed in to the next call to the DescribeConnectors
API operation to retrieve the next page.
See also: AWS API Documentation
Request Syntax
response = client.describe_connectors(
connectorTypes=[
'Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
],
maxResults=123,
nextToken='string'
)
The type of connector, such as Salesforce, Amplitude, and so on.
dict
Response Syntax
{
'connectorConfigurations': {
'string': {
'canUseAsSource': True|False,
'canUseAsDestination': True|False,
'supportedDestinationConnectors': [
'Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
],
'supportedSchedulingFrequencies': [
'BYMINUTE'|'HOURLY'|'DAILY'|'WEEKLY'|'MONTHLY'|'ONCE',
],
'isPrivateLinkEnabled': True|False,
'isPrivateLinkEndpointUrlRequired': True|False,
'supportedTriggerTypes': [
'Scheduled'|'Event'|'OnDemand',
],
'connectorMetadata': {
'Amplitude': {},
'Datadog': {},
'Dynatrace': {},
'GoogleAnalytics': {
'oAuthScopes': [
'string',
]
},
'InforNexus': {},
'Marketo': {},
'Redshift': {},
'S3': {},
'Salesforce': {
'oAuthScopes': [
'string',
],
'dataTransferApis': [
'AUTOMATIC'|'BULKV2'|'REST_SYNC',
]
},
'ServiceNow': {},
'Singular': {},
'Slack': {
'oAuthScopes': [
'string',
]
},
'Snowflake': {
'supportedRegions': [
'string',
]
},
'Trendmicro': {},
'Veeva': {},
'Zendesk': {
'oAuthScopes': [
'string',
]
},
'EventBridge': {},
'Upsolver': {},
'CustomerProfiles': {},
'Honeycode': {
'oAuthScopes': [
'string',
]
},
'SAPOData': {}
},
'connectorType': 'Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
'connectorLabel': 'string',
'connectorDescription': 'string',
'connectorOwner': 'string',
'connectorName': 'string',
'connectorVersion': 'string',
'connectorArn': 'string',
'connectorModes': [
'string',
],
'authenticationConfig': {
'isBasicAuthSupported': True|False,
'isApiKeyAuthSupported': True|False,
'isOAuth2Supported': True|False,
'isCustomAuthSupported': True|False,
'oAuth2Defaults': {
'oauthScopes': [
'string',
],
'tokenUrls': [
'string',
],
'authCodeUrls': [
'string',
],
'oauth2GrantTypesSupported': [
'CLIENT_CREDENTIALS'|'AUTHORIZATION_CODE',
],
'oauth2CustomProperties': [
{
'key': 'string',
'isRequired': True|False,
'label': 'string',
'description': 'string',
'isSensitiveField': True|False,
'connectorSuppliedValues': [
'string',
],
'type': 'TOKEN_URL'|'AUTH_URL'
},
]
},
'customAuthConfigs': [
{
'customAuthenticationType': 'string',
'authParameters': [
{
'key': 'string',
'isRequired': True|False,
'label': 'string',
'description': 'string',
'isSensitiveField': True|False,
'connectorSuppliedValues': [
'string',
]
},
]
},
]
},
'connectorRuntimeSettings': [
{
'key': 'string',
'dataType': 'string',
'isRequired': True|False,
'label': 'string',
'description': 'string',
'scope': 'string',
'connectorSuppliedValueOptions': [
'string',
]
},
],
'supportedApiVersions': [
'string',
],
'supportedOperators': [
'PROJECTION'|'LESS_THAN'|'GREATER_THAN'|'CONTAINS'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
],
'supportedWriteOperations': [
'INSERT'|'UPSERT'|'UPDATE'|'DELETE',
],
'connectorProvisioningType': 'LAMBDA',
'connectorProvisioningConfig': {
'lambda': {
'lambdaArn': 'string'
}
},
'logoURL': 'string',
'registeredAt': datetime(2015, 1, 1),
'registeredBy': 'string'
}
},
'connectors': [
{
'connectorDescription': 'string',
'connectorName': 'string',
'connectorOwner': 'string',
'connectorVersion': 'string',
'applicationType': 'string',
'connectorType': 'Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
'connectorLabel': 'string',
'registeredAt': datetime(2015, 1, 1),
'registeredBy': 'string',
'connectorProvisioningType': 'LAMBDA',
'connectorModes': [
'string',
]
},
],
'nextToken': 'string'
}
Response Structure
(dict) --
connectorConfigurations (dict) --
The configuration that is applied to the connectors used in the flow.
(string) --
(dict) --
The configuration settings related to a given connector.
canUseAsSource (boolean) --
Specifies whether the connector can be used as a source.
canUseAsDestination (boolean) --
Specifies whether the connector can be used as a destination.
supportedDestinationConnectors (list) --
Lists the connectors that are available for use as destinations.
supportedSchedulingFrequencies (list) --
Specifies the supported flow frequency for that connector.
isPrivateLinkEnabled (boolean) --
Specifies if PrivateLink is enabled for that connector.
isPrivateLinkEndpointUrlRequired (boolean) --
Specifies if a PrivateLink endpoint URL is required.
supportedTriggerTypes (list) --
Specifies the supported trigger types for the flow.
connectorMetadata (dict) --
Specifies connector-specific metadata such as oAuthScopes
, supportedRegions
, privateLinkServiceUrl
, and so on.
Amplitude (dict) --
The connector metadata specific to Amplitude.
Datadog (dict) --
The connector metadata specific to Datadog.
Dynatrace (dict) --
The connector metadata specific to Dynatrace.
GoogleAnalytics (dict) --
The connector metadata specific to Google Analytics.
oAuthScopes (list) --
The desired authorization scope for the Google Analytics account.
InforNexus (dict) --
The connector metadata specific to Infor Nexus.
Marketo (dict) --
The connector metadata specific to Marketo.
Redshift (dict) --
The connector metadata specific to Amazon Redshift.
S3 (dict) --
The connector metadata specific to Amazon S3.
Salesforce (dict) --
The connector metadata specific to Salesforce.
oAuthScopes (list) --
The desired authorization scope for the Salesforce account.
dataTransferApis (list) --
The Salesforce APIs that you can have Amazon AppFlow use when your flows transfers data to or from Salesforce.
ServiceNow (dict) --
The connector metadata specific to ServiceNow.
Singular (dict) --
The connector metadata specific to Singular.
Slack (dict) --
The connector metadata specific to Slack.
oAuthScopes (list) --
The desired authorization scope for the Slack account.
Snowflake (dict) --
The connector metadata specific to Snowflake.
supportedRegions (list) --
Specifies the supported Amazon Web Services Regions when using Snowflake.
Trendmicro (dict) --
The connector metadata specific to Trend Micro.
Veeva (dict) --
The connector metadata specific to Veeva.
Zendesk (dict) --
The connector metadata specific to Zendesk.
oAuthScopes (list) --
The desired authorization scope for the Zendesk account.
EventBridge (dict) --
The connector metadata specific to Amazon EventBridge.
Upsolver (dict) --
The connector metadata specific to Upsolver.
CustomerProfiles (dict) --
The connector metadata specific to Amazon Connect Customer Profiles.
Honeycode (dict) --
The connector metadata specific to Amazon Honeycode.
oAuthScopes (list) --
The desired authorization scope for the Amazon Honeycode account.
SAPOData (dict) --
The connector metadata specific to SAPOData.
connectorType (string) --
The connector type.
connectorLabel (string) --
The label used for registering the connector.
connectorDescription (string) --
A description about the connector.
connectorOwner (string) --
The owner who developed the connector.
connectorName (string) --
The connector name.
connectorVersion (string) --
The connector version.
connectorArn (string) --
The Amazon Resource Name (ARN) for the registered connector.
connectorModes (list) --
The connection modes that the connector supports.
authenticationConfig (dict) --
The authentication config required for the connector.
isBasicAuthSupported (boolean) --
Indicates whether basic authentication is supported by the connector.
isApiKeyAuthSupported (boolean) --
Indicates whether API key authentication is supported by the connector
isOAuth2Supported (boolean) --
Indicates whether OAuth 2.0 authentication is supported by the connector.
isCustomAuthSupported (boolean) --
Indicates whether custom authentication is supported by the connector
oAuth2Defaults (dict) --
Contains the default values required for OAuth 2.0 authentication.
oauthScopes (list) --
OAuth 2.0 scopes that the connector supports.
tokenUrls (list) --
Token URLs that can be used for OAuth 2.0 authentication.
authCodeUrls (list) --
Auth code URLs that can be used for OAuth 2.0 authentication.
oauth2GrantTypesSupported (list) --
OAuth 2.0 grant types supported by the connector.
oauth2CustomProperties (list) --
List of custom parameters required for OAuth 2.0 authentication.
(dict) --
Custom parameter required for OAuth 2.0 authentication.
key (string) --
The key of the custom parameter required for OAuth 2.0 authentication.
isRequired (boolean) --
Indicates whether the custom parameter for OAuth 2.0 authentication is required.
label (string) --
The label of the custom parameter used for OAuth 2.0 authentication.
description (string) --
A description about the custom parameter used for OAuth 2.0 authentication.
isSensitiveField (boolean) --
Indicates whether this authentication custom parameter is a sensitive field.
connectorSuppliedValues (list) --
Contains default values for this authentication parameter that are supplied by the connector.
type (string) --
Indicates whether custom parameter is used with TokenUrl or AuthUrl.
customAuthConfigs (list) --
Contains information required for custom authentication.
(dict) --
Configuration information required for custom authentication.
customAuthenticationType (string) --
The authentication type that the custom connector uses.
authParameters (list) --
Information about authentication parameters required for authentication.
(dict) --
Information about required authentication parameters.
key (string) --
The authentication key required to authenticate with the connector.
isRequired (boolean) --
Indicates whether this authentication parameter is required.
label (string) --
Label used for authentication parameter.
description (string) --
A description about the authentication parameter.
isSensitiveField (boolean) --
Indicates whether this authentication parameter is a sensitive field.
connectorSuppliedValues (list) --
Contains default values for this authentication parameter that are supplied by the connector.
connectorRuntimeSettings (list) --
The required connector runtime settings.
(dict) --
Contains information about the connector runtime settings that are required for flow execution.
key (string) --
Contains value information about the connector runtime setting.
dataType (string) --
Data type of the connector runtime setting.
isRequired (boolean) --
Indicates whether this connector runtime setting is required.
label (string) --
A label used for connector runtime setting.
description (string) --
A description about the connector runtime setting.
scope (string) --
Indicates the scope of the connector runtime setting.
connectorSuppliedValueOptions (list) --
Contains default values for the connector runtime setting that are supplied by the connector.
supportedApiVersions (list) --
A list of API versions that are supported by the connector.
supportedOperators (list) --
A list of operators supported by the connector.
supportedWriteOperations (list) --
A list of write operations supported by the connector.
(string) --
The possible write operations in the destination connector. When this value is not provided, this defaults to the INSERT
operation.
connectorProvisioningType (string) --
The provisioning type used to register the connector.
connectorProvisioningConfig (dict) --
The configuration required for registering the connector.
lambda (dict) --
Contains information about the configuration of the lambda which is being registered as the connector.
lambdaArn (string) --
Lambda ARN of the connector being registered.
logoURL (string) --
Logo URL of the connector.
registeredAt (datetime) --
The date on which the connector was registered.
registeredBy (string) --
Information about who registered the connector.
connectors (list) --
Information about the connectors supported in Amazon AppFlow.
(dict) --
Information about the registered connector.
connectorDescription (string) --
A description about the registered connector.
connectorName (string) --
The name of the connector.
connectorOwner (string) --
The owner of the connector.
connectorVersion (string) --
The connector version.
applicationType (string) --
The application type of the connector.
connectorType (string) --
The connector type.
connectorLabel (string) --
A label used for the connector.
registeredAt (datetime) --
The time at which the connector was registered.
registeredBy (string) --
The user who registered the connector.
connectorProvisioningType (string) --
The provisioning type that the connector uses.
connectorModes (list) --
The connection mode that the connector supports.
nextToken (string) --
The pagination token for the next page of data.
Exceptions
Appflow.Client.exceptions.ValidationException
Appflow.Client.exceptions.InternalServerException
describe_flow
(**kwargs)¶Provides a description of the specified flow.
See also: AWS API Documentation
Request Syntax
response = client.describe_flow(
flowName='string'
)
[REQUIRED]
The specified name of the flow. Spaces are not allowed. Use underscores (_) or hyphens (-) only.
{
'flowArn': 'string',
'description': 'string',
'flowName': 'string',
'kmsArn': 'string',
'flowStatus': 'Active'|'Deprecated'|'Deleted'|'Draft'|'Errored'|'Suspended',
'flowStatusMessage': 'string',
'sourceFlowConfig': {
'connectorType': 'Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
'apiVersion': 'string',
'connectorProfileName': 'string',
'sourceConnectorProperties': {
'Amplitude': {
'object': 'string'
},
'Datadog': {
'object': 'string'
},
'Dynatrace': {
'object': 'string'
},
'GoogleAnalytics': {
'object': 'string'
},
'InforNexus': {
'object': 'string'
},
'Marketo': {
'object': 'string'
},
'S3': {
'bucketName': 'string',
'bucketPrefix': 'string',
's3InputFormatConfig': {
's3InputFileType': 'CSV'|'JSON'
}
},
'Salesforce': {
'object': 'string',
'enableDynamicFieldUpdate': True|False,
'includeDeletedRecords': True|False,
'dataTransferApi': 'AUTOMATIC'|'BULKV2'|'REST_SYNC'
},
'ServiceNow': {
'object': 'string'
},
'Singular': {
'object': 'string'
},
'Slack': {
'object': 'string'
},
'Trendmicro': {
'object': 'string'
},
'Veeva': {
'object': 'string',
'documentType': 'string',
'includeSourceFiles': True|False,
'includeRenditions': True|False,
'includeAllVersions': True|False
},
'Zendesk': {
'object': 'string'
},
'SAPOData': {
'objectPath': 'string'
},
'CustomConnector': {
'entityName': 'string',
'customProperties': {
'string': 'string'
}
}
},
'incrementalPullConfig': {
'datetimeTypeFieldName': 'string'
}
},
'destinationFlowConfigList': [
{
'connectorType': 'Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
'apiVersion': 'string',
'connectorProfileName': 'string',
'destinationConnectorProperties': {
'Redshift': {
'object': 'string',
'intermediateBucketName': 'string',
'bucketPrefix': 'string',
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
}
},
'S3': {
'bucketName': 'string',
'bucketPrefix': 'string',
's3OutputFormatConfig': {
'fileType': 'CSV'|'JSON'|'PARQUET',
'prefixConfig': {
'prefixType': 'FILENAME'|'PATH'|'PATH_AND_FILENAME',
'prefixFormat': 'YEAR'|'MONTH'|'DAY'|'HOUR'|'MINUTE',
'pathPrefixHierarchy': [
'EXECUTION_ID'|'SCHEMA_VERSION',
]
},
'aggregationConfig': {
'aggregationType': 'None'|'SingleFile',
'targetFileSize': 123
},
'preserveSourceDataTyping': True|False
}
},
'Salesforce': {
'object': 'string',
'idFieldNames': [
'string',
],
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
},
'writeOperationType': 'INSERT'|'UPSERT'|'UPDATE'|'DELETE',
'dataTransferApi': 'AUTOMATIC'|'BULKV2'|'REST_SYNC'
},
'Snowflake': {
'object': 'string',
'intermediateBucketName': 'string',
'bucketPrefix': 'string',
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
}
},
'EventBridge': {
'object': 'string',
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
}
},
'LookoutMetrics': {},
'Upsolver': {
'bucketName': 'string',
'bucketPrefix': 'string',
's3OutputFormatConfig': {
'fileType': 'CSV'|'JSON'|'PARQUET',
'prefixConfig': {
'prefixType': 'FILENAME'|'PATH'|'PATH_AND_FILENAME',
'prefixFormat': 'YEAR'|'MONTH'|'DAY'|'HOUR'|'MINUTE',
'pathPrefixHierarchy': [
'EXECUTION_ID'|'SCHEMA_VERSION',
]
},
'aggregationConfig': {
'aggregationType': 'None'|'SingleFile',
'targetFileSize': 123
}
}
},
'Honeycode': {
'object': 'string',
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
}
},
'CustomerProfiles': {
'domainName': 'string',
'objectTypeName': 'string'
},
'Zendesk': {
'object': 'string',
'idFieldNames': [
'string',
],
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
},
'writeOperationType': 'INSERT'|'UPSERT'|'UPDATE'|'DELETE'
},
'Marketo': {
'object': 'string',
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
}
},
'CustomConnector': {
'entityName': 'string',
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
},
'writeOperationType': 'INSERT'|'UPSERT'|'UPDATE'|'DELETE',
'idFieldNames': [
'string',
],
'customProperties': {
'string': 'string'
}
},
'SAPOData': {
'objectPath': 'string',
'successResponseHandlingConfig': {
'bucketPrefix': 'string',
'bucketName': 'string'
},
'idFieldNames': [
'string',
],
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
},
'writeOperationType': 'INSERT'|'UPSERT'|'UPDATE'|'DELETE'
}
}
},
],
'lastRunExecutionDetails': {
'mostRecentExecutionMessage': 'string',
'mostRecentExecutionTime': datetime(2015, 1, 1),
'mostRecentExecutionStatus': 'InProgress'|'Successful'|'Error'
},
'triggerConfig': {
'triggerType': 'Scheduled'|'Event'|'OnDemand',
'triggerProperties': {
'Scheduled': {
'scheduleExpression': 'string',
'dataPullMode': 'Incremental'|'Complete',
'scheduleStartTime': datetime(2015, 1, 1),
'scheduleEndTime': datetime(2015, 1, 1),
'timezone': 'string',
'scheduleOffset': 123,
'firstExecutionFrom': datetime(2015, 1, 1),
'flowErrorDeactivationThreshold': 123
}
}
},
'tasks': [
{
'sourceFields': [
'string',
],
'connectorOperator': {
'Amplitude': 'BETWEEN',
'Datadog': 'PROJECTION'|'BETWEEN'|'EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Dynatrace': 'PROJECTION'|'BETWEEN'|'EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'GoogleAnalytics': 'PROJECTION'|'BETWEEN',
'InforNexus': 'PROJECTION'|'BETWEEN'|'EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Marketo': 'PROJECTION'|'LESS_THAN'|'GREATER_THAN'|'BETWEEN'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'S3': 'PROJECTION'|'LESS_THAN'|'GREATER_THAN'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Salesforce': 'PROJECTION'|'LESS_THAN'|'CONTAINS'|'GREATER_THAN'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'ServiceNow': 'PROJECTION'|'CONTAINS'|'LESS_THAN'|'GREATER_THAN'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Singular': 'PROJECTION'|'EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Slack': 'PROJECTION'|'LESS_THAN'|'GREATER_THAN'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Trendmicro': 'PROJECTION'|'EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Veeva': 'PROJECTION'|'LESS_THAN'|'GREATER_THAN'|'CONTAINS'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Zendesk': 'PROJECTION'|'GREATER_THAN'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'SAPOData': 'PROJECTION'|'LESS_THAN'|'CONTAINS'|'GREATER_THAN'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'CustomConnector': 'PROJECTION'|'LESS_THAN'|'GREATER_THAN'|'CONTAINS'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP'
},
'destinationField': 'string',
'taskType': 'Arithmetic'|'Filter'|'Map'|'Map_all'|'Mask'|'Merge'|'Passthrough'|'Truncate'|'Validate'|'Partition',
'taskProperties': {
'string': 'string'
}
},
],
'createdAt': datetime(2015, 1, 1),
'lastUpdatedAt': datetime(2015, 1, 1),
'createdBy': 'string',
'lastUpdatedBy': 'string',
'tags': {
'string': 'string'
},
'metadataCatalogConfig': {
'glueDataCatalog': {
'roleArn': 'string',
'databaseName': 'string',
'tablePrefix': 'string'
}
},
'lastRunMetadataCatalogDetails': [
{
'catalogType': 'GLUE',
'tableName': 'string',
'tableRegistrationOutput': {
'message': 'string',
'result': 'string',
'status': 'InProgress'|'Successful'|'Error'
},
'partitionRegistrationOutput': {
'message': 'string',
'result': 'string',
'status': 'InProgress'|'Successful'|'Error'
}
},
],
'schemaVersion': 123
}
Response Structure
The flow's Amazon Resource Name (ARN).
A description of the flow.
The specified name of the flow. Spaces are not allowed. Use underscores (_) or hyphens (-) only.
The ARN (Amazon Resource Name) of the Key Management Service (KMS) key you provide for encryption. This is required if you do not want to use the Amazon AppFlow-managed KMS key. If you don't provide anything here, Amazon AppFlow uses the Amazon AppFlow-managed KMS key.
Indicates the current status of the flow.
Contains an error message if the flow status is in a suspended or error state. This applies only to scheduled or event-triggered flows.
The configuration that controls how Amazon AppFlow retrieves data from the source connector.
The type of connector, such as Salesforce, Amplitude, and so on.
The API version of the connector when it's used as a source in the flow.
The name of the connector profile. This name must be unique for each connector profile in the Amazon Web Services account.
Specifies the information that is required to query a particular source connector.
Specifies the information that is required for querying Amplitude.
The object specified in the Amplitude flow source.
Specifies the information that is required for querying Datadog.
The object specified in the Datadog flow source.
Specifies the information that is required for querying Dynatrace.
The object specified in the Dynatrace flow source.
Specifies the information that is required for querying Google Analytics.
The object specified in the Google Analytics flow source.
Specifies the information that is required for querying Infor Nexus.
The object specified in the Infor Nexus flow source.
Specifies the information that is required for querying Marketo.
The object specified in the Marketo flow source.
Specifies the information that is required for querying Amazon S3.
The Amazon S3 bucket name where the source files are stored.
The object key for the Amazon S3 bucket in which the source files are stored.
When you use Amazon S3 as the source, the configuration format that you provide the flow input data.
The file type that Amazon AppFlow gets from your Amazon S3 bucket.
Specifies the information that is required for querying Salesforce.
The object specified in the Salesforce flow source.
The flag that enables dynamic fetching of new (recently added) fields in the Salesforce objects while running a flow.
Indicates whether Amazon AppFlow includes deleted files in the flow run.
Specifies which Salesforce API is used by Amazon AppFlow when your flow transfers data from Salesforce.
AUTOMATIC
The default. Amazon AppFlow selects which API to use based on the number of records that your flow transfers from Salesforce. If your flow transfers fewer than 1,000,000 records, Amazon AppFlow uses Salesforce REST API. If your flow transfers 1,000,000 records or more, Amazon AppFlow uses Salesforce Bulk API 2.0.
Each of these Salesforce APIs structures data differently. If Amazon AppFlow selects the API automatically, be aware that, for recurring flows, the data output might vary from one flow run to the next. For example, if a flow runs daily, it might use REST API on one day to transfer 900,000 records, and it might use Bulk API 2.0 on the next day to transfer 1,100,000 records. For each of these flow runs, the respective Salesforce API formats the data differently. Some of the differences include how dates are formatted and null values are represented. Also, Bulk API 2.0 doesn't transfer Salesforce compound fields.
By choosing this option, you optimize flow performance for both small and large data transfers, but the tradeoff is inconsistent formatting in the output.
BULKV2
Amazon AppFlow uses only Salesforce Bulk API 2.0. This API runs asynchronous data transfers, and it's optimal for large sets of data. By choosing this option, you ensure that your flow writes consistent output, but you optimize performance only for large data transfers.
Note that Bulk API 2.0 does not transfer Salesforce compound fields.
REST_SYNC
Amazon AppFlow uses only Salesforce REST API. By choosing this option, you ensure that your flow writes consistent output, but you decrease performance for large data transfers that are better suited for Bulk API 2.0. In some cases, if your flow attempts to transfer a vary large set of data, it might fail wituh a timed out error.
Specifies the information that is required for querying ServiceNow.
The object specified in the ServiceNow flow source.
Specifies the information that is required for querying Singular.
The object specified in the Singular flow source.
Specifies the information that is required for querying Slack.
The object specified in the Slack flow source.
Specifies the information that is required for querying Trend Micro.
The object specified in the Trend Micro flow source.
Specifies the information that is required for querying Veeva.
The object specified in the Veeva flow source.
The document type specified in the Veeva document extract flow.
Boolean value to include source files in Veeva document extract flow.
Boolean value to include file renditions in Veeva document extract flow.
Boolean value to include All Versions of files in Veeva document extract flow.
Specifies the information that is required for querying Zendesk.
The object specified in the Zendesk flow source.
The properties that are applied when using SAPOData as a flow source.
The object path specified in the SAPOData flow source.
The properties that are applied when the custom connector is being used as a source.
The entity specified in the custom connector as a source in the flow.
Custom properties that are required to use the custom connector as a source.
Defines the configuration for a scheduled incremental data pull. If a valid configuration is provided, the fields specified in the configuration are used when querying for the incremental data pull.
A field that specifies the date time or timestamp field as the criteria to use when importing incremental records from the source.
The configuration that controls how Amazon AppFlow transfers data to the destination connector.
Contains information about the configuration of destination connectors present in the flow.
The type of connector, such as Salesforce, Amplitude, and so on.
The API version that the destination connector uses.
The name of the connector profile. This name must be unique for each connector profile in the Amazon Web Services account.
This stores the information that is required to query a particular connector.
The properties required to query Amazon Redshift.
The object specified in the Amazon Redshift flow destination.
The intermediate bucket that Amazon AppFlow uses when moving data into Amazon Redshift.
The object key for the bucket in which Amazon AppFlow places the destination files.
The settings that determine how Amazon AppFlow handles an error when placing data in the Amazon Redshift destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The properties required to query Amazon S3.
The Amazon S3 bucket name in which Amazon AppFlow places the transferred data.
The object key for the destination bucket in which Amazon AppFlow places the files.
The configuration that determines how Amazon AppFlow should format the flow output data when Amazon S3 is used as the destination.
Indicates the file type that Amazon AppFlow places in the Amazon S3 bucket.
Determines the prefix that Amazon AppFlow applies to the folder name in the Amazon S3 bucket. You can name folders according to the flow frequency and date.
Determines the format of the prefix, and whether it applies to the file name, file path, or both.
Determines the level of granularity for the date and time that's included in the prefix.
Specifies whether the destination file path includes either or both of the following elements:
EXECUTION_ID
The ID that Amazon AppFlow assigns to the flow run.
SCHEMA_VERSION
The version number of your data schema. Amazon AppFlow assigns this version number. The version number increases by one when you change any of the following settings in your flow configuration:
The aggregation settings that you can use to customize the output format of your flow data.
Specifies whether Amazon AppFlow aggregates the flow records into a single file, or leave them unaggregated.
The desired file size, in MB, for each output file that Amazon AppFlow writes to the flow destination. For each file, Amazon AppFlow attempts to achieve the size that you specify. The actual file sizes might differ from this target based on the number and size of the records that each file contains.
If your file output format is Parquet, use this parameter to set whether Amazon AppFlow preserves the data types in your source data when it writes the output to Amazon S3.
true
: Amazon AppFlow preserves the data types when it writes to Amazon S3. For example, an integer or 1
in your source data is still an integer in your output.false
: Amazon AppFlow converts all of the source data into strings when it writes to Amazon S3. For example, an integer of 1
in your source data becomes the string "1"
in the output.The properties required to query Salesforce.
The object specified in the Salesforce flow destination.
The name of the field that Amazon AppFlow uses as an ID when performing a write operation such as update or delete.
The settings that determine how Amazon AppFlow handles an error when placing data in the Salesforce destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
This specifies the type of write operation to be performed in Salesforce. When the value is UPSERT
, then idFieldNames
is required.
Specifies which Salesforce API is used by Amazon AppFlow when your flow transfers data to Salesforce.
AUTOMATIC
The default. Amazon AppFlow selects which API to use based on the number of records that your flow transfers to Salesforce. If your flow transfers fewer than 1,000 records, Amazon AppFlow uses Salesforce REST API. If your flow transfers 1,000 records or more, Amazon AppFlow uses Salesforce Bulk API 2.0.
Each of these Salesforce APIs structures data differently. If Amazon AppFlow selects the API automatically, be aware that, for recurring flows, the data output might vary from one flow run to the next. For example, if a flow runs daily, it might use REST API on one day to transfer 900 records, and it might use Bulk API 2.0 on the next day to transfer 1,100 records. For each of these flow runs, the respective Salesforce API formats the data differently. Some of the differences include how dates are formatted and null values are represented. Also, Bulk API 2.0 doesn't transfer Salesforce compound fields.
By choosing this option, you optimize flow performance for both small and large data transfers, but the tradeoff is inconsistent formatting in the output.
BULKV2
Amazon AppFlow uses only Salesforce Bulk API 2.0. This API runs asynchronous data transfers, and it's optimal for large sets of data. By choosing this option, you ensure that your flow writes consistent output, but you optimize performance only for large data transfers.
Note that Bulk API 2.0 does not transfer Salesforce compound fields.
REST_SYNC
Amazon AppFlow uses only Salesforce REST API. By choosing this option, you ensure that your flow writes consistent output, but you decrease performance for large data transfers that are better suited for Bulk API 2.0. In some cases, if your flow attempts to transfer a vary large set of data, it might fail with a timed out error.
The properties required to query Snowflake.
The object specified in the Snowflake flow destination.
The intermediate bucket that Amazon AppFlow uses when moving data into Snowflake.
The object key for the destination bucket in which Amazon AppFlow places the files.
The settings that determine how Amazon AppFlow handles an error when placing data in the Snowflake destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The properties required to query Amazon EventBridge.
The object specified in the Amazon EventBridge flow destination.
The settings that determine how Amazon AppFlow handles an error when placing data in the destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The properties required to query Amazon Lookout for Metrics.
The properties required to query Upsolver.
The Upsolver Amazon S3 bucket name in which Amazon AppFlow places the transferred data.
The object key for the destination Upsolver Amazon S3 bucket in which Amazon AppFlow places the files.
The configuration that determines how data is formatted when Upsolver is used as the flow destination.
Indicates the file type that Amazon AppFlow places in the Upsolver Amazon S3 bucket.
Specifies elements that Amazon AppFlow includes in the file and folder names in the flow destination.
Determines the format of the prefix, and whether it applies to the file name, file path, or both.
Determines the level of granularity for the date and time that's included in the prefix.
Specifies whether the destination file path includes either or both of the following elements:
EXECUTION_ID
The ID that Amazon AppFlow assigns to the flow run.
SCHEMA_VERSION
The version number of your data schema. Amazon AppFlow assigns this version number. The version number increases by one when you change any of the following settings in your flow configuration:
The aggregation settings that you can use to customize the output format of your flow data.
Specifies whether Amazon AppFlow aggregates the flow records into a single file, or leave them unaggregated.
The desired file size, in MB, for each output file that Amazon AppFlow writes to the flow destination. For each file, Amazon AppFlow attempts to achieve the size that you specify. The actual file sizes might differ from this target based on the number and size of the records that each file contains.
The properties required to query Amazon Honeycode.
The object specified in the Amazon Honeycode flow destination.
The settings that determine how Amazon AppFlow handles an error when placing data in the destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The properties required to query Amazon Connect Customer Profiles.
The unique name of the Amazon Connect Customer Profiles domain.
The object specified in the Amazon Connect Customer Profiles flow destination.
The properties required to query Zendesk.
The object specified in the Zendesk flow destination.
A list of field names that can be used as an ID field when performing a write operation.
The settings that determine how Amazon AppFlow handles an error when placing data in the destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The possible write operations in the destination connector. When this value is not provided, this defaults to the INSERT
operation.
The properties required to query Marketo.
The object specified in the Marketo flow destination.
The settings that determine how Amazon AppFlow handles an error when placing data in the destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The properties that are required to query the custom Connector.
The entity specified in the custom connector as a destination in the flow.
The settings that determine how Amazon AppFlow handles an error when placing data in the custom connector as destination.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
Specifies the type of write operation to be performed in the custom connector when it's used as destination.
The name of the field that Amazon AppFlow uses as an ID when performing a write operation such as update, delete, or upsert.
The custom properties that are specific to the connector when it's used as a destination in the flow.
The properties required to query SAPOData.
The object path specified in the SAPOData flow destination.
Determines how Amazon AppFlow handles the success response that it gets from the connector after placing data.
For example, this setting would determine where to write the response from a destination connector upon a successful insert operation.
The Amazon S3 bucket prefix.
The name of the Amazon S3 bucket.
A list of field names that can be used as an ID field when performing a write operation.
The settings that determine how Amazon AppFlow handles an error when placing data in the destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The possible write operations in the destination connector. When this value is not provided, this defaults to the INSERT
operation.
Describes the details of the most recent flow run.
Describes the details of the most recent flow run.
Specifies the time of the most recent flow run.
Specifies the status of the most recent flow run.
The trigger settings that determine how and when the flow runs.
Specifies the type of flow trigger. This can be OnDemand
, Scheduled
, or Event
.
Specifies the configuration details of a schedule-triggered flow as defined by the user. Currently, these settings only apply to the Scheduled
trigger type.
Specifies the configuration details of a schedule-triggered flow as defined by the user.
The scheduling expression that determines the rate at which the schedule will run, for example rate(5minutes)
.
Specifies whether a scheduled flow has an incremental data transfer or a complete data transfer for each flow run.
The time at which the scheduled flow starts. The time is formatted as a timestamp that follows the ISO 8601 standard, such as 2022-04-26T13:00:00-07:00
.
The time at which the scheduled flow ends. The time is formatted as a timestamp that follows the ISO 8601 standard, such as 2022-04-27T13:00:00-07:00
.
Specifies the time zone used when referring to the dates and times of a scheduled flow, such as America/New_York
. This time zone is only a descriptive label. It doesn't affect how Amazon AppFlow interprets the timestamps that you specify to schedule the flow.
If you want to schedule a flow by using times in a particular time zone, indicate the time zone as a UTC offset in your timestamps. For example, the UTC offsets for the America/New_York
timezone are -04:00
EDT and -05:00 EST
.
Specifies the optional offset that is added to the time interval for a schedule-triggered flow.
Specifies the date range for the records to import from the connector in the first flow run.
Defines how many times a scheduled flow fails consecutively before Amazon AppFlow deactivates it.
A list of tasks that Amazon AppFlow performs while transferring the data in the flow run.
A class for modeling different type of tasks. Task implementation varies based on the TaskType
.
The source fields to which a particular task is applied.
The operation to be performed on the provided source fields.
The operation to be performed on the provided Amplitude source fields.
The operation to be performed on the provided Datadog source fields.
The operation to be performed on the provided Dynatrace source fields.
The operation to be performed on the provided Google Analytics source fields.
The operation to be performed on the provided Infor Nexus source fields.
The operation to be performed on the provided Marketo source fields.
The operation to be performed on the provided Amazon S3 source fields.
The operation to be performed on the provided Salesforce source fields.
The operation to be performed on the provided ServiceNow source fields.
The operation to be performed on the provided Singular source fields.
The operation to be performed on the provided Slack source fields.
The operation to be performed on the provided Trend Micro source fields.
The operation to be performed on the provided Veeva source fields.
The operation to be performed on the provided Zendesk source fields.
The operation to be performed on the provided SAPOData source fields.
Operators supported by the custom connector.
A field in a destination connector, or a field value against which Amazon AppFlow validates a source field.
Specifies the particular task implementation that Amazon AppFlow performs.
A map used to store task-related information. The execution service looks for particular information based on the TaskType
.
Specifies when the flow was created.
Specifies when the flow was last updated.
The ARN of the user who created the flow.
Specifies the user name of the account that performed the most recent update.
The tags used to organize, track, or control access for your flow.
Specifies the configuration that Amazon AppFlow uses when it catalogs the data that's transferred by the associated flow. When Amazon AppFlow catalogs the data from a flow, it stores metadata in a data catalog.
Specifies the configuration that Amazon AppFlow uses when it catalogs your data with the Glue Data Catalog.
The Amazon Resource Name (ARN) of an IAM role that grants Amazon AppFlow the permissions it needs to create Data Catalog tables, databases, and partitions.
For an example IAM policy that has the required permissions, see Identity-based policy examples for Amazon AppFlow.
The name of the Data Catalog database that stores the metadata tables that Amazon AppFlow creates in your Amazon Web Services account. These tables contain metadata for the data that's transferred by the flow that you configure with this parameter.
Note
When you configure a new flow with this parameter, you must specify an existing database.
A naming prefix for each Data Catalog table that Amazon AppFlow creates for the flow that you configure with this setting. Amazon AppFlow adds the prefix to the beginning of the each table name.
Describes the metadata catalog, metadata table, and data partitions that Amazon AppFlow used for the associated flow run.
Describes the metadata catalog, metadata table, and data partitions that Amazon AppFlow used for the associated flow run.
The type of metadata catalog that Amazon AppFlow used for the associated flow run. This parameter returns the following value:
GLUE
The metadata catalog is provided by the Glue Data Catalog. Glue includes the Glue Data Catalog as a component.
The name of the table that stores the metadata for the associated flow run. The table stores metadata that represents the data that the flow transferred. Amazon AppFlow stores the table in the metadata catalog.
Describes the status of the attempt from Amazon AppFlow to register the metadata table with the metadata catalog. Amazon AppFlow creates or updates this table for the associated flow run.
Explains the status of the registration attempt from Amazon AppFlow. If the attempt fails, the message explains why.
Indicates the number of resources that Amazon AppFlow created or updated. Possible resources include metadata tables and data partitions.
Indicates the status of the registration attempt from Amazon AppFlow.
Describes the status of the attempt from Amazon AppFlow to register the data partitions with the metadata catalog. The data partitions organize the flow output into a hierarchical path, such as a folder path in an S3 bucket. Amazon AppFlow creates the partitions (if they don't already exist) based on your flow configuration.
Explains the status of the registration attempt from Amazon AppFlow. If the attempt fails, the message explains why.
Indicates the number of resources that Amazon AppFlow created or updated. Possible resources include metadata tables and data partitions.
Indicates the status of the registration attempt from Amazon AppFlow.
The version number of your data schema. Amazon AppFlow assigns this version number. The version number increases by one when you change any of the following settings in your flow configuration:
Exceptions
Appflow.Client.exceptions.ResourceNotFoundException
Appflow.Client.exceptions.InternalServerException
describe_flow_execution_records
(**kwargs)¶Fetches the execution history of the flow.
See also: AWS API Documentation
Request Syntax
response = client.describe_flow_execution_records(
flowName='string',
maxResults=123,
nextToken='string'
)
[REQUIRED]
The specified name of the flow. Spaces are not allowed. Use underscores (_) or hyphens (-) only.
maxResults
is 20 (for all paginated API operations).dict
Response Syntax
{
'flowExecutions': [
{
'executionId': 'string',
'executionStatus': 'InProgress'|'Successful'|'Error',
'executionResult': {
'errorInfo': {
'putFailuresCount': 123,
'executionMessage': 'string'
},
'bytesProcessed': 123,
'bytesWritten': 123,
'recordsProcessed': 123
},
'startedAt': datetime(2015, 1, 1),
'lastUpdatedAt': datetime(2015, 1, 1),
'dataPullStartTime': datetime(2015, 1, 1),
'dataPullEndTime': datetime(2015, 1, 1),
'metadataCatalogDetails': [
{
'catalogType': 'GLUE',
'tableName': 'string',
'tableRegistrationOutput': {
'message': 'string',
'result': 'string',
'status': 'InProgress'|'Successful'|'Error'
},
'partitionRegistrationOutput': {
'message': 'string',
'result': 'string',
'status': 'InProgress'|'Successful'|'Error'
}
},
]
},
],
'nextToken': 'string'
}
Response Structure
(dict) --
flowExecutions (list) --
Returns a list of all instances when this flow was run.
(dict) --
Specifies information about the past flow run instances for a given flow.
executionId (string) --
Specifies the identifier of the given flow run.
executionStatus (string) --
Specifies the flow run status and whether it is in progress, has completed successfully, or has failed.
executionResult (dict) --
Describes the result of the given flow run.
errorInfo (dict) --
Provides any error message information related to the flow run.
putFailuresCount (integer) --
Specifies the failure count for the attempted flow.
executionMessage (string) --
Specifies the error message that appears if a flow fails.
bytesProcessed (integer) --
The total number of bytes processed by the flow run.
bytesWritten (integer) --
The total number of bytes written as a result of the flow run.
recordsProcessed (integer) --
The number of records processed in the flow run.
startedAt (datetime) --
Specifies the start time of the flow run.
lastUpdatedAt (datetime) --
Specifies the time of the most recent update.
dataPullStartTime (datetime) --
The timestamp that determines the first new or updated record to be transferred in the flow run.
dataPullEndTime (datetime) --
The timestamp that indicates the last new or updated record to be transferred in the flow run.
metadataCatalogDetails (list) --
Describes the metadata catalog, metadata table, and data partitions that Amazon AppFlow used for the associated flow run.
(dict) --
Describes the metadata catalog, metadata table, and data partitions that Amazon AppFlow used for the associated flow run.
catalogType (string) --
The type of metadata catalog that Amazon AppFlow used for the associated flow run. This parameter returns the following value:
GLUE
The metadata catalog is provided by the Glue Data Catalog. Glue includes the Glue Data Catalog as a component.
tableName (string) --
The name of the table that stores the metadata for the associated flow run. The table stores metadata that represents the data that the flow transferred. Amazon AppFlow stores the table in the metadata catalog.
tableRegistrationOutput (dict) --
Describes the status of the attempt from Amazon AppFlow to register the metadata table with the metadata catalog. Amazon AppFlow creates or updates this table for the associated flow run.
message (string) --
Explains the status of the registration attempt from Amazon AppFlow. If the attempt fails, the message explains why.
result (string) --
Indicates the number of resources that Amazon AppFlow created or updated. Possible resources include metadata tables and data partitions.
status (string) --
Indicates the status of the registration attempt from Amazon AppFlow.
partitionRegistrationOutput (dict) --
Describes the status of the attempt from Amazon AppFlow to register the data partitions with the metadata catalog. The data partitions organize the flow output into a hierarchical path, such as a folder path in an S3 bucket. Amazon AppFlow creates the partitions (if they don't already exist) based on your flow configuration.
message (string) --
Explains the status of the registration attempt from Amazon AppFlow. If the attempt fails, the message explains why.
result (string) --
Indicates the number of resources that Amazon AppFlow created or updated. Possible resources include metadata tables and data partitions.
status (string) --
Indicates the status of the registration attempt from Amazon AppFlow.
nextToken (string) --
The pagination token for the next page of data.
Exceptions
Appflow.Client.exceptions.ValidationException
Appflow.Client.exceptions.ResourceNotFoundException
Appflow.Client.exceptions.InternalServerException
get_paginator
(operation_name)¶Create a paginator for an operation.
create_foo
, and you'd normally invoke the
operation as client.create_foo(**kwargs)
, if the
create_foo
operation can be paginated, you can use the
call client.get_paginator("create_foo")
.client.can_paginate
method to
check if an operation is pageable.get_waiter
(waiter_name)¶Returns an object that can wait for some condition.
list_connector_entities
(**kwargs)¶Returns the list of available connector entities supported by Amazon AppFlow. For example, you can query Salesforce for Account and Opportunity entities, or query ServiceNow for the Incident entity.
See also: AWS API Documentation
Request Syntax
response = client.list_connector_entities(
connectorProfileName='string',
connectorType='Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
entitiesPath='string',
apiVersion='string'
)
ConnectorProfile
in the Amazon Web Services account, and is used to query the downstream connector.entitiesPath
parameter. If the connector supports entities at different roots, this initial request returns the list of roots. Otherwise, this request returns all entities supported by the provider.dict
Response Syntax
{
'connectorEntityMap': {
'string': [
{
'name': 'string',
'label': 'string',
'hasNestedEntities': True|False
},
]
}
}
Response Structure
(dict) --
connectorEntityMap (dict) --
The response of ListConnectorEntities
lists entities grouped by category. This map's key represents the group name, and its value contains the list of entities belonging to that group.
(string) --
(list) --
(dict) --
The high-level entity that can be queried in Amazon AppFlow. For example, a Salesforce entity might be an Account or Opportunity , whereas a ServiceNow entity might be an Incident .
name (string) --
The name of the connector entity.
label (string) --
The label applied to the connector entity.
hasNestedEntities (boolean) --
Specifies whether the connector entity is a parent or a category and has more entities nested underneath it. If another call is made with entitiesPath = "the_current_entity_name_with_hasNestedEntities_true"
, then it returns the nested entities underneath it. This provides a way to retrieve all supported entities in a recursive fashion.
Exceptions
Appflow.Client.exceptions.ValidationException
Appflow.Client.exceptions.ResourceNotFoundException
Appflow.Client.exceptions.ConnectorAuthenticationException
Appflow.Client.exceptions.ConnectorServerException
Appflow.Client.exceptions.InternalServerException
list_connectors
(**kwargs)¶Returns the list of all registered custom connectors in your Amazon Web Services account. This API lists only custom connectors registered in this account, not the Amazon Web Services authored connectors.
See also: AWS API Documentation
Request Syntax
response = client.list_connectors(
maxResults=123,
nextToken='string'
)
maxResults
is 20 (for all paginated API operations).dict
Response Syntax
{
'connectors': [
{
'connectorDescription': 'string',
'connectorName': 'string',
'connectorOwner': 'string',
'connectorVersion': 'string',
'applicationType': 'string',
'connectorType': 'Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
'connectorLabel': 'string',
'registeredAt': datetime(2015, 1, 1),
'registeredBy': 'string',
'connectorProvisioningType': 'LAMBDA',
'connectorModes': [
'string',
]
},
],
'nextToken': 'string'
}
Response Structure
(dict) --
connectors (list) --
Contains information about the connectors supported by Amazon AppFlow.
(dict) --
Information about the registered connector.
connectorDescription (string) --
A description about the registered connector.
connectorName (string) --
The name of the connector.
connectorOwner (string) --
The owner of the connector.
connectorVersion (string) --
The connector version.
applicationType (string) --
The application type of the connector.
connectorType (string) --
The connector type.
connectorLabel (string) --
A label used for the connector.
registeredAt (datetime) --
The time at which the connector was registered.
registeredBy (string) --
The user who registered the connector.
connectorProvisioningType (string) --
The provisioning type that the connector uses.
connectorModes (list) --
The connection mode that the connector supports.
nextToken (string) --
The pagination token for the next page of data. If nextToken=null, this means that all records have been fetched.
Exceptions
Appflow.Client.exceptions.ValidationException
Appflow.Client.exceptions.InternalServerException
list_flows
(**kwargs)¶Lists all of the flows associated with your account.
See also: AWS API Documentation
Request Syntax
response = client.list_flows(
maxResults=123,
nextToken='string'
)
dict
Response Syntax
{
'flows': [
{
'flowArn': 'string',
'description': 'string',
'flowName': 'string',
'flowStatus': 'Active'|'Deprecated'|'Deleted'|'Draft'|'Errored'|'Suspended',
'sourceConnectorType': 'Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
'sourceConnectorLabel': 'string',
'destinationConnectorType': 'Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
'destinationConnectorLabel': 'string',
'triggerType': 'Scheduled'|'Event'|'OnDemand',
'createdAt': datetime(2015, 1, 1),
'lastUpdatedAt': datetime(2015, 1, 1),
'createdBy': 'string',
'lastUpdatedBy': 'string',
'tags': {
'string': 'string'
},
'lastRunExecutionDetails': {
'mostRecentExecutionMessage': 'string',
'mostRecentExecutionTime': datetime(2015, 1, 1),
'mostRecentExecutionStatus': 'InProgress'|'Successful'|'Error'
}
},
],
'nextToken': 'string'
}
Response Structure
(dict) --
flows (list) --
The list of flows associated with your account.
(dict) --
The properties of the flow, such as its source, destination, trigger type, and so on.
flowArn (string) --
The flow's Amazon Resource Name (ARN).
description (string) --
A user-entered description of the flow.
flowName (string) --
The specified name of the flow. Spaces are not allowed. Use underscores (_) or hyphens (-) only.
flowStatus (string) --
Indicates the current status of the flow.
sourceConnectorType (string) --
Specifies the source connector type, such as Salesforce, Amazon S3, Amplitude, and so on.
sourceConnectorLabel (string) --
The label of the source connector in the flow.
destinationConnectorType (string) --
Specifies the destination connector type, such as Salesforce, Amazon S3, Amplitude, and so on.
destinationConnectorLabel (string) --
The label of the destination connector in the flow.
triggerType (string) --
Specifies the type of flow trigger. This can be OnDemand
, Scheduled
, or Event
.
createdAt (datetime) --
Specifies when the flow was created.
lastUpdatedAt (datetime) --
Specifies when the flow was last updated.
createdBy (string) --
The ARN of the user who created the flow.
lastUpdatedBy (string) --
Specifies the account user name that most recently updated the flow.
tags (dict) --
The tags used to organize, track, or control access for your flow.
lastRunExecutionDetails (dict) --
Describes the details of the most recent flow run.
mostRecentExecutionMessage (string) --
Describes the details of the most recent flow run.
mostRecentExecutionTime (datetime) --
Specifies the time of the most recent flow run.
mostRecentExecutionStatus (string) --
Specifies the status of the most recent flow run.
nextToken (string) --
The pagination token for next page of data.
Exceptions
Appflow.Client.exceptions.ValidationException
Appflow.Client.exceptions.InternalServerException
Retrieves the tags that are associated with a specified flow.
See also: AWS API Documentation
Request Syntax
response = client.list_tags_for_resource(
resourceArn='string'
)
[REQUIRED]
The Amazon Resource Name (ARN) of the specified flow.
{
'tags': {
'string': 'string'
}
}
Response Structure
The tags used to organize, track, or control access for your flow.
Exceptions
Appflow.Client.exceptions.InternalServerException
Appflow.Client.exceptions.ValidationException
Appflow.Client.exceptions.ResourceNotFoundException
register_connector
(**kwargs)¶Registers a new custom connector with your Amazon Web Services account. Before you can register the connector, you must deploy the associated AWS lambda function in your account.
See also: AWS API Documentation
Request Syntax
response = client.register_connector(
connectorLabel='string',
description='string',
connectorProvisioningType='LAMBDA',
connectorProvisioningConfig={
'lambda': {
'lambdaArn': 'string'
}
}
)
ConnectorRegistration
in your Amazon Web Services account.The provisioning type of the connector. Currently the only supported value is LAMBDA.
Contains information about the configuration of the lambda which is being registered as the connector.
Lambda ARN of the connector being registered.
dict
Response Syntax
{
'connectorArn': 'string'
}
Response Structure
(dict) --
connectorArn (string) --
The ARN of the connector being registered.
Exceptions
Appflow.Client.exceptions.ValidationException
Appflow.Client.exceptions.ConflictException
Appflow.Client.exceptions.AccessDeniedException
Appflow.Client.exceptions.ResourceNotFoundException
Appflow.Client.exceptions.ServiceQuotaExceededException
Appflow.Client.exceptions.ThrottlingException
Appflow.Client.exceptions.InternalServerException
Appflow.Client.exceptions.ConnectorServerException
Appflow.Client.exceptions.ConnectorAuthenticationException
start_flow
(**kwargs)¶Activates an existing flow. For on-demand flows, this operation runs the flow immediately. For schedule and event-triggered flows, this operation activates the flow.
See also: AWS API Documentation
Request Syntax
response = client.start_flow(
flowName='string'
)
[REQUIRED]
The specified name of the flow. Spaces are not allowed. Use underscores (_) or hyphens (-) only.
{
'flowArn': 'string',
'flowStatus': 'Active'|'Deprecated'|'Deleted'|'Draft'|'Errored'|'Suspended',
'executionId': 'string'
}
Response Structure
The flow's Amazon Resource Name (ARN).
Indicates the current status of the flow.
Returns the internal execution ID of an on-demand flow when the flow is started. For scheduled or event-triggered flows, this value is null.
Exceptions
Appflow.Client.exceptions.ResourceNotFoundException
Appflow.Client.exceptions.InternalServerException
Appflow.Client.exceptions.ServiceQuotaExceededException
Appflow.Client.exceptions.ConflictException
stop_flow
(**kwargs)¶Deactivates the existing flow. For on-demand flows, this operation returns an unsupportedOperationException
error message. For schedule and event-triggered flows, this operation deactivates the flow.
See also: AWS API Documentation
Request Syntax
response = client.stop_flow(
flowName='string'
)
[REQUIRED]
The specified name of the flow. Spaces are not allowed. Use underscores (_) or hyphens (-) only.
{
'flowArn': 'string',
'flowStatus': 'Active'|'Deprecated'|'Deleted'|'Draft'|'Errored'|'Suspended'
}
Response Structure
The flow's Amazon Resource Name (ARN).
Indicates the current status of the flow.
Exceptions
Appflow.Client.exceptions.ConflictException
Appflow.Client.exceptions.ResourceNotFoundException
Appflow.Client.exceptions.UnsupportedOperationException
Appflow.Client.exceptions.InternalServerException
tag_resource
(**kwargs)¶Applies a tag to the specified flow.
See also: AWS API Documentation
Request Syntax
response = client.tag_resource(
resourceArn='string',
tags={
'string': 'string'
}
)
[REQUIRED]
The Amazon Resource Name (ARN) of the flow that you want to tag.
[REQUIRED]
The tags used to organize, track, or control access for your flow.
dict
Response Syntax
{}
Response Structure
Exceptions
Appflow.Client.exceptions.InternalServerException
Appflow.Client.exceptions.ValidationException
Appflow.Client.exceptions.ResourceNotFoundException
unregister_connector
(**kwargs)¶Unregisters the custom connector registered in your account that matches the connector label provided in the request.
See also: AWS API Documentation
Request Syntax
response = client.unregister_connector(
connectorLabel='string',
forceDelete=True|False
)
[REQUIRED]
The label of the connector. The label is unique for each ConnectorRegistration
in your Amazon Web Services account.
dict
Response Syntax
{}
Response Structure
Exceptions
Appflow.Client.exceptions.ResourceNotFoundException
Appflow.Client.exceptions.ConflictException
Appflow.Client.exceptions.InternalServerException
untag_resource
(**kwargs)¶Removes a tag from the specified flow.
See also: AWS API Documentation
Request Syntax
response = client.untag_resource(
resourceArn='string',
tagKeys=[
'string',
]
)
[REQUIRED]
The Amazon Resource Name (ARN) of the flow that you want to untag.
[REQUIRED]
The tag keys associated with the tag that you want to remove from your flow.
dict
Response Syntax
{}
Response Structure
Exceptions
Appflow.Client.exceptions.InternalServerException
Appflow.Client.exceptions.ValidationException
Appflow.Client.exceptions.ResourceNotFoundException
update_connector_profile
(**kwargs)¶Updates a given connector profile associated with your account.
See also: AWS API Documentation
Request Syntax
response = client.update_connector_profile(
connectorProfileName='string',
connectionMode='Public'|'Private',
connectorProfileConfig={
'connectorProfileProperties': {
'Amplitude': {}
,
'Datadog': {
'instanceUrl': 'string'
},
'Dynatrace': {
'instanceUrl': 'string'
},
'GoogleAnalytics': {}
,
'Honeycode': {}
,
'InforNexus': {
'instanceUrl': 'string'
},
'Marketo': {
'instanceUrl': 'string'
},
'Redshift': {
'databaseUrl': 'string',
'bucketName': 'string',
'bucketPrefix': 'string',
'roleArn': 'string',
'dataApiRoleArn': 'string',
'isRedshiftServerless': True|False,
'clusterIdentifier': 'string',
'workgroupName': 'string',
'databaseName': 'string'
},
'Salesforce': {
'instanceUrl': 'string',
'isSandboxEnvironment': True|False
},
'ServiceNow': {
'instanceUrl': 'string'
},
'Singular': {}
,
'Slack': {
'instanceUrl': 'string'
},
'Snowflake': {
'warehouse': 'string',
'stage': 'string',
'bucketName': 'string',
'bucketPrefix': 'string',
'privateLinkServiceName': 'string',
'accountName': 'string',
'region': 'string'
},
'Trendmicro': {}
,
'Veeva': {
'instanceUrl': 'string'
},
'Zendesk': {
'instanceUrl': 'string'
},
'SAPOData': {
'applicationHostUrl': 'string',
'applicationServicePath': 'string',
'portNumber': 123,
'clientNumber': 'string',
'logonLanguage': 'string',
'privateLinkServiceName': 'string',
'oAuthProperties': {
'tokenUrl': 'string',
'authCodeUrl': 'string',
'oAuthScopes': [
'string',
]
}
},
'CustomConnector': {
'profileProperties': {
'string': 'string'
},
'oAuth2Properties': {
'tokenUrl': 'string',
'oAuth2GrantType': 'CLIENT_CREDENTIALS'|'AUTHORIZATION_CODE',
'tokenUrlCustomProperties': {
'string': 'string'
}
}
}
},
'connectorProfileCredentials': {
'Amplitude': {
'apiKey': 'string',
'secretKey': 'string'
},
'Datadog': {
'apiKey': 'string',
'applicationKey': 'string'
},
'Dynatrace': {
'apiToken': 'string'
},
'GoogleAnalytics': {
'clientId': 'string',
'clientSecret': 'string',
'accessToken': 'string',
'refreshToken': 'string',
'oAuthRequest': {
'authCode': 'string',
'redirectUri': 'string'
}
},
'Honeycode': {
'accessToken': 'string',
'refreshToken': 'string',
'oAuthRequest': {
'authCode': 'string',
'redirectUri': 'string'
}
},
'InforNexus': {
'accessKeyId': 'string',
'userId': 'string',
'secretAccessKey': 'string',
'datakey': 'string'
},
'Marketo': {
'clientId': 'string',
'clientSecret': 'string',
'accessToken': 'string',
'oAuthRequest': {
'authCode': 'string',
'redirectUri': 'string'
}
},
'Redshift': {
'username': 'string',
'password': 'string'
},
'Salesforce': {
'accessToken': 'string',
'refreshToken': 'string',
'oAuthRequest': {
'authCode': 'string',
'redirectUri': 'string'
},
'clientCredentialsArn': 'string'
},
'ServiceNow': {
'username': 'string',
'password': 'string'
},
'Singular': {
'apiKey': 'string'
},
'Slack': {
'clientId': 'string',
'clientSecret': 'string',
'accessToken': 'string',
'oAuthRequest': {
'authCode': 'string',
'redirectUri': 'string'
}
},
'Snowflake': {
'username': 'string',
'password': 'string'
},
'Trendmicro': {
'apiSecretKey': 'string'
},
'Veeva': {
'username': 'string',
'password': 'string'
},
'Zendesk': {
'clientId': 'string',
'clientSecret': 'string',
'accessToken': 'string',
'oAuthRequest': {
'authCode': 'string',
'redirectUri': 'string'
}
},
'SAPOData': {
'basicAuthCredentials': {
'username': 'string',
'password': 'string'
},
'oAuthCredentials': {
'clientId': 'string',
'clientSecret': 'string',
'accessToken': 'string',
'refreshToken': 'string',
'oAuthRequest': {
'authCode': 'string',
'redirectUri': 'string'
}
}
},
'CustomConnector': {
'authenticationType': 'OAUTH2'|'APIKEY'|'BASIC'|'CUSTOM',
'basic': {
'username': 'string',
'password': 'string'
},
'oauth2': {
'clientId': 'string',
'clientSecret': 'string',
'accessToken': 'string',
'refreshToken': 'string',
'oAuthRequest': {
'authCode': 'string',
'redirectUri': 'string'
}
},
'apiKey': {
'apiKey': 'string',
'apiSecretKey': 'string'
},
'custom': {
'customAuthenticationType': 'string',
'credentialsMap': {
'string': 'string'
}
}
}
}
}
)
[REQUIRED]
The name of the connector profile and is unique for each ConnectorProfile
in the Amazon Web Services account.
[REQUIRED]
Indicates the connection mode and if it is public or private.
[REQUIRED]
Defines the connector-specific profile configuration and credentials.
The connector-specific properties of the profile configuration.
The connector-specific properties required by Amplitude.
The connector-specific properties required by Datadog.
The location of the Datadog resource.
The connector-specific properties required by Dynatrace.
The location of the Dynatrace resource.
The connector-specific properties required Google Analytics.
The connector-specific properties required by Amazon Honeycode.
The connector-specific properties required by Infor Nexus.
The location of the Infor Nexus resource.
The connector-specific properties required by Marketo.
The location of the Marketo resource.
The connector-specific properties required by Amazon Redshift.
The JDBC URL of the Amazon Redshift cluster.
A name for the associated Amazon S3 bucket.
The object key for the destination bucket in which Amazon AppFlow places the files.
The Amazon Resource Name (ARN) of IAM role that grants Amazon Redshift read-only access to Amazon S3. For more information, and for the polices that you attach to this role, see Allow Amazon Redshift to access your Amazon AppFlow data in Amazon S3.
The Amazon Resource Name (ARN) of an IAM role that permits Amazon AppFlow to access your Amazon Redshift database through the Data API. For more information, and for the polices that you attach to this role, see Allow Amazon AppFlow to access Amazon Redshift databases with the Data API.
Indicates whether the connector profile defines a connection to an Amazon Redshift Serverless data warehouse.
The unique ID that's assigned to an Amazon Redshift cluster.
The name of an Amazon Redshift workgroup.
The name of an Amazon Redshift database.
The connector-specific properties required by Salesforce.
The location of the Salesforce resource.
Indicates whether the connector profile applies to a sandbox or production environment.
The connector-specific properties required by serviceNow.
The location of the ServiceNow resource.
The connector-specific properties required by Singular.
The connector-specific properties required by Slack.
The location of the Slack resource.
The connector-specific properties required by Snowflake.
The name of the Snowflake warehouse.
The name of the Amazon S3 stage that was created while setting up an Amazon S3 stage in the Snowflake account. This is written in the following format: < Database>< Schema><Stage Name>.
The name of the Amazon S3 bucket associated with Snowflake.
The bucket path that refers to the Amazon S3 bucket associated with Snowflake.
The Snowflake Private Link service name to be used for private data transfers.
The name of the account.
The Amazon Web Services Region of the Snowflake account.
The connector-specific properties required by Trend Micro.
The connector-specific properties required by Veeva.
The location of the Veeva resource.
The connector-specific properties required by Zendesk.
The location of the Zendesk resource.
The connector-specific profile properties required when using SAPOData.
The location of the SAPOData resource.
The application path to catalog service.
The port number of the SAPOData instance.
The client number for the client creating the connection.
The logon language of SAPOData instance.
The SAPOData Private Link service name to be used for private data transfers.
The SAPOData OAuth properties required for OAuth type authentication.
The token url required to fetch access/refresh tokens using authorization code and also to refresh expired access token using refresh token.
The authorization code url required to redirect to SAP Login Page to fetch authorization code for OAuth type authentication.
The OAuth scopes required for OAuth type authentication.
The properties required by the custom connector.
A map of properties that are required to create a profile for the custom connector.
The OAuth 2.0 properties required for OAuth 2.0 authentication.
The token URL required for OAuth 2.0 authentication.
The OAuth 2.0 grant type used by connector for OAuth 2.0 authentication.
Associates your token URL with a map of properties that you define. Use this parameter to provide any additional details that the connector requires to authenticate your request.
The connector-specific credentials required by each connector.
The connector-specific credentials required when using Amplitude.
A unique alphanumeric identifier used to authenticate a user, developer, or calling program to your API.
The Secret Access Key portion of the credentials.
The connector-specific credentials required when using Datadog.
A unique alphanumeric identifier used to authenticate a user, developer, or calling program to your API.
Application keys, in conjunction with your API key, give you full access to Datadog’s programmatic API. Application keys are associated with the user account that created them. The application key is used to log all requests made to the API.
The connector-specific credentials required when using Dynatrace.
The API tokens used by Dynatrace API to authenticate various API calls.
The connector-specific credentials required when using Google Analytics.
The identifier for the desired client.
The client secret used by the OAuth client to authenticate to the authorization server.
The credentials used to access protected Google Analytics resources.
The credentials used to acquire new access tokens. This is required only for OAuth2 access tokens, and is not required for OAuth1 access tokens.
The OAuth requirement needed to request security tokens from the connector endpoint.
The code provided by the connector when it has been authenticated via the connected app.
The URL to which the authentication server redirects the browser after authorization has been granted.
The connector-specific credentials required when using Amazon Honeycode.
The credentials used to access protected Amazon Honeycode resources.
The credentials used to acquire new access tokens.
Used by select connectors for which the OAuth workflow is supported, such as Salesforce, Google Analytics, Marketo, Zendesk, and Slack.
The code provided by the connector when it has been authenticated via the connected app.
The URL to which the authentication server redirects the browser after authorization has been granted.
The connector-specific credentials required when using Infor Nexus.
The Access Key portion of the credentials.
The identifier for the user.
The secret key used to sign requests.
The encryption keys used to encrypt data.
The connector-specific credentials required when using Marketo.
The identifier for the desired client.
The client secret used by the OAuth client to authenticate to the authorization server.
The credentials used to access protected Marketo resources.
The OAuth requirement needed to request security tokens from the connector endpoint.
The code provided by the connector when it has been authenticated via the connected app.
The URL to which the authentication server redirects the browser after authorization has been granted.
The connector-specific credentials required when using Amazon Redshift.
The name of the user.
The password that corresponds to the user name.
The connector-specific credentials required when using Salesforce.
The credentials used to access protected Salesforce resources.
The credentials used to acquire new access tokens.
The OAuth requirement needed to request security tokens from the connector endpoint.
The code provided by the connector when it has been authenticated via the connected app.
The URL to which the authentication server redirects the browser after authorization has been granted.
The secret manager ARN, which contains the client ID and client secret of the connected app.
The connector-specific credentials required when using ServiceNow.
The name of the user.
The password that corresponds to the user name.
The connector-specific credentials required when using Singular.
A unique alphanumeric identifier used to authenticate a user, developer, or calling program to your API.
The connector-specific credentials required when using Slack.
The identifier for the client.
The client secret used by the OAuth client to authenticate to the authorization server.
The credentials used to access protected Slack resources.
The OAuth requirement needed to request security tokens from the connector endpoint.
The code provided by the connector when it has been authenticated via the connected app.
The URL to which the authentication server redirects the browser after authorization has been granted.
The connector-specific credentials required when using Snowflake.
The name of the user.
The password that corresponds to the user name.
The connector-specific credentials required when using Trend Micro.
The Secret Access Key portion of the credentials.
The connector-specific credentials required when using Veeva.
The name of the user.
The password that corresponds to the user name.
The connector-specific credentials required when using Zendesk.
The identifier for the desired client.
The client secret used by the OAuth client to authenticate to the authorization server.
The credentials used to access protected Zendesk resources.
The OAuth requirement needed to request security tokens from the connector endpoint.
The code provided by the connector when it has been authenticated via the connected app.
The URL to which the authentication server redirects the browser after authorization has been granted.
The connector-specific profile credentials required when using SAPOData.
The SAPOData basic authentication credentials.
The username to use to connect to a resource.
The password to use to connect to a resource.
The SAPOData OAuth type authentication credentials.
The identifier for the desired client.
The client secret used by the OAuth client to authenticate to the authorization server.
The access token used to access protected SAPOData resources.
The refresh token used to refresh expired access token.
The OAuth requirement needed to request security tokens from the connector endpoint.
The code provided by the connector when it has been authenticated via the connected app.
The URL to which the authentication server redirects the browser after authorization has been granted.
The connector-specific profile credentials that are required when using the custom connector.
The authentication type that the custom connector uses for authenticating while creating a connector profile.
The basic credentials that are required for the authentication of the user.
The username to use to connect to a resource.
The password to use to connect to a resource.
The OAuth 2.0 credentials required for the authentication of the user.
The identifier for the desired client.
The client secret used by the OAuth client to authenticate to the authorization server.
The access token used to access the connector on your behalf.
The refresh token used to refresh an expired access token.
Used by select connectors for which the OAuth workflow is supported, such as Salesforce, Google Analytics, Marketo, Zendesk, and Slack.
The code provided by the connector when it has been authenticated via the connected app.
The URL to which the authentication server redirects the browser after authorization has been granted.
The API keys required for the authentication of the user.
The API key required for API key authentication.
The API secret key required for API key authentication.
If the connector uses the custom authentication mechanism, this holds the required credentials.
The custom authentication type that the connector uses.
A map that holds custom authentication credentials.
dict
Response Syntax
{
'connectorProfileArn': 'string'
}
Response Structure
(dict) --
connectorProfileArn (string) --
The Amazon Resource Name (ARN) of the connector profile.
Exceptions
Appflow.Client.exceptions.ValidationException
Appflow.Client.exceptions.ResourceNotFoundException
Appflow.Client.exceptions.ConflictException
Appflow.Client.exceptions.ConnectorAuthenticationException
Appflow.Client.exceptions.InternalServerException
update_connector_registration
(**kwargs)¶Updates a custom connector that you've previously registered. This operation updates the connector with one of the following:
See also: AWS API Documentation
Request Syntax
response = client.update_connector_registration(
connectorLabel='string',
description='string',
connectorProvisioningConfig={
'lambda': {
'lambdaArn': 'string'
}
}
)
[REQUIRED]
The name of the connector. The name is unique for each connector registration in your AWS account.
Contains information about the configuration of the connector being registered.
Contains information about the configuration of the lambda which is being registered as the connector.
Lambda ARN of the connector being registered.
dict
Response Syntax
{
'connectorArn': 'string'
}
Response Structure
(dict) --
connectorArn (string) --
The ARN of the connector being updated.
Exceptions
Appflow.Client.exceptions.ValidationException
Appflow.Client.exceptions.ConflictException
Appflow.Client.exceptions.AccessDeniedException
Appflow.Client.exceptions.ResourceNotFoundException
Appflow.Client.exceptions.ServiceQuotaExceededException
Appflow.Client.exceptions.ThrottlingException
Appflow.Client.exceptions.InternalServerException
Appflow.Client.exceptions.ConnectorServerException
Appflow.Client.exceptions.ConnectorAuthenticationException
update_flow
(**kwargs)¶Updates an existing flow.
See also: AWS API Documentation
Request Syntax
response = client.update_flow(
flowName='string',
description='string',
triggerConfig={
'triggerType': 'Scheduled'|'Event'|'OnDemand',
'triggerProperties': {
'Scheduled': {
'scheduleExpression': 'string',
'dataPullMode': 'Incremental'|'Complete',
'scheduleStartTime': datetime(2015, 1, 1),
'scheduleEndTime': datetime(2015, 1, 1),
'timezone': 'string',
'scheduleOffset': 123,
'firstExecutionFrom': datetime(2015, 1, 1),
'flowErrorDeactivationThreshold': 123
}
}
},
sourceFlowConfig={
'connectorType': 'Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
'apiVersion': 'string',
'connectorProfileName': 'string',
'sourceConnectorProperties': {
'Amplitude': {
'object': 'string'
},
'Datadog': {
'object': 'string'
},
'Dynatrace': {
'object': 'string'
},
'GoogleAnalytics': {
'object': 'string'
},
'InforNexus': {
'object': 'string'
},
'Marketo': {
'object': 'string'
},
'S3': {
'bucketName': 'string',
'bucketPrefix': 'string',
's3InputFormatConfig': {
's3InputFileType': 'CSV'|'JSON'
}
},
'Salesforce': {
'object': 'string',
'enableDynamicFieldUpdate': True|False,
'includeDeletedRecords': True|False,
'dataTransferApi': 'AUTOMATIC'|'BULKV2'|'REST_SYNC'
},
'ServiceNow': {
'object': 'string'
},
'Singular': {
'object': 'string'
},
'Slack': {
'object': 'string'
},
'Trendmicro': {
'object': 'string'
},
'Veeva': {
'object': 'string',
'documentType': 'string',
'includeSourceFiles': True|False,
'includeRenditions': True|False,
'includeAllVersions': True|False
},
'Zendesk': {
'object': 'string'
},
'SAPOData': {
'objectPath': 'string'
},
'CustomConnector': {
'entityName': 'string',
'customProperties': {
'string': 'string'
}
}
},
'incrementalPullConfig': {
'datetimeTypeFieldName': 'string'
}
},
destinationFlowConfigList=[
{
'connectorType': 'Salesforce'|'Singular'|'Slack'|'Redshift'|'S3'|'Marketo'|'Googleanalytics'|'Zendesk'|'Servicenow'|'Datadog'|'Trendmicro'|'Snowflake'|'Dynatrace'|'Infornexus'|'Amplitude'|'Veeva'|'EventBridge'|'LookoutMetrics'|'Upsolver'|'Honeycode'|'CustomerProfiles'|'SAPOData'|'CustomConnector',
'apiVersion': 'string',
'connectorProfileName': 'string',
'destinationConnectorProperties': {
'Redshift': {
'object': 'string',
'intermediateBucketName': 'string',
'bucketPrefix': 'string',
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
}
},
'S3': {
'bucketName': 'string',
'bucketPrefix': 'string',
's3OutputFormatConfig': {
'fileType': 'CSV'|'JSON'|'PARQUET',
'prefixConfig': {
'prefixType': 'FILENAME'|'PATH'|'PATH_AND_FILENAME',
'prefixFormat': 'YEAR'|'MONTH'|'DAY'|'HOUR'|'MINUTE',
'pathPrefixHierarchy': [
'EXECUTION_ID'|'SCHEMA_VERSION',
]
},
'aggregationConfig': {
'aggregationType': 'None'|'SingleFile',
'targetFileSize': 123
},
'preserveSourceDataTyping': True|False
}
},
'Salesforce': {
'object': 'string',
'idFieldNames': [
'string',
],
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
},
'writeOperationType': 'INSERT'|'UPSERT'|'UPDATE'|'DELETE',
'dataTransferApi': 'AUTOMATIC'|'BULKV2'|'REST_SYNC'
},
'Snowflake': {
'object': 'string',
'intermediateBucketName': 'string',
'bucketPrefix': 'string',
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
}
},
'EventBridge': {
'object': 'string',
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
}
},
'LookoutMetrics': {}
,
'Upsolver': {
'bucketName': 'string',
'bucketPrefix': 'string',
's3OutputFormatConfig': {
'fileType': 'CSV'|'JSON'|'PARQUET',
'prefixConfig': {
'prefixType': 'FILENAME'|'PATH'|'PATH_AND_FILENAME',
'prefixFormat': 'YEAR'|'MONTH'|'DAY'|'HOUR'|'MINUTE',
'pathPrefixHierarchy': [
'EXECUTION_ID'|'SCHEMA_VERSION',
]
},
'aggregationConfig': {
'aggregationType': 'None'|'SingleFile',
'targetFileSize': 123
}
}
},
'Honeycode': {
'object': 'string',
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
}
},
'CustomerProfiles': {
'domainName': 'string',
'objectTypeName': 'string'
},
'Zendesk': {
'object': 'string',
'idFieldNames': [
'string',
],
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
},
'writeOperationType': 'INSERT'|'UPSERT'|'UPDATE'|'DELETE'
},
'Marketo': {
'object': 'string',
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
}
},
'CustomConnector': {
'entityName': 'string',
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
},
'writeOperationType': 'INSERT'|'UPSERT'|'UPDATE'|'DELETE',
'idFieldNames': [
'string',
],
'customProperties': {
'string': 'string'
}
},
'SAPOData': {
'objectPath': 'string',
'successResponseHandlingConfig': {
'bucketPrefix': 'string',
'bucketName': 'string'
},
'idFieldNames': [
'string',
],
'errorHandlingConfig': {
'failOnFirstDestinationError': True|False,
'bucketPrefix': 'string',
'bucketName': 'string'
},
'writeOperationType': 'INSERT'|'UPSERT'|'UPDATE'|'DELETE'
}
}
},
],
tasks=[
{
'sourceFields': [
'string',
],
'connectorOperator': {
'Amplitude': 'BETWEEN',
'Datadog': 'PROJECTION'|'BETWEEN'|'EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Dynatrace': 'PROJECTION'|'BETWEEN'|'EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'GoogleAnalytics': 'PROJECTION'|'BETWEEN',
'InforNexus': 'PROJECTION'|'BETWEEN'|'EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Marketo': 'PROJECTION'|'LESS_THAN'|'GREATER_THAN'|'BETWEEN'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'S3': 'PROJECTION'|'LESS_THAN'|'GREATER_THAN'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Salesforce': 'PROJECTION'|'LESS_THAN'|'CONTAINS'|'GREATER_THAN'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'ServiceNow': 'PROJECTION'|'CONTAINS'|'LESS_THAN'|'GREATER_THAN'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Singular': 'PROJECTION'|'EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Slack': 'PROJECTION'|'LESS_THAN'|'GREATER_THAN'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Trendmicro': 'PROJECTION'|'EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Veeva': 'PROJECTION'|'LESS_THAN'|'GREATER_THAN'|'CONTAINS'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'Zendesk': 'PROJECTION'|'GREATER_THAN'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'SAPOData': 'PROJECTION'|'LESS_THAN'|'CONTAINS'|'GREATER_THAN'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP',
'CustomConnector': 'PROJECTION'|'LESS_THAN'|'GREATER_THAN'|'CONTAINS'|'BETWEEN'|'LESS_THAN_OR_EQUAL_TO'|'GREATER_THAN_OR_EQUAL_TO'|'EQUAL_TO'|'NOT_EQUAL_TO'|'ADDITION'|'MULTIPLICATION'|'DIVISION'|'SUBTRACTION'|'MASK_ALL'|'MASK_FIRST_N'|'MASK_LAST_N'|'VALIDATE_NON_NULL'|'VALIDATE_NON_ZERO'|'VALIDATE_NON_NEGATIVE'|'VALIDATE_NUMERIC'|'NO_OP'
},
'destinationField': 'string',
'taskType': 'Arithmetic'|'Filter'|'Map'|'Map_all'|'Mask'|'Merge'|'Passthrough'|'Truncate'|'Validate'|'Partition',
'taskProperties': {
'string': 'string'
}
},
],
metadataCatalogConfig={
'glueDataCatalog': {
'roleArn': 'string',
'databaseName': 'string',
'tablePrefix': 'string'
}
}
)
[REQUIRED]
The specified name of the flow. Spaces are not allowed. Use underscores (_) or hyphens (-) only.
[REQUIRED]
The trigger settings that determine how and when the flow runs.
Specifies the type of flow trigger. This can be OnDemand
, Scheduled
, or Event
.
Specifies the configuration details of a schedule-triggered flow as defined by the user. Currently, these settings only apply to the Scheduled
trigger type.
Specifies the configuration details of a schedule-triggered flow as defined by the user.
The scheduling expression that determines the rate at which the schedule will run, for example rate(5minutes)
.
Specifies whether a scheduled flow has an incremental data transfer or a complete data transfer for each flow run.
The time at which the scheduled flow starts. The time is formatted as a timestamp that follows the ISO 8601 standard, such as 2022-04-26T13:00:00-07:00
.
The time at which the scheduled flow ends. The time is formatted as a timestamp that follows the ISO 8601 standard, such as 2022-04-27T13:00:00-07:00
.
Specifies the time zone used when referring to the dates and times of a scheduled flow, such as America/New_York
. This time zone is only a descriptive label. It doesn't affect how Amazon AppFlow interprets the timestamps that you specify to schedule the flow.
If you want to schedule a flow by using times in a particular time zone, indicate the time zone as a UTC offset in your timestamps. For example, the UTC offsets for the America/New_York
timezone are -04:00
EDT and -05:00 EST
.
Specifies the optional offset that is added to the time interval for a schedule-triggered flow.
Specifies the date range for the records to import from the connector in the first flow run.
Defines how many times a scheduled flow fails consecutively before Amazon AppFlow deactivates it.
[REQUIRED]
Contains information about the configuration of the source connector used in the flow.
The type of connector, such as Salesforce, Amplitude, and so on.
The API version of the connector when it's used as a source in the flow.
The name of the connector profile. This name must be unique for each connector profile in the Amazon Web Services account.
Specifies the information that is required to query a particular source connector.
Specifies the information that is required for querying Amplitude.
The object specified in the Amplitude flow source.
Specifies the information that is required for querying Datadog.
The object specified in the Datadog flow source.
Specifies the information that is required for querying Dynatrace.
The object specified in the Dynatrace flow source.
Specifies the information that is required for querying Google Analytics.
The object specified in the Google Analytics flow source.
Specifies the information that is required for querying Infor Nexus.
The object specified in the Infor Nexus flow source.
Specifies the information that is required for querying Marketo.
The object specified in the Marketo flow source.
Specifies the information that is required for querying Amazon S3.
The Amazon S3 bucket name where the source files are stored.
The object key for the Amazon S3 bucket in which the source files are stored.
When you use Amazon S3 as the source, the configuration format that you provide the flow input data.
The file type that Amazon AppFlow gets from your Amazon S3 bucket.
Specifies the information that is required for querying Salesforce.
The object specified in the Salesforce flow source.
The flag that enables dynamic fetching of new (recently added) fields in the Salesforce objects while running a flow.
Indicates whether Amazon AppFlow includes deleted files in the flow run.
Specifies which Salesforce API is used by Amazon AppFlow when your flow transfers data from Salesforce.
AUTOMATIC
The default. Amazon AppFlow selects which API to use based on the number of records that your flow transfers from Salesforce. If your flow transfers fewer than 1,000,000 records, Amazon AppFlow uses Salesforce REST API. If your flow transfers 1,000,000 records or more, Amazon AppFlow uses Salesforce Bulk API 2.0.
Each of these Salesforce APIs structures data differently. If Amazon AppFlow selects the API automatically, be aware that, for recurring flows, the data output might vary from one flow run to the next. For example, if a flow runs daily, it might use REST API on one day to transfer 900,000 records, and it might use Bulk API 2.0 on the next day to transfer 1,100,000 records. For each of these flow runs, the respective Salesforce API formats the data differently. Some of the differences include how dates are formatted and null values are represented. Also, Bulk API 2.0 doesn't transfer Salesforce compound fields.
By choosing this option, you optimize flow performance for both small and large data transfers, but the tradeoff is inconsistent formatting in the output.
BULKV2
Amazon AppFlow uses only Salesforce Bulk API 2.0. This API runs asynchronous data transfers, and it's optimal for large sets of data. By choosing this option, you ensure that your flow writes consistent output, but you optimize performance only for large data transfers.
Note that Bulk API 2.0 does not transfer Salesforce compound fields.
REST_SYNC
Amazon AppFlow uses only Salesforce REST API. By choosing this option, you ensure that your flow writes consistent output, but you decrease performance for large data transfers that are better suited for Bulk API 2.0. In some cases, if your flow attempts to transfer a vary large set of data, it might fail wituh a timed out error.
Specifies the information that is required for querying ServiceNow.
The object specified in the ServiceNow flow source.
Specifies the information that is required for querying Singular.
The object specified in the Singular flow source.
Specifies the information that is required for querying Slack.
The object specified in the Slack flow source.
Specifies the information that is required for querying Trend Micro.
The object specified in the Trend Micro flow source.
Specifies the information that is required for querying Veeva.
The object specified in the Veeva flow source.
The document type specified in the Veeva document extract flow.
Boolean value to include source files in Veeva document extract flow.
Boolean value to include file renditions in Veeva document extract flow.
Boolean value to include All Versions of files in Veeva document extract flow.
Specifies the information that is required for querying Zendesk.
The object specified in the Zendesk flow source.
The properties that are applied when using SAPOData as a flow source.
The object path specified in the SAPOData flow source.
The properties that are applied when the custom connector is being used as a source.
The entity specified in the custom connector as a source in the flow.
Custom properties that are required to use the custom connector as a source.
Defines the configuration for a scheduled incremental data pull. If a valid configuration is provided, the fields specified in the configuration are used when querying for the incremental data pull.
A field that specifies the date time or timestamp field as the criteria to use when importing incremental records from the source.
[REQUIRED]
The configuration that controls how Amazon AppFlow transfers data to the destination connector.
Contains information about the configuration of destination connectors present in the flow.
The type of connector, such as Salesforce, Amplitude, and so on.
The API version that the destination connector uses.
The name of the connector profile. This name must be unique for each connector profile in the Amazon Web Services account.
This stores the information that is required to query a particular connector.
The properties required to query Amazon Redshift.
The object specified in the Amazon Redshift flow destination.
The intermediate bucket that Amazon AppFlow uses when moving data into Amazon Redshift.
The object key for the bucket in which Amazon AppFlow places the destination files.
The settings that determine how Amazon AppFlow handles an error when placing data in the Amazon Redshift destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The properties required to query Amazon S3.
The Amazon S3 bucket name in which Amazon AppFlow places the transferred data.
The object key for the destination bucket in which Amazon AppFlow places the files.
The configuration that determines how Amazon AppFlow should format the flow output data when Amazon S3 is used as the destination.
Indicates the file type that Amazon AppFlow places in the Amazon S3 bucket.
Determines the prefix that Amazon AppFlow applies to the folder name in the Amazon S3 bucket. You can name folders according to the flow frequency and date.
Determines the format of the prefix, and whether it applies to the file name, file path, or both.
Determines the level of granularity for the date and time that's included in the prefix.
Specifies whether the destination file path includes either or both of the following elements:
EXECUTION_ID
The ID that Amazon AppFlow assigns to the flow run.
SCHEMA_VERSION
The version number of your data schema. Amazon AppFlow assigns this version number. The version number increases by one when you change any of the following settings in your flow configuration:
The aggregation settings that you can use to customize the output format of your flow data.
Specifies whether Amazon AppFlow aggregates the flow records into a single file, or leave them unaggregated.
The desired file size, in MB, for each output file that Amazon AppFlow writes to the flow destination. For each file, Amazon AppFlow attempts to achieve the size that you specify. The actual file sizes might differ from this target based on the number and size of the records that each file contains.
If your file output format is Parquet, use this parameter to set whether Amazon AppFlow preserves the data types in your source data when it writes the output to Amazon S3.
true
: Amazon AppFlow preserves the data types when it writes to Amazon S3. For example, an integer or 1
in your source data is still an integer in your output.false
: Amazon AppFlow converts all of the source data into strings when it writes to Amazon S3. For example, an integer of 1
in your source data becomes the string "1"
in the output.The properties required to query Salesforce.
The object specified in the Salesforce flow destination.
The name of the field that Amazon AppFlow uses as an ID when performing a write operation such as update or delete.
The settings that determine how Amazon AppFlow handles an error when placing data in the Salesforce destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
This specifies the type of write operation to be performed in Salesforce. When the value is UPSERT
, then idFieldNames
is required.
Specifies which Salesforce API is used by Amazon AppFlow when your flow transfers data to Salesforce.
AUTOMATIC
The default. Amazon AppFlow selects which API to use based on the number of records that your flow transfers to Salesforce. If your flow transfers fewer than 1,000 records, Amazon AppFlow uses Salesforce REST API. If your flow transfers 1,000 records or more, Amazon AppFlow uses Salesforce Bulk API 2.0.
Each of these Salesforce APIs structures data differently. If Amazon AppFlow selects the API automatically, be aware that, for recurring flows, the data output might vary from one flow run to the next. For example, if a flow runs daily, it might use REST API on one day to transfer 900 records, and it might use Bulk API 2.0 on the next day to transfer 1,100 records. For each of these flow runs, the respective Salesforce API formats the data differently. Some of the differences include how dates are formatted and null values are represented. Also, Bulk API 2.0 doesn't transfer Salesforce compound fields.
By choosing this option, you optimize flow performance for both small and large data transfers, but the tradeoff is inconsistent formatting in the output.
BULKV2
Amazon AppFlow uses only Salesforce Bulk API 2.0. This API runs asynchronous data transfers, and it's optimal for large sets of data. By choosing this option, you ensure that your flow writes consistent output, but you optimize performance only for large data transfers.
Note that Bulk API 2.0 does not transfer Salesforce compound fields.
REST_SYNC
Amazon AppFlow uses only Salesforce REST API. By choosing this option, you ensure that your flow writes consistent output, but you decrease performance for large data transfers that are better suited for Bulk API 2.0. In some cases, if your flow attempts to transfer a vary large set of data, it might fail with a timed out error.
The properties required to query Snowflake.
The object specified in the Snowflake flow destination.
The intermediate bucket that Amazon AppFlow uses when moving data into Snowflake.
The object key for the destination bucket in which Amazon AppFlow places the files.
The settings that determine how Amazon AppFlow handles an error when placing data in the Snowflake destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The properties required to query Amazon EventBridge.
The object specified in the Amazon EventBridge flow destination.
The settings that determine how Amazon AppFlow handles an error when placing data in the destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The properties required to query Amazon Lookout for Metrics.
The properties required to query Upsolver.
The Upsolver Amazon S3 bucket name in which Amazon AppFlow places the transferred data.
The object key for the destination Upsolver Amazon S3 bucket in which Amazon AppFlow places the files.
The configuration that determines how data is formatted when Upsolver is used as the flow destination.
Indicates the file type that Amazon AppFlow places in the Upsolver Amazon S3 bucket.
Specifies elements that Amazon AppFlow includes in the file and folder names in the flow destination.
Determines the format of the prefix, and whether it applies to the file name, file path, or both.
Determines the level of granularity for the date and time that's included in the prefix.
Specifies whether the destination file path includes either or both of the following elements:
EXECUTION_ID
The ID that Amazon AppFlow assigns to the flow run.
SCHEMA_VERSION
The version number of your data schema. Amazon AppFlow assigns this version number. The version number increases by one when you change any of the following settings in your flow configuration:
The aggregation settings that you can use to customize the output format of your flow data.
Specifies whether Amazon AppFlow aggregates the flow records into a single file, or leave them unaggregated.
The desired file size, in MB, for each output file that Amazon AppFlow writes to the flow destination. For each file, Amazon AppFlow attempts to achieve the size that you specify. The actual file sizes might differ from this target based on the number and size of the records that each file contains.
The properties required to query Amazon Honeycode.
The object specified in the Amazon Honeycode flow destination.
The settings that determine how Amazon AppFlow handles an error when placing data in the destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The properties required to query Amazon Connect Customer Profiles.
The unique name of the Amazon Connect Customer Profiles domain.
The object specified in the Amazon Connect Customer Profiles flow destination.
The properties required to query Zendesk.
The object specified in the Zendesk flow destination.
A list of field names that can be used as an ID field when performing a write operation.
The settings that determine how Amazon AppFlow handles an error when placing data in the destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The possible write operations in the destination connector. When this value is not provided, this defaults to the INSERT
operation.
The properties required to query Marketo.
The object specified in the Marketo flow destination.
The settings that determine how Amazon AppFlow handles an error when placing data in the destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The properties that are required to query the custom Connector.
The entity specified in the custom connector as a destination in the flow.
The settings that determine how Amazon AppFlow handles an error when placing data in the custom connector as destination.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
Specifies the type of write operation to be performed in the custom connector when it's used as destination.
The name of the field that Amazon AppFlow uses as an ID when performing a write operation such as update, delete, or upsert.
The custom properties that are specific to the connector when it's used as a destination in the flow.
The properties required to query SAPOData.
The object path specified in the SAPOData flow destination.
Determines how Amazon AppFlow handles the success response that it gets from the connector after placing data.
For example, this setting would determine where to write the response from a destination connector upon a successful insert operation.
The Amazon S3 bucket prefix.
The name of the Amazon S3 bucket.
A list of field names that can be used as an ID field when performing a write operation.
The settings that determine how Amazon AppFlow handles an error when placing data in the destination. For example, this setting would determine if the flow should fail after one insertion error, or continue and attempt to insert every record regardless of the initial failure. ErrorHandlingConfig
is a part of the destination connector details.
Specifies if the flow should fail after the first instance of a failure when attempting to place data in the destination.
Specifies the Amazon S3 bucket prefix.
Specifies the name of the Amazon S3 bucket.
The possible write operations in the destination connector. When this value is not provided, this defaults to the INSERT
operation.
[REQUIRED]
A list of tasks that Amazon AppFlow performs while transferring the data in the flow run.
A class for modeling different type of tasks. Task implementation varies based on the TaskType
.
The source fields to which a particular task is applied.
The operation to be performed on the provided source fields.
The operation to be performed on the provided Amplitude source fields.
The operation to be performed on the provided Datadog source fields.
The operation to be performed on the provided Dynatrace source fields.
The operation to be performed on the provided Google Analytics source fields.
The operation to be performed on the provided Infor Nexus source fields.
The operation to be performed on the provided Marketo source fields.
The operation to be performed on the provided Amazon S3 source fields.
The operation to be performed on the provided Salesforce source fields.
The operation to be performed on the provided ServiceNow source fields.
The operation to be performed on the provided Singular source fields.
The operation to be performed on the provided Slack source fields.
The operation to be performed on the provided Trend Micro source fields.
The operation to be performed on the provided Veeva source fields.
The operation to be performed on the provided Zendesk source fields.
The operation to be performed on the provided SAPOData source fields.
Operators supported by the custom connector.
A field in a destination connector, or a field value against which Amazon AppFlow validates a source field.
Specifies the particular task implementation that Amazon AppFlow performs.
A map used to store task-related information. The execution service looks for particular information based on the TaskType
.
Specifies the configuration that Amazon AppFlow uses when it catalogs the data that's transferred by the associated flow. When Amazon AppFlow catalogs the data from a flow, it stores metadata in a data catalog.
Specifies the configuration that Amazon AppFlow uses when it catalogs your data with the Glue Data Catalog.
The Amazon Resource Name (ARN) of an IAM role that grants Amazon AppFlow the permissions it needs to create Data Catalog tables, databases, and partitions.
For an example IAM policy that has the required permissions, see Identity-based policy examples for Amazon AppFlow.
The name of the Data Catalog database that stores the metadata tables that Amazon AppFlow creates in your Amazon Web Services account. These tables contain metadata for the data that's transferred by the flow that you configure with this parameter.
Note
When you configure a new flow with this parameter, you must specify an existing database.
A naming prefix for each Data Catalog table that Amazon AppFlow creates for the flow that you configure with this setting. Amazon AppFlow adds the prefix to the beginning of the each table name.
dict
Response Syntax
{
'flowStatus': 'Active'|'Deprecated'|'Deleted'|'Draft'|'Errored'|'Suspended'
}
Response Structure
(dict) --
flowStatus (string) --
Indicates the current status of the flow.
Exceptions
Appflow.Client.exceptions.ValidationException
Appflow.Client.exceptions.ResourceNotFoundException
Appflow.Client.exceptions.ServiceQuotaExceededException
Appflow.Client.exceptions.ConflictException
Appflow.Client.exceptions.ConnectorAuthenticationException
Appflow.Client.exceptions.ConnectorServerException
Appflow.Client.exceptions.InternalServerException
The available paginators are: