Solved

Regarding AEP Queries features.

5 replies
2145 views
Translate All

Can we use queries to fetch segment's all attributes in AEP ?.

and I also find some auto suggested table name in Queries like (segment_ingestion_dataset, segment_export_dataset)

where does it come from as there is no such dataset present with this names.

Experience Platform

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Anuhya-YAccepted solution

Community Advisor

@infyashu : These are system generated datasets, you can find these by enabling show system datasets from UI.

Could you please elaborate below question, what are you looking exactly.

"Can we use queries to fetch segment's all attributes in AEP ?"

Community Advisor

Accepted solution

Community Advisor

@infyashu : These are system generated datasets, you can find these by enabling show system datasets from UI.

Could you please elaborate below question, what are you looking exactly.

"Can we use queries to fetch segment's all attributes in AEP ?"

Translate

Using API, I want to do below

Get the list of profiles qualified in a segment.
Delete a specific profile from this list.
Fetch the record details of the profile.

Translate

Community Advisor

Community Advisor

@infyashu check out below details.

Get the list of profiles qualified in a segment.

Segment export API : https://developer.adobe.com/experience-platform-apis/references/segmentation/#tag/Export-jobs/operation/createExportJob
Using query service : select * from profile_snapshot_export_XXXXX where segmentmembership['ups']['195329af-1df-49f0-993a-4d3495132e6'].status IN ('realized', 'existing','exited')

Note: replace profile_snapshot_export dataset name, segment id in the query as per the system you are using

Delete a specific profile from this list.

Deleting single profile may not be possible but using Profile system jobs endpoint,data from profiles can be deleted which are part of a batch, checkout https://experienceleague.adobe.com/docs/experience-platform/profile/api/profile-system-jobs.html?lang=en

Fetch the record details of the profile.

Entity API : https://developer.adobe.com/experience-platform-apis/references/profile/#tag/Entities/operation/retrieveEntity
Query service: select * from profile_snapshot_export_XXXXX where PERSONALEMAIL.ADDRESS=xyz@abc.com'

Note:replace profile_snapshot_export dataset name, column name in the query as per the system you are using

Translate