In my, previous post, I had demonstrated how to get List Items using SharePoint REST API. In this post, we will see how to retrieve the following fields:
- Lookup
- Managed Metadata
- Person or Group
In my, previous post, I had demonstrated how to get List Items using SharePoint REST API. In this post, we will see how to retrieve the following fields:
In one of my previous post I had demonstrated how to, Download Large Files from SharePoint Online. While the file download is working perfectly fine, but, I was constantly getting the following error while trying to load/access it’s properties,
Value was either too large or too small for an Int32
It’s pretty easy now to get your Office 365 tenant ID. Here, I will demonstrate three ways, by which you can retrieve your tenant ID :-
In this post, I’ll be retrieving a SharePoint site’s TimeZone using CSOM.
var context = SP.ClientContext.get_current(); var timeZone = context.get_web().get_regionalSettings().get_timeZone(); context.load(timeZone); context.executeQueryAsync(successHandler, errorHandler);
using (ClientContext ctx = new ClientContext("siteUrl")) { ctx.Credentials = new SharePointOnlineCredentials("userId", secureStringPassword); Microsoft.SharePoint.Client.TimeZone sharePointTimeZone = ctx.Web.RegionalSettings.TimeZone; ctx.Load(sharePointTimeZone); ctx.ExecuteQuery(); }
The output, in both the cases, will be:
Read More »
This is the first of the 2 series blog. In this, I’ll explain how to do create a read-only Office365 User, directly from the client PowerShell. And then there’s a complete code snippet to achieve the same from a C# Console App in the 2nd part of this blog[Coming soon]. Before delving deep, I would like to highlight the fact, that you’ll NOT be charged for this User a/c by Microsoft. We’ll be barely creating a User, not assigning any license to it.
The entire process can be broadly classified into 4 major steps:
Open Windows PowerShell and enter the cmdlet,
"Connect-MsolService".
A dialogue will pop-up seeking the userId & password.
Provide an administrators credential here. Note, you’ll not be notified for wrong userID or password. In the event of providing wrong credential, the following cmdlets will refuse to run. So, make sure, that the credential is correct.
Once, the authentication is done, we’ll then create a new Office365 user. We’ll be providing basic user details, like FirstName, LastName, LoginID [or, UserPrincipal(compulsory)]. But, we’ll never set the password. The password will be returned back to us, once the user has been created. Another important thing to note here is the password policy we’re enforcing here. First, we’re setting, “ForceChangePassword” to false. This implies that when the User will login for the very first time, he/she will not be prompted to change it. Next, we’re setting “PasswordNeverExpires“, to true which, is pretty much self-explanatory.
Once the User has been created, its basic details like, UserPrincipalName, newly created Password, etc, will be displayed in the Shell. One can also specify their preferred password also by adding, “-Password “Password123” at the end of the above cmdlet.
Note: There can be multiple Users with identical DisplayName but not UserPrincipalName. It has to be unique.
This is simple. We’ll be assigning the “Service Support Administrator” role to this newly created User.
This role group is specific to Exchange. The objective is to assign only view permission to this user. To accomplish this, we’ll execute the cmdlet, “Add-RoleGroupMember“. One problem, this cmdlet is not a part of SharePoint Online Management Shell. So we cannot directly run it. We have to, first, establish a remote connection to the Exchange Server, and temporarily import it’s commands to the local PowerShell session. Only then, we can execute the cmdlet, “Add-RoleGroupMember“. Once the job’s done, we should also remove this session. To know more about this, plz visit the site, http://technet.microsoft.com/en-us/library/dd335083(v=exchg.150).aspx
Since, here, we’ll be executing a series of commands, I have put it all down in a script file. Here’s the content,
Say, we saved the file in D drive, with the name, addExchngViewRole.ps1. So to execute the same, just run from powershell, D:/addExchngViewRole.ps1. A dialog box will be prompted (same as above). Here again, you need to specify the admin’s credential. Once validated, it will import the Exchange commands.
Next, you’ll be asked to provide the PrincipalID or LoginName of the User who will be assigned to the RoleGroup, View-Only Organization Management [in this case, pk@company.onmicrosoft.com]. After that the user will be added to the given group and the current session will be removed from your machine, as per Microsoft’s guideline.
Note: ConnectionUri has been fixed to https://ps.outlook.com/powershell. This is valid for Exchange Online only. If you’re using on-premise, plz replace the url with this one, http:///PowerShell/.