TransWikia.com

Get Journey ID of SMS send using ampscript

Salesforce Asked by MC Learner on November 30, 2021

I need to get the journey ID from SMS send so I created a code that should get the SendJobId

set @jobid = AttributeValue('SendJobID')

However I cannot retrieve any values. I was hoping to get the SendJobID to use it to get the journeyID using the code below:

IF NOT (empty(@jobid)) THEN
set @tsdid = Lookup("_Job", "TriggererSendDefinitionObjectID", "JobID", @jobid)
set @version_id = Lookup("_JourneyActivity", "VersionID", "JourneyActivityObjectID", @tsdid)
set @journey_id = Lookup("_Journey", "JourneyID", "VersionID", @version_id)
set @journeyName = Lookup("_Journey", "JourneyName", "VersionID", @version_id)
set @campaignID = @journey_id
ENDIF

My question is can I get the SendJobId using AttributeValue syntax? If yes, what might be the cause that I only get a null value.

One Answer

Try to query _smsmessagetracking data view, some of the available fields are: CampaignID, ConversationID, CodeID.

Answered by Willem Ruys on November 30, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP