How to fetch Journey Name, Journey Status and created by Details

[HardikJa3]

How to fetch Journey Name, Journey Status (Live, Draft, Closed, Dry Run etc) and created by (Person name) Details using either query service or via API. 

I know the status and created by are not available in any dataset but is there any way I can download or fetch these values for all the journeys in my sandbox ?

[Mohan_Dugganab · Accepted solution]

You can query journeys dataset and status, created by are not available in the current state (as you have already mentioned)

[HardikJa3]

Hii @Mohan_Dugganab Journey Status is available in which dataset ?

[Mohan_Dugganab]

Journey status is currently not available

[HardikJa3]

Is there any way I can fetch Journey Name, Status and created by details from a Sandbox ? @Mohan_Dugganab 

[Mohan_Dugganab]

Not in the current state (with respect to all the three attributes). Kindly log an enhancement request for this.

[HardikJa3]

Hi @Mohan_Dugganab Is there anyway we can do so using APIs ? If yes, can you please share the API details ?

[DavidKangni]

@HardikJa3 

run this query

select * from JOJourneyVersionsDsTest

if it's returned data then you have access to the journeys metadata table and you can find the details there.

Thanks,

David

[Mohan_Dugganab]

I would avoid using it as it is an internal dataset and not publicly available and can be changed any time breaking any integrations built on top of it. https://experienceleaguecommunities.adobe.com/t5/journey-optimizer-questions/query-the-journey-prope... 

[HardikJa3]

Hi @DavidKangni I tried running this query but I only got 17 journey names in result, meanwhile my sandbox has overall 800 journeys (100 live). Is there anyway I can get details of all 800 journeys (Journey Name, Status, Created By)

cc: @Mohan_Dugganab 

[DavidKangni]

@HardikJa3 

As mentioned by @Mohan_Dugganab , this table is not publicly available and you should avoid to use my approach to solve your requirement.

Just a friendly reminder that some of the advisors may have access to Beta Program to provide feedback on LA features and also you may have limitation based on your licensing entitlements.

I will suggest to log an enhancement request.
Thanks,

David

[Ivan_Mironchuk]

@HardikJa3 Have you tried using the AI assistant to get some of this information? 

[HardikJa3]

Hi @Ivan_Mironchuk  AI Assistant is not enabled at my Sandbox.

[Ivan_Mironchuk]

@HardikJa3 separately - we are working to expose "READ" APIs for Journeys. 

To confirm what you are looking for: 

• Get Journey details by CREATOR
• Get Journey details for Journey using JOURNEY NAME
• Get Journey status for Journey using Journey Name or Journey ID

Is that correct? 

[HardikJa3]

Hey @Ivan_Mironchuk Yes, I am looking to fetch these 3 details (Name, Status, Created By) for all the journeys in my Sandbox.

[HardikJa3]

Hi @Ivan_Mironchuk Were you able to find any API that can help me with this ?

[Silvio6]

Hi @HardikJa3 were you able to do this? I'm looking for same solution.