Adf Lookup Activity Element
X-Ref:
- Ast Adf Lookup Activity Node
- Ast Adf Execution Activity Base Node
- Ast Adf Activity Base Node
- Ast Scope Boundary Node
Attributes
| Attribute | API Type | Default | Description |
|---|---|---|---|
| Name | String | Specifies the name of the object. This name can be used to reference this object from anywhere else in the program. This is a required property | |
| FirstRowOnly | Boolean | True | Determines whether every row is returned or only the first row. If not specified, then the default value is "true". |
| Retry | Int32 | -1 | Number of retry attempts. |
| RetryInterval | Int32 | 30 | Specifies the time in seconds between retry attempts. Range between 30 and 86400 with 30 being the default. |
| SecureInput | Boolean | False | Specify whether the input from the activity is sensitive and should not be logged to monitoring. |
| SecureOutput | Boolean | False | Specify whether the input from the activity is sensitive and should not be logged to monitoring |
| Timeout | String | "7" | Timeout for the activity to run. Defaults to 7 days. |
Singleton Children
| Child | API Type | Description |
|---|---|---|
| <AmazonMarketplaceWebServiceSource /> | AstAdfAmazonMarketplaceWebServiceSourceNode | AstAdfAmazonMarketplaceWebServiceSourceNode objects correspond directly to Copy Activity sources for Amazon Marketplace Web Service datasets in Azure Data Factory. This is a required property |
| <AmazonRedshiftSource /> | AstAdfAmazonRedshiftSourceNode | AstAdfAmazonRedshiftSourceNode objects correspond directly to Copy Activity sources for AmazonRedshift datasets in Azure Data Factory. This is a required property |
| <AmazonS3Source /> | AstAdfAmazonS3SourceNode | AstAdfAmazonS3SourceNode objects correspond directly to Copy Activity sources for AmazonS3 datasets in Azure Data Factory. This is a required property |
| <AzureBlobSource /> | AstAdfAzureBlobSourceNode | AstAdfAzureBlobSourceNode objects correspond directly to Copy Activity sources for AzureBlob datasets in Azure Data Factory. This is a required property |
| <AzureCosmosDbSource /> | AstAdfAzureCosmosDbSourceNode | AstAdfAzureCosmosDbSourceNode objects correspond directly to Copy Activity sources for AzureCosmosDb datasets in Azure Data Factory. This is a required property |
| <AzureCosmosDbMongoDbSource /> | AstAdfAzureCosmosDbMongoDbSourceNode | AstAdfAzureCosmosDbMongoDbSourceNode objects correspond directly to Copy Activity sources for AzureCosmosDb MongoDb datasets in Azure Data Factory. This is a required property |
| <AzureDataLakeGen1Source /> | AstAdfAzureDataLakeGen1SourceNode | AstAdfAzureDataLakeSourceNode objects correspond directly to Copy Activity sources for AzureDataLake datasets in Azure Data Factory. This is a required property |
| <AzureDataLakeGen2Source /> | AstAdfAzureDataLakeGen2SourceNode | AstAdfAzureDataLakeSourceNode objects correspond directly to Copy Activity sources for AzureDataLake datasets in Azure Data Factory. This is a required property |
| <AzureDataExplorerSource /> | AstAdfAzureDataExplorerSourceNode | AstAdfAzureDataExplorerSourceNode objects correspond directly to Copy Activity sources for DataExplorer datasets in Azure Data Factory. This is a required property |
| <AzureFileStorageSource /> | AstAdfAzureFileStorageSourceNode | AstAdfAzureFileStorageSourceNode objects correspond directly to Copy Activity sources for Azure File Storage datasets in Azure Data Factory. This is a required property |
| <AzureMySqlSource /> | AstAdfAzureMySqlSourceNode | AstAdfAzureMySqlSourceNode objects correspond directly to Copy Activity sources for AzureMySql datasets in Azure Data Factory. This is a required property |
| <AzurePostgreSqlSource /> | AstAdfAzurePostgreSqlSourceNode | AstAdfAzurePostgreSqlSourceNode objects correspond directly to Copy Activity sources for AzurePostgreSql datasets in Azure Data Factory. This is a required property |
| <AzureSqlDatabaseSource /> | AstAdfAzureSqlDatabaseSourceNode | AstAdfAzureSqlDatabaseSourceNode objects correspond directly to Copy Activity sources for AzureSqlDatabase datasets in Azure Data Factory. This is a required property |
| <AzureSqlDataWarehouseSource /> | AstAdfAzureSqlDataWarehouseSourceNode | AstAdfAzureSqlDataWarehouseSourceNode objects correspond directly to Copy Activity sources for AzureSqlDataWarehouse datasets in Azure Data Factory. This is a required property |
| <AzureSqlMiSource /> | AstAdfAzureSqlMiSourceNode | AstAdfAzureSqlMiSourceNode objects correspond directly to Copy Activity sources for AzureSqlMi datasets in Azure Data Factory. This is a required property |
| <AzureTableSource /> | AstAdfAzureTableSourceNode | AstAdfAzureTableSourceNode objects correspond directly to Copy Activity sources for AzureTable datasets in Azure Data Factory. This is a required property |
| <CassandraSource /> | AstAdfCassandraSourceNode | AstAdfCassandraSourceNode objects correspond directly to Copy Activity sources for Cassandra datasets in Azure Data Factory. This is a required property |
| <ConcurSource /> | AstAdfConcurSourceNode | AstAdfConcurSourceNode objects correspond directly to Copy Activity sources for Concur datasets in Azure Data Factory. This is a required property |
| <CommonDataServiceForAppsSource /> | AstAdfCommonDataServiceForAppsSourceNode | AstAdfCommonDataServiceForAppsSourceNode objects correspond directly to Copy Activity sources for Common Data Service For Apps datasets in Azure Data Factory. This is a required property |
| <CouchbaseSource /> | AstAdfCouchbaseSourceNode | AstAdfCouchbaseSourceNode objects correspond directly to Copy Activity sources for Couchbase datasets in Azure Data Factory. This is a required property |
| <Db2Source /> | AstAdfDb2SourceNode | AstAdfDb2SourceNode objects correspond directly to Copy Activity sources for Db2 datasets in Azure Data Factory. This is a required property |
| <DrillSource /> | AstAdfDrillSourceNode | AstAdfDrillSourceNode objects correspond directly to Copy Activity sources for Drill datasets in Azure Data Factory. This is a required property |
| <DynamicsCrmSource /> | AstAdfDynamicsCrmSourceNode | AstAdfDynamicsCrmSourceNode objects correspond directly to Copy Activity sources for DynamicsCrm datasets in Azure Data Factory. This is a required property |
| <DynamicsAxSource /> | AstAdfDynamicsAxSourceNode | AstAdfDynamicsAxSourceNode objects correspond directly to Copy Activity sources for DynamicsAx datasets in Azure Data Factory. This is a required property |
| <EloquaSource /> | AstAdfEloquaSourceNode | AstAdfEloquaSourceNode objects correspond directly to Copy Activity sources for Oracle Eloqua datasets in Azure Data Factory. This is a required property |
| <FileShareSource /> | AstAdfFileShareSourceNode | AstAdfFileShareSourceNode objects correspond directly to Copy Activity sources for FileShare datasets in Azure Data Factory. This is a required property |
| <FtpSource /> | AstAdfFtpSourceNode | AstAdfFtpSourceNode objects correspond directly to Copy Activity sources for Ftp datasets in Azure Data Factory. This is a required property |
| <GoogleBigQuerySource /> | AstAdfGoogleBigQuerySourceNode | AstAdfGoogleBigQuerySourceNode objects correspond directly to Copy Activity sources for GoogleBigQuery datasets in Azure Data Factory. This is a required property |
| <GoogleAdWordsSource /> | AstAdfGoogleAdWordsSourceNode | AstAdfGoogleAdWordsSourceNode objects correspond directly to Copy Activity sources for GoogleAdWords datasets in Azure Data Factory. This is a required property |
| <GoogleCloudStorageSource /> | AstAdfGoogleCloudStorageSourceNode | AstAdfGoogleCloudStorageSourceNode objects correspond directly to Copy Activity sources for Google Cloud Storage datasets in Azure Data Factory. This is a required property |
| <GreenplumSource /> | AstAdfGreenplumSourceNode | AstAdfGreenplumSourceNode objects correspond directly to Copy Activity sources for Greenplum datasets in Azure Data Factory. This is a required property |
| <HBaseSource /> | AstAdfHBaseSourceNode | AstAdfHBaseSourceNode objects correspond directly to Copy Activity sources for HBase datasets in Azure Data Factory. This is a required property |
| <HiveSource /> | AstAdfHiveSourceNode | AstAdfHiveSourceNode objects correspond directly to Copy Activity sources for Hive datasets in Azure Data Factory. This is a required property |
| <HttpSource /> | AstAdfHttpSourceNode | AstAdfHttpSourceNode objects correspond directly to Copy Activity sources for Http datasets in Azure Data Factory. This is a required property |
| <HubspotSource /> | AstAdfHubspotSourceNode | AstAdfHubspotSourceNode objects correspond directly to Copy Activity sources for HubSpot datasets in Azure Data Factory. This is a required property |
| <InformixSource /> | AstAdfInformixSourceNode | AstAdfInformixSourceNode objects correspond directly to Copy Activity sources for Informix datasets in Azure Data Factory. This is a required property |
| <ImpalaSource /> | AstAdfImpalaSourceNode | AstAdfImpalaSourceNode objects correspond directly to Copy Activity sources for Impala datasets in Azure Data Factory. This is a required property |
| <JiraSource /> | AstAdfJiraSourceNode | AstAdfJiraSourceNode objects correspond directly to Copy Activity sources for Jira datasets in Azure Data Factory. This is a required property |
| <MagentoSource /> | AstAdfMagentoSourceNode | AstAdfMagentoSourceNode objects correspond directly to Copy Activity sources for Magento datasets in Azure Data Factory. This is a required property |
| <MariaDbSource /> | AstAdfMariaDbSourceNode | AstAdfMariaDbSourceNode objects correspond directly to Copy Activity sources for MariaDb datasets in Azure Data Factory. This is a required property |
| <MarketoSource /> | AstAdfMarketoSourceNode | AstAdfMarketoSourceNode objects correspond directly to Copy Activity sources for Marketo datasets in Azure Data Factory. This is a required property |
| <MicrosoftAccessSource /> | AstAdfMicrosoftAccessSourceNode | AstAdfMicrosoftAccessSourceNode objects correspond directly to Copy Activity sources for MicrosoftAccess datasets in Azure Data Factory. This is a required property |
| <MongoDbSource /> | AstAdfMongoDbSourceNode | AstAdfMongoDbSourceNode objects correspond directly to Copy Activity sources for MongoDb datasets in Azure Data Factory. This is a required property |
| <MongoDbV2Source /> | AstAdfMongoDbV2SourceNode | AstAdfMongoDbV2SourceNode objects correspond directly to Copy Activity sources for MongoDb datasets in Azure Data Factory. This is a required property |
| <MySqlSource /> | AstAdfMySqlSourceNode | AstAdfMySqlSourceNode objects correspond directly to Copy Activity sources for MySql datasets in Azure Data Factory. This is a required property |
| <NetezzaSource /> | AstAdfNetezzaSourceNode | AstAdfNetezzaSourceNode objects correspond directly to Copy Activity sources for Netezza datasets in Azure Data Factory. This is a required property |
| <ODataSource /> | AstAdfODataSourceNode | AstAdfODataSourceNode objects correspond directly to Copy Activity sources for OData datasets in Azure Data Factory. This is a required property |
| <OdbcSource /> | AstAdfOdbcSourceNode | AstAdfOdbcSourceNode objects correspond directly to Copy Activity sources for Odbc datasets in Azure Data Factory. This is a required property |
| <Office365Source /> | AstAdfOffice365SourceNode | |
| <OracleSource /> | AstAdfOracleSourceNode | AstAdfOracleSourceNode objects correspond directly to Copy Activity sources for Oracle datasets in Azure Data Factory. This is a required property |
| <OracleServiceCloudSource /> | AstAdfOracleServiceCloudSourceNode | AstAdfOracleServiceCloudSourceNode objects correspond directly to Copy Activity sources for OracleServiceCloud datasets in Azure Data Factory. This is a required property |
| <PaypalSource /> | AstAdfPaypalSourceNode | AstAdfPaypalSourceNode objects correspond directly to Copy Activity sources for Paypal datasets in Azure Data Factory. This is a required property |
| <PhoenixSource /> | AstAdfPhoenixSourceNode | AstAdfPhoenixSourceNode objects correspond directly to Copy Activity sources for Phoenix datasets in Azure Data Factory. This is a required property |
| <PostgreSqlSource /> | AstAdfPostgreSqlSourceNode | AstAdfPostgreSqlSourceNode objects correspond directly to Copy Activity sources for PostgreSql datasets in Azure Data Factory. This is a required property |
| <PrestoSource /> | AstAdfPrestoSourceNode | AstAdfPrestoSourceNode objects correspond directly to Copy Activity sources for Presto datasets in Azure Data Factory. This is a required property |
| <QuickBooksSource /> | AstAdfQuickBooksSourceNode | AstAdfQuickBooksSourceNode objects correspond directly to Copy Activity sources for QuickBooks datasets in Azure Data Factory. This is a required property |
| <ResponsysSource /> | AstAdfResponsysSourceNode | AstAdfResponsysSourceNode objects correspond directly to Copy Activity sources for Oracle Responsys datasets in Azure Data Factory. This is a required property |
| <RestSource /> | AstAdfRestSourceNode | AstAdfRestSourceNode objects correspond directly to Copy Activity sources for Rest datasets in Azure Data Factory. This is a required property |
| <SalesforceSource /> | AstAdfSalesforceSourceNode | AstAdfSalesforceSourceNode objects correspond directly to Copy Activity sources for Salesforce datasets in Azure Data Factory. This is a required property |
| <SalesforceServiceCloudSource /> | AstAdfSalesforceServiceCloudSourceNode | AstAdfSalesforceServiceCloudSourceNode objects correspond directly to Copy Activity sources for Salesforce ServiceCloud datasets in Azure Data Factory. This is a required property |
| <SalesforceMarketingCloudSource /> | AstAdfSalesforceMarketingCloudSourceNode | AstAdfSalesforceMarketingCloudSourceNode objects correspond directly to Copy Activity sources for Salesforce Marketing Cloud datasets in Azure Data Factory. This is a required property |
| <SapBusinessWarehouseSource /> | AstAdfSapBusinessWarehouseSourceNode | AstAdfSapBusinessWarehouseSourceNode objects correspond directly to Copy Activity sources for SapBusinessWarehouse datasets in Azure Data Factory. This is a required property |
| <SapCloudForCustomerSource /> | AstAdfSapCloudForCustomerSourceNode | AstAdfSapCloudForCustomerSourceNode objects correspond directly to Copy Activity sources for SapCloudForCustomer datasets in Azure Data Factory. This is a required property |
| <SapEccSource /> | AstAdfSapEccSourceNode | AstAdfSapEccSourceNode objects correspond directly to Copy Activity sources for SapEcc datasets in Azure Data Factory. This is a required property |
| <SapHanaSource /> | AstAdfSapHanaSourceNode | AstAdfSapHanaSourceNode objects correspond directly to Copy Activity sources for SapHana datasets in Azure Data Factory. This is a required property |
| <SapOpenHubSource /> | AstAdfSapOpenHubSourceNode | |
| <SapTableSource /> | AstAdfSapTableSourceNode | |
| <ServiceNowSource /> | AstAdfServiceNowSourceNode | AstAdfServiceNowSourceNode objects correspond directly to Copy Activity sources for ServiceNow datasets in Azure Data Factory. This is a required property |
| <SftpSource /> | AstAdfSftpSourceNode | AstAdfSftpSourceNode objects correspond directly to Copy Activity sources for Sftp datasets in Azure Data Factory. This is a required property |
| <SharePointOnlineList /> | AstAdfSharePointOnlineListSourceNode | AstAdfSharePointOnlineListSourceNode objects correspond directly to Copy Activity sources for Salesforce ServiceCloud datasets in Azure Data Factory. This is a required property |
| <ShopifySource /> | AstAdfShopifySourceNode | AstAdfShopifySourceNode objects correspond directly to Copy Activity sources for Shopify datasets in Azure Data Factory. This is a required property |
| <SnowflakeSource /> | AstAdfSnowflakeSourceNode | AstAdfSnowflakeSourceNode objects correspond directly to Copy Activity sources for Snowflake datasets in Azure Data Factory. This is a required property |
| <SparkSource /> | AstAdfSparkSourceNode | AstAdfSparkSourceNode objects correspond directly to Copy Activity sources for Spark datasets in Azure Data Factory. This is a required property |
| <SqlServerSource /> | AstAdfSqlServerSourceNode | AstAdfSqlServerSourceNode objects correspond directly to Copy Activity sources for SqlServer datasets in Azure Data Factory. This is a required property |
| <SquareSource /> | AstAdfSquareSourceNode | AstAdfSquareSourceNode objects correspond directly to Copy Activity sources for Square datasets in Azure Data Factory. This is a required property |
| <SybaseSource /> | AstAdfSybaseSourceNode | AstAdfSybaseSourceNode objects correspond directly to Copy Activity sources for Sybase datasets in Azure Data Factory. This is a required property |
| <TeradataSource /> | AstAdfTeradataSourceNode | AstAdfTeradataSourceNode objects correspond directly to Copy Activity sources for Teradata datasets in Azure Data Factory. This is a required property |
| <VerticaSource /> | AstAdfVerticaSourceNode | AstAdfVerticaSourceNode objects correspond directly to Copy Activity sources for Vertica datasets in Azure Data Factory. This is a required property |
| <WebTableSource /> | AstAdfWebTableSourceNode | AstAdfWebTableSourceNode objects correspond directly to Copy Activity sources for WebTable datasets in Azure Data Factory. This is a required property |
| <XeroSource /> | AstAdfXeroSourceNode | AstAdfXeroSourceNode objects correspond directly to Copy Activity sources for Xero datasets in Azure Data Factory. This is a required property |
| <ZohoSource /> | AstAdfZohoSourceNode | AstAdfZohoSourceNode objects correspond directly to Copy Activity sources for Zoho datasets in Azure Data Factory. This is a required property |
| <Description /> | String | String is the .NET Framework String class. More information can be found at http://msdn.microsoft.com/en-us/library/system.string.aspx. |
| <Scheduler /> | AstAdfActivityScheduleNode | AstAdfActivityScheduleNode objects correspond directly to scheduler specifications for activities in Azure Data Factory. |
Collection Children
| Child | API Type | Description |
|---|---|---|
| <Annotations> <Annotation /> </Annotations> | AstAnnotationNode | This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code. |
| <Dependencies> <Dependency /> </Dependencies> | AstAdfActivityDependencyNode | This is the collection of activity dependencies that will control the execution of this Azure Data Factory activity. |
| <PipelineParameters> <Parameter /> </PipelineParameters> | AstAdfPipelineParameterNode | This is the collection of parameters that will be available to expressions in this Azure Data Factory activity. These parameters will be promoted automatically to the parent pipeline. |
| <UserProperties> <UserProperty /> </UserProperties> | AstAdfActivityUserPropertyNode | This is the collection of user properties that the user can monitor in the Adf monitor window. |