MuleSoft Connector for Salesforce Marketing Cloud

Build 20.0.7654

JourneyActivities

Create, update and query journey activities.

Table Specific Information

Select

Retrieve journey activities for the latest version of the specified journey:

SELECT * FROM JourneyActivities WHERE JourneyId='1cb643b5-3144-4d17-80fa-a1f0035e78e2'

Retrieve journey activities for a specific journey version:

SELECT * FROM JourneyActivities WHERE JourneyId='1cb643b5-3144-4d17-80fa-a1f0035e78e2' AND JourneyVersion=1

Retrieve journey activities from all journeys with a specific version:

SELECT * FROM JourneyActivities WHERE JourneyVersion=1

Insert

To create a new journey activity, you will need to specify at least the JourneyId, JourneyVersion, Type, Key, Arguments, ConfigurationArguments column.

INSERT INTO JourneyActivities(JourneyId,JourneyVersion,Type,Key,Arguments,ConfigurationArguments) VALUES('4753026f-20b2-481b-89c5-fcd76ffa41f7',1,'WAIT','WAITBYDURATION-1','{
  "waitEndDateAttributeDataBound": "",
  "waitDefinitionId": "f3de0c9a-5ff8-4f7b-84bd-9309ca337227",
  "waitForEventId": "",
  "executionMode": "{{Context.ExecutionMode}}",
  "startActivityKey": "{{Context.StartActivityKey}}",
  "waitQueueId": "{{Context.WaitQueueId}}"
}','{
  "waitDuration": 1,
  "waitUnit": "DAYS",
  "specifiedTime": "",
  "timeZone": "",
  "description": "",
  "waitEndDateAttributeExpression": "",
  "specificDate": "",
  "waitForEventKey": ""
}')

Update

Journey activities may be modified by providing the Id, JourneyId, JourneyVersion and issuing an UPDATE statement.

Update JourneyActivities SET Description='First_Journey_Activity_Description', Outcomes='[
  {
    "key": "11bb2807-3f3d-4305-af51-547df032dbaf",
    "next": "WAITBYDURATION-1",
    "arguments": null,
    "metaData": null
  }
]' WHERE Id='fa4c3d81-8043-40e2-9741-22708d3a2e25' AND  JourneyId='4753026f-20b2-481b-89c5-fcd76ffa41f7' AND JourneyVersion=1

Columns

Name Type ReadOnly References Filters Description
Id [KEY] String True

This is the Marketing Cloud-provided unique ID for this particular activity.

JourneyId [KEY] String True

Journeys.Id

=

A unique identifier for this journey that is generated and assigned by the journey API during creation.

JourneyVersion [KEY] Integer True

Journeys.Version

=

This number denotes the iteration of this particular journey.

Key String False

This is the customer key (journey-unique) for this particular activity.

Name String False

This is the display name for this activity, it will be shown in the Journey Builder UI.

Description String False

This is the description for this activity.

Type String False

This property defines what type of activity this is. The expected input for each activity must be passed as an argument to operate correctly.

Outcomes String False

This is a json array of 'outcome' objects.

Arguments String False

This is an object which represents the arguments this particular activity expects to be passed for use at runtime. Each activity type has its own unique argument parameters which are expected.

ConfigurationArguments String False

This is an object which represents the arguments this particular activity expects to be passed for use both at publish and runtime. Each activity type has its own unique argument parameters which are expected.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654