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 |
No comments:
Post a Comment