IOrganizationService.RetrieveMultiple

(0) Share

Report

Posted on by Arturo Nava

Hello, help to make visual project studio C #, I need to export records of my entity Product.

Subsequently those records serialize them to XML.

I need an example.

This method is correct: IOrganizationService.RetrieveMultiple ???

I appreciate the support.

regards!

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (2)

Sort by

Suggested answer

RaviKashyap 55,410 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

RetrieveMultiple message will return the collection of entity objects. Once retrieved you can use below sample to serielze it accordingly-

docs.microsoft.com/.../sample-serialize-deserialize-entity-instance

Hope this helps.

Was this reply helpful? Yes No
Arturo Nava 10 on at

Like (0)

Report
Copy link

Link copied!

Hi, thanks for the serialize example, I already have it ...

The problem I have is to connect to my organization and extract the products from the Product entity.

help me

Was this reply helpful? Yes No
Verified answer

N.A.R.A 95 on at

Like (1)

Report
Copy link

Link copied!
This is the example

The result are entity collection, you can just convert to list of entity

using Microsoft.Xrm.Sdk; using Microsoft.Xrm.Sdk.Query; //This is how to connect ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12; Uri crmOrganizationUri = new Uri("yourorganizationurl"); var credentials = new ClientCredentials() { UserName = { UserName = "yourusername", Password = "yourpassword" } }; var serviceProxy = new OrganizationServiceProxy(crmOrganizationUri, null, credentials, null); serviceProxy.EnableProxyTypes(); if (impersonateGuid != default(Guid)) { serviceProxy.CallerId = impersonateGuid; } //This is how to query QueryExpression productQe = new QueryExpression() { EntityName = "product", ColumnSet = new ColumnSet(true), Criteria = new FilterExpression() { //if you want add condition Conditions = { new ConditionExpression("name", ConditionOperator.Equal, "Arturo Nava") } } }; EntityCollection productEc = serviceProxy.RetrieveMultiple(productQe);

Good Luck

Was this reply helpful? Yes No
Suggested answer

Kokulan 18,054 on at

Like (1)

Report
Copy link

Link copied!

Hi

The following query will help you to retrieve products

// Instantiate QueryExpression QEproduct

var QEproduct = new QueryExpression("product");

// Add columns to QEproduct.ColumnSet

QEproduct.ColumnSet.AddColumns("name", "productid", "productnumber", "description", "statecode", "productstructure");

QEproduct.AddOrder("productnumber", OrderType.Ascending);

CrmService.RetrieveMultiple(QEproduct );

If you are not familiar with building query using query expression, you can use the XrmToolBox Fetch XML builder as shown below

01. Build your query in advance find and download the FETCH

02. Paste your FETCH and Convert to Query Expression C# code as shown below

Once you got the results, you can serialise or de-serialise as described in the link below

https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/org-service/sample-serialize-deserialize-entity-instance

Was this reply helpful? Yes No
Arturo Nava 10 on at

Like (0)

Report
Copy link

Link copied!

Hello N.A.R.A, I appreciate your help and time, I tell you to do what you send, ask, why does not show the method RetrieveMultiple ???

What is the error?

Regards!

Was this reply helpful? Yes No
Arturo Nava 10 on at

Like (0)

Report
Copy link

Link copied!

Hello N.A.R.A, review and the RetrieveMultiple method, it is shown with _service.

not with serviceProxy

Regards!

Was this reply helpful? Yes No
Arturo Nava 10 on at

Like (0)

Report
Copy link

Link copied!

I appreciate your support Ravi, to be serialized.

Do you have an example for RetriveMultiple ??

Thanks for your support.

Was this reply helpful? Yes No
Arturo Nava 10 on at

Like (0)

Report
Copy link

Link copied!

Hello Kokulan,

Thanks for answering ,,, Question..What is the difference between IOrganizationService.RetrieveMultiple vs. CrmService.RetrieveMultiple ????

Is the same??

I appreciate your support.

regards!

Was this reply helpful? Yes No
Verified answer

Kokulan 18,054 on at

Like (1)

Report
Copy link

Link copied!

Hi Arturo

CrmService in my example is just the variable name for OrganizationService, yes you are right its referring to the same IOrganizationService.RetrieveMultiple.

Was this reply helpful? Yes No
Arturo Nava 10 on at

Like (0)

Report
Copy link

Link copied!

Kokulan, I understand, I appreciate your help, thank you!

Was this reply helpful? Yes No