Tag: MSCRM2011
-
PowerShell script to create a contact in Microsoft CRM 2011 via REST/ODATA
Below is a PowerShell function to create a contact in CRM 2011. Hope it is helpful to some one.
-
PowerShell script to add an activity via OData/REST
I wanted to create some crm activities based on data in a spreadsheet. Looping thorough the csv file would be easy, the challenge came when I wanted to create new activities in Microsoft CRM 2011, specifically appointments. Below is a PowerShell function that I pieced together to create a new activity if you know GUIDs…
-
PowerShell function to search CRM 2011 for and Entity (via REST/oData)
I wrote about how to retrieve records from CRM 2011 via oData. I wanted to wrap that up in a function that I can use to do a quick search: And to use this function: JBMURPHY-CRM-SearchEntity -EntityType Account -SearchField Name -SearchString “Sard” -FieldsToReturn Name,AccountId
-
Using PowerShell to query CRM 2011 SOAP endpoint – Answer!
Big thanks to @JLattimer. He helped me figure our the error in my SOAP envelope. In my last post, I was trying to retrieve FullName from Crm 2011’s web services via PowerShell. Below is the code to do that.
-
Using PowerShell to query CRM 2011 SOAP endpoint – help!
I don’t know what I am doing wrong. All I am trying to do is to query CRM 2011 via PowerShell and SOAP. The following PowerShell script should return the Contact’s full name, but I get nothing. Any ideas?? Here is the PowerShell: And here is the response: I just don’t know what I am…
-
SharePoint 2010, Client OM, jQuery Autocomplete and BCS/External lists
In this previous post, I used jQuery/SOAP/SPServices to access a SharePoint BCS list (an external list). I wanted to do the same thing using the Client Object Model (Some call it Clien OM? Or maybe CSOM?). Below is the code to access contact data in a BCS connection to Microsoft CRM 2011, and use it…
-
Add an appointment/email/phone activity to CRM 2011 via PowerShell (REST/oDATA)
I am looking to move some older list data into CRM 2011, so I wanted a way to create some “activities” via powershell. Below is the code to do that. In the first part of the code, I create a PowerShell object and then I convert it to a JSON object via PowerShell 3’s new…
-
PowerShell code to query a table, and put the XML results into a SharePoint Document Library
If you look at this prior post, I showed how you can use an xml file in a document library as a source for an input box’s jQuery autocomplete. I wanted to automate the creation of these XML files and upload them to a SharePoint Document Library. For example, I wanted to query Microsoft CRM…
-
Update CRM 2011 from an Excel Sheet using PowerShell and the oData/REST endpoint
Let’s say you exported a group of Contacts from CRM 2011 using the “Export to Excel” button and you selected the “Make this data available for re-importing by including required column headings” button. The important thing that this does is it adds the GUID for the contact to the first column. Now, let’s say you…
-
PowerShell code to update a CRM 2011 field (using REST/oData)
In this earlier post I showed how to loop through all the contacts in CRM 2011. Next thing I wanted to do was to update a field on each Account. So I needed to figure out how to update data, not just read it. Here is the code to do that: