Property description
The pipelineActivities asset adds individual custom SQL operations to an existing pipeline defined in another package.
Minimal JSON
{
"key": "",
"name": "",
"type": "",
"pipelineKey": "",
"executionOrderNumber": "",
"statement": ""
}{
"key":"example_additionalActivity_updateUser",
"name":"Example Additional Activity (Update User)",
"type":"sql_script",
//options:ctrl+space"pipelineKey":"packageKey_example_pipeline",
"executionOrderNumber":20,
"statement":"UPDATE R_User_Object SET User_Id = JSON_VALUE('__@JSON__', '$.TriggerValue.Context_CreatorId') WHERE Object_Id = JSON_VALUE('__@JSON__', '$.ObjectId')"
}Example can be used for callDataFactory automation action.
Nested properties
| Property | Description | Values | Mandatory |
|---|---|---|---|
key | Unique key of the asset. Used for referencing in the same package or other packages using packageKey#assetKey. | string | Yes |
name | Name of the asset, used as the default EN translation. | string | Yes |
type | Type of the activity. Supported options are: sql_procedure: Executes a stored procedure., sql_query: Runs a single SQL query., sql_script: Executes a full SQL script. | string | Yes |
pipelineKey | Key of the pipeline to which the activities are added. | string | Yes |
executionOrderNumber | Execution order of the activity within the pipeline. | integer | Yes |
statement | SQL procedure, script, or query to be executed. | string | Yes |
description | Description of the asset. | string | No |
isReturningData | Indicates if data is expected. Differentiates between result-producing queries (e.g., SELECT) and action queries (e.g., INSERT, UPDATE, DELETE). | boolean | No |
parameters | Input parameters. | string | No |
runInTransaction | Determines whether the statements execute within a transaction. | boolean | No |