Skip to main content
Level 3
Oct 30, 2026 7:35 PM UTC
Question

Retrieving List Contents and Metadata

What is the best way to retrieve the list contents and the list metadata (list label, internal name, type etc.) via a workflow? I know we can query both individually - nms:group has the list metadata and wen can simply do a Read List to read the list contents. How to append the List metadata to the contents - without manually adding a join key? For instance, if I am reading 5 lists, I don’t want to manually enter a segment code or introduce a manual join key.  

3 replies

Nolan_Chabert
Adobe Employee
Adobe Employee
Nov 1, 2026 9:44 PM UTC

Hi ​@rntrp ,

For standard recipient lists, use Campaign’s existing list-membership relationship rather than merge five Read List outputs and add segment codes.

The metadata is in nms:group, and the NmsRcpGrpRel relationship table already associates recipient IDs with group IDs.

The approach is:

  1. Query the recipient-to-group relationship through the schema links available in your instance.
  2. Filter the linked groups to your five lists.
  3. Include recipient fields and the linked group’s ID, label, internal name and required metadata as additional data.

Keep one row per recipient/list pair. If someone belongs to two selected lists, you need two rows to preserve both associations. Deduplicating on recipient ID would lose that information.

This uses existing keys, not a manually introduced join key.

The distinction is the list type: this works for recipient lists backed by that relationship. For file-type lists or lists based on another schema, you would need to carry the actual list ID programmatically when reading each list, then enrich against nms:group before combining the results.

References:

Regards,
Nolan

Translate
rntrpAuthor
Level 3
Nov 2, 2026 2:17 PM UTC

Thanks ​@Nolan_Chabert 

To clarify a few things about my question:

  1. I am referring to file-type lists, not recipient lists. 
  2. As a result, I do have the list entry in nms:group, however there is no corresponding entries in nms:rspGrpRel

It appears the list contents are in a temp table. When I query the list, only the columns in the list are available for me to display as outputs. 

I am guessing the only option here is to introduce a javascript activity.

Translate
ccg1706
Community Advisor and User Group Leader
Community Advisor and User Group Leader
Nov 2, 2026 6:47 PM UTC

Hi ​@rntrp, 

 

You are right, you can use a javascript activity to fetch the list metadata from nms:group using xtq:queryDef and store it in workflow variables. You can use those values to populate additional columns in the worktable before combining the results, without manually defining a join key for each list.

 

Attached some useful documentation that might help you:

Examples of JS code in workflows

JavaScripts and templates

Enrichment activity

Hope it helps you!

 

Regards, 

Celia Castilla

Translate