FetchXml to retrieve segment member

(0) Share

Report

Posted on by Venedict

1,243

Hi All,

I'm using advanced find to retrieve the dynamic and static segment member and there is result return. Then I try to download the fetchxml file from the advanced find and put in my csharp code. However seem there is no result return.

Then I copied the fetchxml file into FetchXmlTester in Xrmtoolbox, it also didn't return any result. FYI, my segment have 1 contact in the advanced find result. Below is my fetchxml

Anything I missed out?

Thanks.

Regards,

Teh

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Venedict 1,243 on at

Like
a
(0)

Report
Copy link

Link copied!
I just realized that seem the FetchXml way to retrieve the records is deprecated.

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 saw there is a recommended way to retrieve it. However, I'm not sure how to convert this code in Plugin or custom workflow?

I'm try to run the {orgurl}/api/data/v9.0/msdyncrm_FetchContactsByQuery to retrieve the metadata, but I cant find msdyncrm_FetchContactsByQuery in the list.

Does anyone know how can I convert the code above to use in the Plugin or Custom workflow?

Thanks.

Was this reply helpful? Yes No
Verified answer

cloflyMao 25,210 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi Teh,

From metadata definition, calling "msdyncrm_FetchContactsByQuery" in Plugin or Workflow could be regarded as calling an action by organizationService.

String fetchxml = "" "" "" "" "" "" "" "" "" ""; OrganizationRequest orgRequest = new OrganizationRequest("msdyncrm_FetchContactsByQuery"); orgRequest.Parameters.Add("Query", "(SEGMENT(SEGMENT_CRM_ID_237349c9428fea11a811000d3a80c3f7)).ORDERBY(fullname ASC).SKIP(0).TAKE(15).SELECT(contactid)"); orgRequest.Parameters.Add("FetchXml", fetchxml); orgRequest.Parameters.Add("Scope", 270100000); orgRequest.Parameters.Add("TimeZone", null); OrganizationResponse orgResponse = organizationService.Execute(orgRequest);

Regards,

Clofly

Was this reply helpful? Yes No
Venedict 1,243 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Clofly,

Thanks for your reply. Using your sample code, I managed to get the segment member now.

I noticed that in your query, you are limit to 1st 15 contacts, correct? Is there any limit of the max contact that can return from the query?

Thanks.

Regards,

Teh

Was this reply helpful? Yes No
cloflyMao 25,210 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Teh,

The maximum number is 5000.

Regards,

Clofly

Was this reply helpful? Yes No
Venedict 1,243 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Clofly,

Thanks for your prompt reply. What if we have more than 5000 of segment member? How to retrieve all member in the segment?

Thanks.

Regards,

Teh

Was this reply helpful? Yes No
cloflyMao 25,210 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Teh,

In general fetchXml query, we could break the limitation with "paging cookie".

However, currently we are calling an action, and fetchxml here is only a parameter,

in other word, we are not running a general fetchxml query, so I'm not sure whether there is way to handle current situation.

I suggest you could open a support ticket to ask whether the maximum number could be upgraded at back-end for "msdyncrm_FetchContactsByQuery" if you have requirement about large number query.

Regards,

Clofly

Was this reply helpful? Yes No
RajaEmmadisetty 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

I tried to call the action in Power Automate but I am facing invalid query syntax issue.

[{"__type":"SegmentationCrmApiResponseError:#Microsoft.Dynamics.Crm.MarketingPlugins.Plugins.Segmentation.Contracts","ErrorCode":"QuerySyntaxError","Message":"Invalid query language: \u000aLine: 0, Position: 32, Column: 32: Number cannot be followed by a letter."}]

Power Automate looks like below.

Was this reply helpful? Yes No
Suggested answer

RajaEmmadisetty 20 on at

Like
a
(1)

Report
Copy link

Link copied!

No worried. It is working now. Flow looks like this . I had to get segment query name and use compose .

Was this reply helpful? Yes No