Customer experience | Sales, Customer Insights,...

Fetch contacts from multiple segments with condition

(0) Share

Report

Posted on by Community member

Hi,

I am trying to use Postman API to fetch contacts that are in segments.

I want to fetch several segments (with some condition, like segment name contains /xyz/) and their contacts, but I only know how to fetch contacts from one single segment.

Is there any solution?

POST {{OrgUrl}}/api/data/v9.0/msdyncrm_FetchContactsByQuery{    /Query/:/(SEGMENT(SEGMENT_CRM_ID_e1fa7fdc5c78ea11a811000d3a8e8fcc)).ORDERBY(fullname ASC).SKIP(0).TAKE(15).SELECT(contactid)/,    /FetchXml/://,/OwningBusinessUnit/:/0b4b85cc-7f6c-ea11-a811-000d3a54d359/,    /Scope/:270100000,    /TimeZone/:null}

I try to revise (SEGMENT(SEGMENT_CRM_ID_e1fa7fdc5c78ea11a811000d3a8e8fcc)) to (SEGMENT(IN(SEGMENT_CRM_ID_e1fa7fdc5c78ea11a811000d3a8e8fcc, second_segment_id)), but it doesn't work.

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Dengliang Li Microsoft Employee on at

Like (0)

Report

Hi,

There is a one-to-many relationship between the segment entity and the contact entity.

Therefore, you can try to query related contacts using the Collection-valued navigation properties.

Query data using the Web API - Power Apps | Microsoft Learn

The following example retrieves the segment name attribute from the first two segment records and expands the information about the associated contacts to include the full name

GET {{webapiurl}}msdyncrm_segments?$select=msdyncrm_segmentname&$expand=msdyncrm_msdyncrm_segment_contact($select=fullname)&$top=2

Best Regards,
Dengliang Li

Was this reply helpful? Yes No
Dengliang Li Microsoft Employee on at

Like (0)

Report

Hi,

Has the issue been solved?
Have there been any updates? Please feel free to ask me if you have any questions!
If it has been resolved, can you mark the response as an answer?

Was this reply helpful? Yes No

Join the conversation

Community site session details

Fetch contacts from multiple segments with condition

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Fetch contacts from multiple segments with condition

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates