How to fetch dynamic variable from AC db , when AEM webpage accessed from url provided in email collateral

[Prady12]

Hi ,
I am facing one issue ,Can you check and please let me know how we can implement this :

I have a requirement where we want to retrieve a dynamic variable from an Adobe Campaign (AC) database when an Adobe Experience Manager (AEM) webpage is accessed from a URL embedded in an email collateral. 
The challenge here is to fetch the dynamic variable whenever a user accesses an AEM webpage by clicking on a URL provided in an email collateral from the AC database in real-time.

Any guidance or suggestions that you could provide in this matter would be greatly appreciated.

Thanks!!!

@aanchal-sikka @arunpatidar @markus_bulla_adobe @ParthaSarathy @Jonathon_wodnicki @_Manoj_Kumar_ @Marcel_Szimonisz @david--garcia 

[arunpatidar]

Hi @Prady12 

To incorporate those dynamic values, consider adding them as query parameters to the URL, much like the campaign query parameter.

If you wish to access these values in real-time, you might need to explore an alternative approach. For instance, you could pass an ID in the URL. Upon the user's arrival on the AEM webpage, initiate an API call to retrieve the actual values from AC. I'm not entirely certain if this is feasible, as I'm not an AC expert.

[Prady12]

Thanks Arun, I will try to look at the feasibility of your suggested approach.

[kautuk_sahni]

@Prady12 Did you find the suggestions from users helpful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. If you have found out solution yourself, please share it with the community.

[Prady12]

Not yet implemented, it would take time analyze the feasibility of this approach.