Thursday 25 July 2013

Dynamics CRM 2011 - PHP and SOAP Calls

I put the first little section regarding CRM 2011, PHP, and SOAP here ->  http://crmtroubleshoot.blogspot.com.au/2013/07/dynamics-crm-2011-php-and-soap-using.html

I went into some basic information about authentication so in this second part I thought I would give people the SOAP calls for talking to CRM 2011.

NOTE: I am not suggesting the following are the only ways to connect using SOAP to CRM and I know its not a complete list (Delete for example) however I hope this assists you in your investigation it is not intended to do all the work for you! ;-)

SOAP CALLS


CREATE
Creates a single CRM record


    
      
  
      
      
      
      00000000-0000-0000-0000-000000000000
      
      
    



RETRIEVE
Returns a single CRM record based on the GUID.


  
  
  
 false
 
   
 
  



RETRIEVE ALL ENTITIES
This returns all all entities. I don't really recommend this because it is incredibly slow!


 
   
    
  EntityFilters
  Entity
    
    
  RetrieveAsIfPublished
  true
    
   
   
   RetrieveAllEntities
 



RETRIEVE MULTIPLE
Returns a collection of CRM Records based on the Criteria list passed


 
  
    false
    
   
    
  
  
  false
  
  
  
  
    
    
    
    false
  
 



UPDATE
Updates a single record based on the GUID


 
  
   
  
  
  
  
  
  
 



WHO AM I
Returns the User Id, Business Unit Id, and Organization Id for the logged in user


 
  
  
  WhoAmI
 



CHILD ITEMS


COLUMN
This should be repeated for each column required for the Retrieve Requests


 



ATTRIBUTES
This should be repeated for each attribute required for a Create or Update Request. There is various types for attributes.

EntityReference

 
 
  
  
  
  


OptionSetValue

 
 
  
 


Money

 
 
  
 


String

        
 


Boolean

        
 


Integer

        
 


Date Time

        
 




CRITERIA
Used to filter the query results


 
 
  
  
   
   
   
    
    
   
  
 



ORDER
Used to define the sort order of the result set


 
 
  
  
 



