Hi @brekrutwhen i add below in source mapping by copying and pasting. xdm:segmentMembership.seg_namespace.seg_id.statusxdm:segmentMembership.seg_namespace.seg_id.lastQualificationTime Here is error I am getting."Bad request parameters or payload. Please check your request and try again. Additional d...

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.status2. xdm:segmentMembership.seg_namespace.seg_id.lastQualificationTimeI followed link https://experienc...

Hi @Community,I working on creating extract of qualified segments using query service. Query service join tables "segmentsnapshot" and "profilesnapshot" and fetch segment id and segment name along with other profile attributes. Is there any way I can extract segments using query, which has evaluatio...

Thanks a ton @Devyendar it helped.

Hi @Community,I am working on segment export , where I am exporting comma separated segment name along with profile attributes.To extract segment details and customer id, I am leveraging "profilesnapshot" and "segmentsnapshot" tables, but i get data for "realized" segments only and there is no data ...

Hi @Comunity I am performing audience export. Email address field in audience export, where some the values are null in exported csv file. When SFMC automation takes this file, it gives error where emailaddress = 'null'.Could you suggest how can i make this field as blank ?Already tried below.1. Add...

Hi Brekrut,Thanks for the response.I have already tired this and always got blank values. I am creating a scheduled query to fetch segementid , segmentName and segment status from profilesnapshot and segmentsnapshot and storing it in profile and upsert enabled dataset.I am struggling to fetch segmen...

Hi @AmarapuramMahesh @Community I am exporting segment membership data like segment id and segment status. below query work for segment id. SELECT workEmail.address as email ,EXPLODE(segmentMembership.ups)FROM profile_snapshot_export_* )) Can I fetch both segment id and segment status like "realized...

Thanks @DavidRoss91  it really help.

Hi @DavidRoss91 Thanks for the response.Could you please let me know to mark schema as un-usable?Regards,Santosh