{"id":183,"date":"2009-08-28T08:53:00","date_gmt":"2009-08-28T03:23:00","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=183"},"modified":"2009-08-28T08:53:00","modified_gmt":"2009-08-28T03:23:00","slug":"how-to-convert-a-retrievemultiple-query-written-server-side-to-soap-message-to-be-used-in-javascripts","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2009\/08\/how-to-convert-a-retrievemultiple-query-written-server-side-to-soap-message-to-be-used-in-javascripts\/","title":{"rendered":"How to convert a RetrieveMultiple query written Server side to SOAP message to be used in Javascripts"},"content":{"rendered":"
<\/div>\n

It has often been seen that a RetrieveMultiple query that is very easy to write using the server side Query Expression objects using CRM webservices becomes difficult to achieve if we need to create a SOAP message for the same.<\/p>\n

In this article we hope to explain each of the elements involved in the writing of SOAP messages to be used through Javascripts.
\nLet us take a simple RetrieveMultiple code as an example.
\nWhile writing the SOAP message the first component required is the SOAP envelope. This is the same at all times for all SOAP messages.
\n““+
\n“” xmlns:xsi=’http:\/\/www.w3.org\/2001\/XMLSchema-instance'”+
\n” xmlns:xsd=’http:\/\/www.w3.org\/2001\/XMLSchema’>”+
\nNext we need to add the Authentication Header that needs to be passed along with the SOAP message for successful authentication with the CRM Web service. CRM has an inbuilt function GenerateAuthenticationHeader() that can be used for this purpose.
\nvar authenticationHeader = GenerateAuthenticationHeader();
\nSOAP Body is where the actual SDK message to be executed is included.
\n“”+
\nIn our example we are using the RetrieveMultiple Message so we provide the Message name and the schema reference to the CRM webservices
\n“”+
\nThe parameter to a Retrieve Multiple Message is always a query expression
\nQueryExpression query = new QueryExpression();
\n“” xsi:type=’q1:QueryExpression’>”+
\nNow include all properties of the Query object that you set.
\nEntity name
\n<\/strong>
\nquery.EntityName = EntityName.incident.ToString();
\n“incident”+
\nColumn Set<\/strong><\/p>\n

query.ColumnSet = new AllColumns();<\/p>\n

“”+
\n“”+
\n“title”+
\n“incidentid”+
\n“”+
\n“”+
\nCriteria
\n<\/strong>
\nConditionExpression condition = new ConditionExpression();
\ncondition.AttributeName = “title”;
\ncondition.Operator = ConditionOperator.Like;
\ncondition.Values = new string [] {strSearchText};
\n“”+
\n“And”+
\n“”+
\n“”+
\n“title”+
\n“Like”+
\n“”+
\n“”+searchtext +””+
\n“”+
\n“”+
\n“”+
\n“”+
\nHere, we have used ‘Like’ condition operator, likewise one can use any of the sdk supported operators and change the values to be matched accordingly.<\/p>\n

Order by
\n<\/strong><\/p>\n

 
\n
\n<\/strong>OrderExpression oe = new OrderExpression();
\noe.AttributeName = “title”;
\noe.OrderType = OrderType.Ascending;
\nquery.Orders = new OrderExpression[]{oe};
\n“” +
\n“” +
\n“title” +
\n“Ascending” +
\n“” +
\n“” +
\nOnce you have set all of these\u2026 your SOAP message is ready for execution.<\/p>\n","protected":false},"excerpt":{"rendered":"

It has often been seen that a RetrieveMultiple query that is very easy to write using the server side Query Expression objects using CRM webservices becomes difficult to achieve if we need to create a SOAP message for the same. In this article we hope to explain each of the elements involved in the writing\u2026 Read More: How to convert a RetrieveMultiple query written Server side to\u2026 »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,33],"tags":[315,1284,1473],"class_list":["post-183","post","type-post","status-publish","format-standard","hentry","category-dynamics-crm","category-javascript","tag-conditionoperator","tag-orderexpression","tag-retrievemultiple"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t