2013 CRM online - raw SOAP XML examples?

(0) Share

Report

Posted on by jpaxon

210

hello,

i am working on a non-.NET, non-javascript, external application, that is connecting to an instance of dynamics online 2013 via SOAP.

i can make some basic requests (get a single entity, get multiple entities), but am struggling to fetch more complex data from the CRM. does anyone know of examples of the raw SOAP XML required to run various queries?

things like:

get all contacts along with their notes.
get all accounts along with multiple custom relationship (1:N) values

furthermore, can some confirm that it is possible to use the fetchXML syntax within SOAP for the version of ms dynamics i am working with (2013 online)?

thanks.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

jpaxon 210 on at

Like (0)

Report

additionally, is it possible via a SOAP call to run a report created and saved in the CRM web interface?

Was this reply helpful? Yes No
Royal King 27,686 on at

Like (0)

Report

Yes you can execute Fetchxml queies using SOAP API.

Best place to find all the API messages and sample code is CRM SDK . If you need more sample check the below blog it has lots of sample c# code to query CRM using SOAP API as well REST API

mileyja.blogspot.com/.../how-to-retrieve-metadata-for-entity.html

Was this reply helpful? Yes No
Suggested answer

Alessandro Graps 2,664 on at

Like (0)

Report

Hello,

Maybe you can find help in this links:

jianwang.blogspot.co.uk/.../orchard-crm-application-design.html

blogs.msdn.com/.../connecting-to-crm-online-2011-web-services-using-soap-requests-only.aspx

blog.bitmelt.com/.../microsoft-dynamics-crm-and-php.html

Bye

Alessamdro

Was this reply helpful? Yes No
jpaxon 210 on at

Like (0)

Report
thanks all.

as i already have a successful connection to the CRM, what i am looking for are examples of the actual SOAP XML for complex queries. particularly around how to get 1 to many entity relationships. XML examples of the following would help:

how to get contacts along with their notes

how to get contacts along with a custom 1 to many relationship

how to execute reports that were created and saved via the web interface.

thanks again.

Was this reply helpful? Yes No
Royal King 27,686 on at

Like (0)

Report

You can build FetchXml Queries using Advanced find in crm to get whatever results you want.

Was this reply helpful? Yes No
Verified answer

jpaxon 210 on at

Like (0)

Report

thanks chitra, but not entirely true. advanced find won't let you link to notes. it does work for pretty much all the other relationships though.

if anyone else lands here, this will get you notes: community.dynamics.com/.../100257.aspx

Was this reply helpful? Yes No
CPQExpert 35 on at

Like (0)

Report

Do you have any RAW Soap Examples to login to Dynamics online ?

Was this reply helpful? Yes No
Suggested answer

Criss69 20 on at

Like (0)

Report
Hello,

I have put together a plain PHP program that queries an on-premise CRM and displays the query result in a simple way (non-XML).

The code I use to query contats is:

<s:Body> <Execute xmlns="schemas.microsoft.com/.../Services" xmlns:i="www.w3.org/.../XMLSchema-instance"> <request i:type="a:RetrieveMultipleRequest" xmlns:a="schemas.microsoft.com/.../Contracts"> <a:Parameters xmlns:b="schemas.datacontract.org/.../System.Collections.Generic"> <a:KeyValuePairOfstringanyType> <b:key>Query</b:key> <b:value i:type="a:QueryExpression"> <a:ColumnSet> <a:AllColumns>false</a:AllColumns> <a:Columns xmlns:c="schemas.microsoft.com/.../Arrays"> <c:string>firstname</c:string> <c:string>lastname</c:string> </a:Columns> </a:ColumnSet> <a:Distinct>false</a:Distinct> <a:EntityName>contact</a:EntityName> <a:LinkEntities /> <a:Orders /> <a:PageInfo> <a:Count>0</a:Count> <a:PageNumber>0</a:PageNumber> <a:PagingCookie i:nil="true" /> <a:ReturnTotalRecordCount>false</a:ReturnTotalRecordCount> </a:PageInfo> <a:NoLock>false</a:NoLock> </b:value> </a:KeyValuePairOfstringanyType> </a:Parameters> <a:RequestId i:nil="true" /> <a:RequestName>RetrieveMultiple</a:RequestName> </request> </Execute> </s:Body>

The program puts this code inside an evelope tag, and it works.

I have found out that witha few tweaks you can change the query behaviour.

I need some more examples to query Accounts, and some exhaustive guide on filters/operators would be really useful.

I hope the above can help, anyway.

Was this reply helpful? Yes No