CRMSalesOrder.RetrieveByObject Method
The RetrieveByObject method retrieves all sales orders that are associated with an object (account, contact, or opportunity).
Syntax
[Visual Basic .NET]
Public Function RetrieveByObject(
ByVal Caller As CUserAuth,
ByVal Object As CObjectName,
ByVal StateCodes As Integer(),
ByVal ColumnSetXml As String
) As String
[C#]
public string RetrieveByObject(
CUserAuth Caller,
CObjectName Object,
int[] StateCodes,
string ColumnSetXml
);
[C++]
public: String* RetrieveByObject(
CUserAuth* Caller,
CObjectName* Object,
long StateCodes __gc[],
String* ColumnSetXml
);
Parameters
Caller
Specifies the identity of the caller. To perform this action, the caller must have the prvReadOrder privilege and access rights on the objects to be retrieved. See CUserAuth.
Object
Specifies the object (account, contact, or opportunity) for which associated sales orders are to be retrieved. See CObjectName.
StateCodes
Specifies an array of state codes. Retrieves only sales orders that are in these states. See SALES_ORDER_STATE.
ColumnSetXml
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 salesorder.xsd. See also ColumnSetXML Schema.
Return Value
Returns a String type that specifies the XML data containing the set of sales orders associated with the specified object. The fields that are returned depend on what fields are specified in the ColumnSetXml parameter. This XML string is in the format
<salesorders> + salesorder1..N + </salesorders>
where the XML schema for each sales order is described by salesorder.xsd.
Remarks
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}
Example
[C#]
// strServerName should be set with the name of the platform Web server
string strServerName = "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://" + strServerName + "/" + 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";
// CRMSalesOrder proxy object
Microsoft.Crm.Platform.Proxy.CRMSalesOrder salesorder = new Microsoft.Crm.Platform.Proxy.CRMSalesOrder ();
salesorder.Credentials = System.Net.CredentialCache.DefaultCredentials;
salesorder.Url = strDir + "CRMSalesOrder.srf";
string strErrorMsg;
string strAccountId = "{CBDED4DD-CF90-43ED-85A9-0B33D205F9A6}";
try
{
Microsoft.Crm.Platform.Proxy.CUserAuth userAuth = bizUser.WhoAmI();
// Set up the columns that you want to retrieve
string strColumnSetXml = "<columnset>";
strColumnSetXml += "<column>name</column>";
strColumnSetXml += "<column>accountid</column>";
strColumnSetXml += "</columnset>";
// Initialize the account object
Microsoft.Crm.Platform.Proxy.CObjectName objName = new Microsoft.Crm.Platform.Proxy.CObjectName();
objName.Id = strAccountId;
objName.Type = Microsoft.Crm.Platform.Proxy.ObjectType.otAccount;
// An array of state codes to find
int[] arrCodes = new int[] {Microsoft.Crm.Platform.Types.INVOICE_STATE.INS_ACTIVE,Microsoft.Crm.Platform.Types.SALES_ORDER_STATE.SOS_ACTIVE};
// Retrieve the sales order by account object
string strResultXml = salesorder.RetrieveByObject (userAuth, objName, arrCodes, 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 );
}
Requirements
Namespace: Microsoft.Crm.Platform.Proxy
Assembly: Microsoft.Crm.Platform.Proxy.dll
See Also