SharePoint 2013 (Office 365) REST API - Supported and NOT Supported Columns

Not all types of column are available via REST, most annoyingly managed metadata columns are amongst this group of unsupported column types. Further, not all types of column will return data for an entry just by including them in the $select parameter, an example of which is Lookup (single or multi-value) columns.

Column	Support	Notes
Hyperlink or Picture	Supported
Single Line of Text	Supported
Multiple lines of text :: Plaintext	Supported
Multiple lines of text :: Richtext	Supported	Returns unencoded XHTML
Multiple lines of text :: Enhanced Richtext	Supported	Returns unencoded XHTML
Choice	Supported	Column is required in the $expand keyword
Counter	Supported
Integer	Supported
Number	Supported
Currency	Supported
Date	Supported	Returns an ISO 8601 date e.g. 2013-03-08T11:00:00
Yes/No	Supported	Returns true or false string literals
Person or Group	Supported	Column is required in the $expand keyword, append “Id” to the column name to get the user id (UserInformationList) value inline with each entry
Person or Group (Multi)	Supported	Column is required in the $expand keyword
Calculated	Supported
Computed	Supported
Managed Metadata	Not Supported
Managed Metadata (Multi)	Not Supported
Publishing HTML	Not Supported
Publishing Hyperlink	Not Supported
Publishing Image	Not Supported
Media Field	Not Supported
Summary Links	Not Supported
Publishing Image	Not Supported
Lookup	Supported	Column is required in the $expand keyword, append “Id” to the column name to get the lookup column target id value inline with each entry
Lookup (Multi)	Supported	Column is required in the $expand keyword

Change SharePoint 2013 Online (Office 365) to use your local time zone

If you upload your documents only to find that your Modified time stamp is hours off, your SharePoint Online site may be using the wrong Regional Setting for your Time Zone. This is generally set to Pacific Time (US and Canada) by default. Here are the steps to correct it:

1. In your team site, click Site Actions.

2. Click Site Settings.

3. On the Site Settings page, under the Site Administration section, click Regional settings.

4. In the Time Zone section set the Time zone drop-down list to the appropriate zone for you.

5. Click OK.

SharePoint Page Layout Error: Only Content controls are allowed directly in a content page that contains Content controls

The cause is improper case for the control tags in my page layout.  A few contorls used a lower case "c" instead of an uppercase "C" in the word content.  The page layout that had trouble had tags that looked like: instead of .  The specific offending tag is the one associated with the page title (<asp:Content ContentPlaceholderID="PlaceHolderPageTitle"runat="server">).  The solution was as simple as correcting the case of the tag name and all worked well.