thank you @_Manoj_Kumar_ .  can you give direction code snippet to use the keys in email so it can pull up the respective value in email while sending? 

I've a requirement to sync values from JSON API into ACC. The Json contains key with value pairs. I want to sync this periodically. how do I go about it? i'm thinking once i've the key value pair in ACC, i can use personlization blocks to pick up the key value pair into email at the time of delivery...

I'm looking to download CSV data (CSV) behind the Adobe Campaign Standard report(by campaign, aggregate click, open, send). Is there a way to achieve that? Additionally, i see reference to nms:trackingStats table but this seems to be not accessible via "Query" in ACS. https://experienceleague.adobe....

Thanks, In the enrichment activity, i would assume i will take the primary set as "load file" ( this has got the main data to be ingested), now, i'm looking to include the output from reconciliation as an additional element before passing the enriched data set to "update' activity. However, I can on...

When I save the asset metadata update screen,  the interface shows this error message "Unable to create new tags. Check for access privileges to create tags." I'm the admin on the platform and no new tags being added.  Platform: AEM Asset Cloud.

Is there a way to pass "additional data" (Similar to Query-> additional data) to reconciliation activity when Load File from FTP.  Here is my Technical workflow. Load File->Reconciliation -> Update Data.  The reason i'm looking for additional data because the input file do not have the data attribut...

Thanks John, the instruction is very clear and it worked. Thanks a ton for your help!!

thanks John. I tried to run this and resulted in the following error in the "UPDATE" activity. The 'key' identification type chosen is not compatible with the configuration of the reconciliation keys (step '')

Thanks John. I'm yet to try this. The additional field added to the first query (orguint2) to be reconciled with orgunit table as well (inside reconcile activity)?  otherwise we are assigning the text value right? 

thanks for the reply John. let me clarify the requirement . Let's say Profile A is set to orgunit value="orgunit 1", i would like to  update profile's org unit value to "orgunit2". Both org units are defined under admin/security/org units.  I've a query to fetch profile A, going into reconcile activ...