Connect MS Dynamics CRM 2011 from java

0
votes

I am trying to connect to MS Dynamics CRM 2011 from Java. After lots of searching I came across one link in MS forums which gives a code snippet to invoke MS Dynamics CRM 2011 WS from Java.

Consuming CRM REST Service from Java

However, it does not provide much details other than an account creation step. Using this code snippet I am able to create accounts. However, I want to also use the same REST web service to retrieve accounts, create new case request, add case request to account, etc. Based on .NET examples available online I am trying to use the service.createAccountQuery() method to retrieve accounts. However, while all .NET examples uses LINQ to setup search criteria, I am clueless how to specify the subpath string in java to retrieve existing Accounts by their name/city/country etc.

Appreciate any help.

2
javaweb-servicesdynamics-crm-2011
Hi, I know it’s a while from when you asked this question, but I am facing issue with same sample for even creating proxy classes. Whenever I run this sample to generate proxy classes I am getting error msg “A recoverable error was detected (1000), attempting again in 2000 ms.”. I created a demo MS Dynamics CRM Online account (microsoft.com/en-in/dynamics/crm-free-trial-overview.aspx) and trying to connect that from java client. Could you please help me on this. - Vinay Pareek

2 Answers

0
votes

Instead of the "Account act..." line and below, use something like:

// Retrieve all accounts that the user has read access to.
string fetch1 = @"<fetch mapping=""logical"">
                     <entity name=""account"">
                        <all-attributes/>
                     </entity>
                  </fetch>";

// Fetch the results.
ExecuteFetchRequest req = new ExecuteFetchRequest();
req.FetchXml = fetch1;
ExecuteFetchResponse result1 = (ExecuteFetchResponse)service.Execute(req);

I'm unfamiliar with this proxy, but you want to call service.X where X is the Execute or RetrieveMultiple (based on what the proxy provides).

0
votes

not sure if you are still looking but for anyone else looking. I had the same issue.

It is using the odata query url so the subpath is the entitySet (e.g. for account it would be AccountSet)

you can then set the filter using the .filter method and the select via the .select method.

I did notice that you can't seem to do these on seperate lines though

e.g. you can't do

Query<microsoft.crm.sdk.data.services.Account> q = service.createAccountQuery("AccountSet"); q.filter("substringof('Test',Name)"); q.select("AccountId,Name"); q.execute();

you must do Query<microsoft.crm.sdk.data.services.Account> q = service.createAccountQuery("AccountSet").filter("substringof('Test',Name)").select("AccountId,Name"); q.execute();

Chris