Skip to main content

Ingest from ServiceNow (via Basic Auth) as Parquet

Copy data from ServiceNow using Basic Authentication to Parquet format in Azure Data Lake Storage Gen2.

To use this activity within the API, use an ActivityCode of SERVICENOW-BASIC-ADLS.

Example JSON​

An example of what the Task Config would look like for a task using this activity. Some of these variables would be set at the group level to avoid duplication between tasks.

NULL

Variable Reference​

The following variables are supported:

  • SourceConnection - (Required) Source connection to use.

  • ServiceNowTable - (Required) The name of the ServiceNow table to extract.

  • FilteringQuery - (Optional) The JSON struct that defines the filtering criteria to apply.

  • TargetConnection - (Optional) Target connection to use.

  • DataLakeSystemFolder - (Required) Name of the folder in the Data Lake that acts as the parent folder for all datasets belonging to this System.

  • DataLakeDatasetFolder - (Required) Name of the folder in the Data Lake that the dataset will be stored under. Used with 'Data Lake System Folder' to form the fully qualified path to the dataset within the data Container in the Data Lake.

  • ElevateToDelta - (Optional) Ingest directly to Lakehouse Table

  • DeltaSchemaName - (Optional) The name of the Schema this transformation lives in. Required if Copy to Lakehouse Table is enabled.

  • DeltaTableName - (Optional) The name of the Lakehouse Table representing this transformation. Required if Copy to Lakehouse Table is enabled.

  • ServiceNowPageSize - (Optional) The page size of the ServiceNow resultset.

  • ExtractControlVariableName - (Optional) For incremental loads only, the name to assign the Extract Control variable in State Config for the ExtractControl value derived from the Extract Control Query above.

  • ExtractControlVariableSeedValue - (Optional) The initial value to set for the Extract Control variable in State Config - this will have no impact beyond the original seeding of the Extract Control variable in State Config.