56 comments:

  1. I found this very helpful, I was able to use the Money datatype thanks to this. But I've struck some trouble when trying to use this for OptionSetValue, I'm getting an internal error from the CRM. Did you hit anything like this? Or know the work around?

    ReplyDelete
    Replies
    1. Do you have the code for the Option Set Value you are trying to use?

      Quite often the internal error is if the item doesn't exit. Confirm you are using the Value not the label and you have no commas.

      Delete
    2. Thank you, I figured it out; I tried to set the same optionset 2 times in the same request...completely missed it; sorry.

      Delete
  2. I think you're saving my day! Maybe my week :D
    Thanks a lot!
    That is real stuff

    ReplyDelete
  3. About the entitystate and FormattedValues tags
    It seems that there is a difference between that post and what you wrote on Stackoverflow
    moreover, such request as gives me an error
    So I did not nest them and there is no more error with my request.



    00000000-0000-0000-0000-000000000000

    account

    But...The properties are not taken into account . The Entity is created but stays empty
    Maybe you know : how do you know the way to have the right schema to integrate with Dynamics? the right key/values attributes etc? sniff the network and see what works? Is there a more "mature" way to do ? ;)

    ReplyDelete
  4. I can't seem to figure out which Stack Overflow post you are talking about. Can you give me a link? (or show me your query)

    Not sure what you mean by key/values
    You should be able to go in CRM to Settings -> Customizations -> Customize the System.

    You should then be able to find the entity name and field names.

    ReplyDelete
  5. Hi Andrew,
    Can you comment on new ExecuteMultiple operation? Seems it is not a part of current online Organization.svc wsdl...
    http://blogs.msdn.com/b/thecrmguys/archive/2013/01/09/hands-on-with-dynamics-crm-2011-s-new-executemultiple-request.aspx

    ReplyDelete
    Replies
    1. Sorry for the late reply Adie. I haven't read much about it to be honest :(

      Delete
  6. Hi,

    I want to get all users data from some another database. So once I am getting an array of all users data using PHP, then same data I want to send to CRM. So could you please convey me the examples or steps to move ahead with that.

    Any help would be greatly appreciated.

    ReplyDelete
  7. Hi Andrew,
    Thanks for the super helpful article.
    I'm stuggeling to find the correct operators to use when building my criteria. I know = is "Equal" but can't figure out >. Both "Greater Than" and "gt" generate an "Invalid enum value" error. You say in a comment to "GET THE VALUES FROM A FETCH XML QUERY" - I can't find an example anywhere of a fetch XML query so how would I go about doing this?

    ReplyDelete
    Replies
    1. If you do an Advanced Find in CRM in the top ribbon there will be an option for "Download Fetch XML".

      If you click that it will allow you to download the Fetch XML for your query. However I would have though "gt" would work.

      Have you had any luck with this?

      Delete
  8. hello one thing I can't figure out is...
    I am trying to create "user" and populate already set attributes. I can do it with normal strings etc, but have no idea how to do it with lookup values? Any thoughts examples?
    Thanks

    ReplyDelete
    Replies
    1. Entity Reference = Lookup. So copy and paste that. You'll need 3 values. The name of the relationship, the guid for the related record, and the child entity name.

      Delete
  9. We are expert and professional in ms crm series. Here are option for the all these articles Microsoft Dynamics CRM : Ms crm 2011, 2013 and 2015 step by step tutorial of ms crm error in mscrm plugin workflow ms crm javascript Code .

    ReplyDelete
  10. This comment has been removed by the author.

    ReplyDelete
  11. ?I was very pleased to seek out this web-site.I needed to thanks for your time for this excellent read!! I undoubtedly having fun with each little bit of it and I have you bookmarked to check out new stuff you weblog post. online casino bonus

    ReplyDelete
  12. Harassing free business calls can be very nerve wracking and frustrating. What at first may have seemed like a harmless prank may now be a phone harassment that is interfering with your life. You need to put a stop to these harassing calls, and face this issue before you let it get out of hand.

    ReplyDelete
  13. This comment has been removed by the author.

    ReplyDelete
  14. This comment has been removed by the author.

    ReplyDelete
  15. Appmakr is free software that allows people to make iOS and Android apps. The good side with the software is that you don't need to have coding skills to use it. Another advantage is that the software is easy to use. To use it you need to go to Appmakr's official website and enter the name of the app that you want to create. You should then click on "get started" and sign into the site using your Gmail, Facebook, twitter, or yahoo account. Check This Out

    ReplyDelete
  16. If you're interested in pursuing a technology management MBA, you first need to find an accredited on-campus or online school. This guide will help you find the right online school to earn an MBA with a focus in technology management. phone tracker

    ReplyDelete
  17. Hey there guys, newbie here. I’ve lurked about here for a little while and thought I’d take part in! Looks like you’ve got quite a good place here 토토사이트

    ReplyDelete
  18. Your blog never ceases to amaze me, it is very well written and organized..’”., iphone emulator for pc

    ReplyDelete
  19. wonderful publish, very informative. I wonder why the other experts of this sector do not notice this. You should continue your writing. I’m sure, you have a huge readers’ base already! wireless

    ReplyDelete
  20. This is actually interesting, You’re a particularly proficient article author. I’ve registered with your feed additionally expect finding the fabulous write-ups. Furthermore, I’ve shared your internet-site with our social networks. euregion

    ReplyDelete
  21. There are several benefits for junk car owners to contact an auto removal company to haul their cars away. This article will discuss the facts on junk car removal and the benefits to the vehicle owners from environmental benefits to receiving cash for their automobile. promocja na instagramie

    ReplyDelete
  22. I really wanted to send a quick word in order to thank you for all of the remarkable points you are giving out here. My time consuming internet look up has now been rewarded with reliable details to write about with my friends and family. I would repeat that most of us site visitors actually are very much lucky to be in a notable site with very many awesome people with very beneficial points. I feel truly blessed to have discovered the website page and look forward to really more excellent minutes reading here. Thanks again for everything. Chinese Takeaway Menu

    ReplyDelete
  23. So you own a business and you just got broken into, again! The desire for security cameras has just gone from a want to a necessity in the time it took you to call the police, and they, (as nicely as possible) told you there is still NOTHING they can do for you diy spy camera with audio

    ReplyDelete
  24. An intriguing discussion may be valued at comment. There’s no doubt that that you should write much more about this topic, it will not become a taboo subject but normally consumers are too few to talk on such topics. To a higher. Cheers 188bet

    ReplyDelete
  25. Hi Im itching to know if I may use this article in one of my blogs if I link back to you? Thanks buy steroids

    ReplyDelete
  26. Hey there, May I grab the picture and usage that on my own weblog? cross platform mobile app development tools

    ReplyDelete
  27. Youre so cool! I dont suppose Ive read anything in this way just before. So nice to seek out somebody by original ideas on this subject. realy we appreciate you starting this up. this excellent website is one area that is required on the internet, somebody with a little originality. helpful problem for bringing a new challenge on the internet! 안전놀이터

    ReplyDelete
  28. You really should get involved in a tournament for example of the most effective blogs on the web. I am going to recommend this website! card games planet

    ReplyDelete
  29. I’m impressed, I must say. Truly rarely do I encounter a weblog that’s both educative and entertaining, and let me tell you, you have hit the nail around the head. Your concept is outstanding; the problem is an element that insufficient persons are speaking intelligently about. We are delighted we stumbled across this around my look for something concerning this. sugaring

    ReplyDelete
  30. I appreciate your wordpress web template, wherever would you down load it from? buy steroids online

    ReplyDelete
  31. Ha ha… I was just browsing around and took a glance at these reviews. I can’t believe there’s still this much interest. Thanks for writing about this. hcg for sale

    ReplyDelete
  32. ibuprofen is a good pain reliever but i heard that this one have nasty side effects too:: hcg for sale

    ReplyDelete
  33. our bedding collections consists of beddings that come from new york and this are great bedding collections` anavar for sale

    ReplyDelete
  34. In this article understand the most important thing, the item will give you a keyword rich link a great useful website page: 에볼루션카지노

    ReplyDelete
  35. Great blog. I delighted in perusing your articles. This is really an awesome perused for me. I have bookmarked it and I am anticipating perusing new articles. Keep doing awesome! There is so much in this article that I would never have thought of on my own. Your content gives readers things to think about in an interesting way. Wonderful article. Fascinating to read. I love to read such an excellent article. Thanks! It has made my task more and extra easy. Keep rocking. Very interesting information, worth recommending. However, I recommend this 먹튀수사대

    ReplyDelete
  36. Great beat ! I wish to apprentice while you amend you r web site, how can i subscribe for a blog website? The account aided me a appropriate deal. I had been a little bit acquainted of this your broadcast provided bright clear idea. I'm truly enjoying the design and layout of your site. It's a very easy on the eyes which makes it much more pleasant for me to come here and visit more often. Did you hire out a designer to create your theme? Superb work! Great tips and very easy to understand. This will definitely be very useful for me when I get a chance to start my blog. I am a new user of this site so here i saw multiple articles and posts posted by this site,I curious more interest in some of them hope you will give more information on this topics in your next articles. 먹튀사이트검증

    ReplyDelete
  37. Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info. This is a cool blog. Extremely helpful info. Thank you! Nice blog here! Additionally your website loads up very fast! What web host are you the usage of? Can I am getting your associate link on your host? I wish my website loaded up as quickly as yours lol Excellent read, Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. 먹튀사이트

    ReplyDelete
  38. What I wouldnt give to have a debate with you about this. You just say so many things that come from nowhere that Im fairly positive Id have a fair shot. Your blog is terrific visually, I mean people wont be bored. But others who can see past the videos and the layout wont be so impressed with your generic understanding of this subject. brazilian sugaring

    ReplyDelete
  39. There are some attention-grabbing closing dates in this article however I don’t know if I see all of them heart to heart. There is some validity but I’ll take maintain opinion until I look into it further. Good article , thanks and we would like extra! Added to FeedBurner as nicely . Your presence is great on this post. We love sharing good posts with our fans. Whenever you need more posts you can ask me for topic and title. Excellent work . Excellent read, Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work . 안전놀이터

    ReplyDelete
  40. What’s Happening i’m new to this, I stumbled upon this I’ve found It positively useful and it has aided me out loads. I hope to give a contribution & help other users like its helped me. Good job. I do agree with all of the ideas you’ve presented in your post. They’re really convincing and will certainly work. Still, the posts are very short for newbies. Could you please extend them a bit from next time? Thanks for the post. Your blogs further more each else volume is so entertaining further serviceable It appoints me befall retreat encore. I will instantly grab your rss feed to stay informed of any updates. I truly appreciate this post. I have been looking everywhere for this! Thank goodness I found it on Bing. You have made my day! Thx again! 안전놀이터

    ReplyDelete
  41. This novel blog is doubtlessly cool and educational. I have found many intriguing advices out of this source. I promotion love to return again soon. Much appreciated ! You ave made some valid statements there. I kept an eye on the web for extra data about the issue and discovered the vast majority will oblige your perspectives on this site. This specific blog is almost certainly engaging furthermore useful. I have picked a lot of helpful things out of this blog. I advertisement love to visit it over and over. You rock! Only wanna say that this is useful , Thanks for taking as much time as necessary to compose this. 우리카지노

    ReplyDelete
  42. It's extremely pleasant and meanful. it's extremely cool blog. Connecting is exceptionally valuable thing.you have truly helped bunches of individuals who visit blog and give them usefull data. I wish I had found this blog before. The advice in this post is very helpful and I surely will read the other posts of this series too. Thank you for posting this. You have a very good site, well constructed and very interesting I have bookmarked you hopefully you keep posting new stuff. You make so many great points here that I read your article a couple of times. Your views are in accordance with my own for the most part. This is great content for your readers. 먹튀검증

    ReplyDelete
  43. When I initially commented I clicked the -Notify me when new comments are added- checkbox and now each time a remark is added I get four emails with the same comment. Is there any manner you possibly can take away me from that service? Thanks! Best Conditioner for Dry Hair

    ReplyDelete
  44. our bedding collections consists of beddings that come from new york and this are great bedding collections` Play Therapy

    ReplyDelete
  45. I’d ought to consult you here. Which isn’t something I do! I enjoy reading an article that will make people think. Also, many thanks permitting me to comment! kids silk sleepwear

    ReplyDelete
  46. https://www.amazon.in/Whatsapp-Software-Delivery-Marketing-whatsapp/dp/B09GXYLJ17/ref=sr_1_11?dchild=1&keywords=Whatsapp+Bulk+Message+Sender+Software&qid=1632979675&s=software&sr=1-11

    ReplyDelete

    ReplyDelete
  47. A lot of words and statistics can be used to build the case that mobile devices have grown and continue to grow into one of the most popular technological advancements. Just looking around would convince the most skeptical among us. And as with all new developments, the speed with which these new developments are improved and made more accessible, is directly proportional to their popularity. As a result, mobile is changing and improving... FAST! singapore best mobile app services

    ReplyDelete
  48. SHREE SAI PACKERS AND MOVERS
    #18/3, 30ft road,, sri krishna colony,
    kuduregere main road,, alur post,
    Bangalore, Karnataka 562123
    080736 70915


    Packers and movers bangalore

    Packers and movers bangalore

    We are the top packers and movers in bangalore

    Packers and movers in peenya

    We are the top packers and movers in bangalore

    Packers and movers in koramangala

    ReplyDelete
  49. Normally i don’t read post on blogs, but i desire to mention that this write-up very pressured me to try and accomplish that! Your writing fashion has been amazed me. Thank you, very satisfactory put up. Super guide! Chatting approximately how precious the whole digesting. I hope to analyze from manner greater away from you. I recognize you’ve remarkable look and moreover view. I manifest to be very a good deal contented the usage of information. Amazing goods from you, guy. I’ve unde rstand your stuff preceding to and you’re just extraordinarily fantastic. I simply like what you have received here, actually like what you're announcing and the manner in that you say it. You're making it interesting and you still cope with to preserve it sensible. I can't wait to examine a great deal more from you. That is truely a exceptional web website. my brother advised i may also like this weblog. He changed into definitely proper. This post definitely made my day. You cann’t trust just how a lot time i had spent for this information! Thank you! I examine a number of stuff and i discovered that the manner of writing to clearifing that precisely need to say became excellent so i am impressed and ilike to come back again in future.. 토토사이트

    ReplyDelete
  50. Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more. I just found this blog and have high hopes for it to continue. Keep up the great work, its hard to find good ones. I have added to my favorites. Thank You. Its a great pleasure reading your post.Its full of information I am looking for and I love to post a comment that "The content of your post is awesome" Great work. Nice post! This is a very nice blog that I will definitively come back to more times this year! Thanks for informative post. 온카맨

    ReplyDelete
  51. This particular papers fabulous, and My spouse and i enjoy each of the perform that you have placed into this. I’m sure that you will be making a really useful place. I has been additionally pleased. Good perform! Extremely fascinating online journal. Alot of online journals I see nowadays don't generally give anything that I'm keen on, however I'm most definately intrigued by this one. Recently felt that I would post and let you know. Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. If possible, as you gain expertise, would you mind updating your blog with extra information? It is extremely helpful for me. 카지노

    ReplyDelete