CRMProduct.RetrieveByOrganization Method

The RetrieveByOrganization method retrieves all products that are associated with an organization.


[Visual Basic .NET]
Public Function RetrieveByOrganization(
  ByVal Caller As CUserAuth,
  ByVal OrganizationId As String,
  ByVal StateCodes As Integer(),
  ByVal ColumnSetXml As String
) As String
public string RetrieveByOrganization(
  CUserAuth  Caller,
  string  OrganizationId,
  int[]  StateCodes,
  string  ColumnSetXml
public: String* RetrieveByOrganization(
  CUserAuth*  Caller,
  String*  OrganizationId,
  long  StateCodes __gc[],
  String*  ColumnSetXml



Specifies the identity of the caller. To perform this action, the caller must have the prvReadProduct privilege and access rights on the objects to be retrieved. See CUserAuth.


Specifies the ID of the organization to find.


Specifies an array of states to find. See PRODUCT_STATE.


Specifies an XML string describing the set of columns to be retrieved. Passing an empty string or null returns all columns (Nothing or ""in VB .NET). You can find the valid column names in product.xsd. See also ColumnSetXML Schema.

Return Value

Returns a String type that specifies the XML data representing the set of products associated with the specified organization. The fields that are returned depend on what fields are specified in the ColumnSetXml parameter. This XML string is in the format

<products> + product1..N + </products>

where the XML schema for each product is described by product.xsd.


Unlike the Retrieve method, the XML string returned from this method may contain multiple objects. If no objects are returned the method simply returns an XML document for the object type with no data.

The XML string returned from this method does not contain elements for fields where the value is null or contains empty strings. This improves performance by not sending more XML data than is necessary from the server to the client.

If there is an error, SOAP throws an exception and the error message is reported in System.Web.Services.Protocols.SoapException.Detail.OuterXml.

All IDs passed to the platform are GUIDs wrapped in braces. For example: {6522D89A-A752-4455-A2B0-51494C6957C3}


// strServer should be set with the name of the platform Web server
string strServer = "myservername";

// virtualDirectory should be set with the name of the Microsoft CRM
// virtual directory on the platform Web server
string virtualDirectory = "mscrmservices";
string strDir = "https://" + strServer + "/" + virtualDirectory + "/";

// BizUser proxy object
Microsoft.Crm.Platform.Proxy.BizUser bizUser = new Microsoft.Crm.Platform.Proxy.BizUser ();
bizUser.Credentials = System.Net.CredentialCache.DefaultCredentials;
bizUser.Url = strDir + "BizUser.srf";

// CRMProduct proxy object
Microsoft.Crm.Platform.Proxy.CRMProduct   product = new Microsoft.Crm.Platform.Proxy.CRMProduct();
product.Credentials = System.Net.CredentialCache.DefaultCredentials;
product.Url = strDir + "CRMProduct.srf";

string strErrorMsg;
string strOrgId = "{3BECB6A6-0DD8-4061-98D9-0B9E897C5027}";

   Microsoft.Crm.Platform.Proxy.CUserAuth userAuth = bizUser.WhoAmI();

   // An array of state codes to find
   int[] arrStateCodes = new int[] {Microsoft.Crm.Platform.Types.INVOICE_STATE.INS_ACTIVE,Microsoft.Crm.Platform.Types.PRODUCT_STATE.PS_ACTIVE};

   // Set up the columns that you want to retrieve
   string strColumnSetXml = "<columnset>";
   strColumnSetXml += "<column>name</column>";
   strColumnSetXml += "<column>description</column>";
   strColumnSetXml += "<column>price</column>";
   strColumnSetXml += "</columnset>";

   // Retrieve the products for this organization
   string strResultsXml= product.RetrieveByOrganization (userAuth, strOrgId, arrStateCodes, strColumnSetXml);

catch (System.Web.Services.Protocols.SoapException err)
   // Process the platform error here
   strErrorMsg = ("ErrorMessage: " + err.Message + " " + err.Detail.OuterXml + " Source: " + err.Source );
catch (Exception err)
   // Process other errors here
   strErrorMsg = ("ErrorMessage: " + err.Message );


Namespace: Microsoft.Crm.Platform.Proxy

Assembly: Microsoft.Crm.Platform.Proxy.dll

See Also

© 2005 Microsoft Corporation. All rights reserved.