Are there API calls that will return a Journey name given a journey version ID?

[rick_j_alexander]

We are receiving error messages in the Email Feedback and Tracking datasets and need to notify the Canvas Developers which journeys are receiving the errors. The Email Feedback and Tracking datasets contain the Journey Version ID. We need a way to make a call to Adobe to return the name of the journey using the Journey Version ID.

[dugganab · Accepted solution]

No, we don't have these API's currently. This information can be retrieved by querying journeys system dataset

[DavidKangni]

@rick_j_alexander 

you can use this query as example and adding journey version Id in the criteria

SELECT
  AE._experience.customerJourneyManagement.entities.journey.journeyActionName,
  AE._experience.customerJourneyManagement.entities.journey.journeyActionID,
  AE._experience.customerJourneyManagement.entities.journey.journeyVersionID,
  AE._experience.customerJourneyManagement.entities.channelDetails.email.subject,
    JE._EXPERIENCE.JOURNEYORCHESTRATION.STEPEVENTS.PROFILEID,
    JE._EXPERIENCE.JOURNEYORCHESTRATION.STEPEVENTS.journeyVersionName
from
  ajo_entity_dataset AE
  INNER JOIN ajo_message_feedback_event_dataset MF
    ON AE._experience.customerJourneyManagement.entities.channelDetails.messageID = MF._experience.customerJourneyManagement.messageExecution.messageID
    INNER JOIN journey_step_events JE
    ON AE._experience.customerJourneyManagement.entities.journey.journeyActionID = JE._experience.journeyOrchestration.stepEvents.actionID
WHERE
  AE._experience.customerJourneyManagement.entities.channelDetails.channel._id = 'https://ns.adobe.com/xdm/channels/email'
  AND MF._experience.customerJourneyManagement.messageDeliveryfeedback.feedbackStatus <> 'sent'
  AND AE._experience.customerJourneyManagement.entities.journey.journeyVersionID IS NOT NULL

Thanks,

David