export segment status and lastQualificationTime

[SantoshRa5]

Hi Community,

I am working on exporting segment "status" and segment "lastQualificationTime". I performed mapping by pasting below in source mapping.

1. xdm:segmentMembership.seg_namespace.seg_id.status
2. xdm:segmentMembership.seg_namespace.seg_id.lastQualificationTime

I followed link https://experienceleague.adobe.com/en/docs/experience-platform/destinations/ui/activate/activate-bat...

error pops up  "
Bad request parameters or payload. Please check your request and try again. Additional detail: The attribute xdm:segmentMembership.seg_namespace.seg_id.lastQualificationTime does not exist in input schema. Please update the source schema path and try again.The attribute xdm:segmentMembership.seg_namespace.seg_id.status does not exist in input schema. Please update the source schema path and try again."

Please suggest me if I am missing any step.

Regards,

Santosh

[Karuppiah_Sakthivel]

You’re getting that error because segmentMembership is not part of your dataset schema. It only lives in the Profile Store, so you can’t map it by typing the XDM path manually.

To export status or lastQualificationTime, use the Profile attributes panel in the destination mapping screen. Open:

Profile attributes → segmentMembership → yourNamespace → yourSegmentId

Then select the fields from the tree.
If you paste the XDM path manually, the export tool will always say the fields don’t exist.

[SantoshRa5]

Hi @Karuppiah_Sakthivel 
Thanks for your response.
I checked  there is no value inside segementMembership object to appear while mapping.
I am following below adobe link which says to paste it.
 https://experienceleague.adobe.com/en/docs/experience-platform/destinations/ui/activate/activate-bat....

Could you please explain how you can get segmentMembship data in profile attributes.
Regards,
Santosh

[Karuppiah_Sakthivel]

Hi Santhosh,
This is expected behavior — you will not see segmentMembership in the Profile Attributes panel. Adobe confirms this is a known limitation of the new mapping UI:

Audience membership attribute cannot be selected through the mapping workflow. You must manually paste the path.
(Source: Adobe documentation)

https://experienceleague.adobe.com/en/docs/experience-platform/destinations/ui/activate/activate-bat...

So your mapping panel looking empty is normal.

To export segment status or lastQualificationTime, the correct method is:

xdm:segmentMembership.<namespace>.<segmentId>.status
xdm:segmentMembership.<namespace>.<segmentId>.lastQualificationTime

Two important things to check:

1. The segment must already have qualified profiles.
If the segment has 0 members, AEP returns “field does not exist,” even if the path is correct.

2. Make sure you are using a file-based destination (S3, Azure, GCS).
Batch export destinations automatically support segmentMembership fields — the dataset schema will never show them, but the export will still work.

[SantoshRa5]

Hi @Karuppiah_Sakthivel ,

Thanks for your response , above suggestion provided not working. Could you suggest if I am missing anything.

Here is screen shot of my union schema. It has nothing inside profileMembership. Do I need to reachout to administrator to add namespace field under profileMembership.

Here is the screenshot for my unified profile UI json. Is "ups" is my namespace and it should appear under segmentMembership in union schema ? 

In mapping I am adding below.

xdm:segmentMembership["ups"]["hardcodedSegmentID"].lastQualificationTime
xdm:segmentMembership["ups"]["hardcodedSegmentID"].status

Getting below error :

Error : 

Bad request parameters or payload. Please check your request and try again. Additional detail: The attribute xdm:segmentMembership["ups"]["hardcodedSegmentID"].status does not exist in input schema. Please update the source schema path and try again.The attribute xdm:segmentMembership["ups"]["hardcodedSegmentID"].lastQualificationTime does not exist in input schema. Please update the source schema path and try again.

Thanks in advance.

Best Regards,

[Sukrity_Wadhwa]

Hi @Karuppiah_Sakthivel,

Can you please help @SantoshRa5 further with their query?

Thanks!

[Karuppiah_Sakthivel]

I see the confusion.You did the right thing in your first attempt by using dot notation. The reason you saw that "Attribute does not exist" error is because segmentMembership is a dynamic field. Since your specific Segment ID isn't hard-coded into the static schema, the UI flags it as an error, even though the path is perfectly valid for the export engine.

Here is exactly how to fix this:

1. Remove the brackets: Go back to the dot notation. Do not use ["ups"] or quotes, as the mapping tool can't read them.
2. Use your actual ID: Paste the path exactly like this (replace the ID with your real GUID):

• xdm:segmentMembership.ups.your-segment-id-here.status
• xdm:segmentMembership.ups.your-segment-id-here.lastQualificationTime

3. Ignore the red error: Even if the UI says the attribute doesn't exist, ignore it and click "Save" or "Finish" anyway. The system will resolve the path when the file actually exports.

This is a known limitation documented by Adobe here: 
https://experienceleague.adobe.com/en/docs/experience-platform/destinations/ui/activate/activate-las... 

[SantoshRa5]

Hi @Karuppiah_Sakthivel 

Happy New Year !!.

I tried implementing the suggested approach and pasted SegmentStatus and SegmentLastQualification time as below

xdm:segmentMembership.ups.0f8ecacb-6cf1-4a52-a4e7-da4881400a6f.status

xdm:segmentMembership.ups.0f8ecacb-6cf1-4a52-a4e7-da4881400a6f.lastQualificationTime. Screenshot displays the error and it is not allowing me to move forward.

Segment I am using is qualified and it's entry exist in both profilesnapshot and segmentsnapshot tables.

Best Regards