Readers: For information on the parameters in this dialog that are common to all readers, see:
Writers: For information on the parameters in this dialog that are common to all writers, see:
User attributes for this format are defined below.
Field Name
The name of the Field to be written.
Field Type
The table below specifies the types of Fields that the SharePoint Reader can read, and the types of Fields that the SharePoint Writer can create and write.
- Not implemented: The SharePoint Reader/Writer has not yet added support for the Field type.
- No: It is not possible to support the Field type.
Some Field types are only available for use within certain List types.
| Field Type | Read | Write | Description |
|---|---|---|---|
|
AllDayEvent |
No |
No |
|
|
Attachment |
Yes |
No |
Boolean stating whether an attachment exists on an Item |
|
Boolean |
Yes |
Yes |
True or False |
|
Calculated |
Yes |
Not implemented |
String representing a formula |
|
Choice |
Yes |
Yes |
String value. When the SharePoint writer creates a field of this type, the field is configured to allow free-form input, and the SharePoint web interface will not show a list of values to choose from. Use the SharePoint web interface to configure the values that appear in the web interface’s drop-down for this field. Note that SharePoint API allows writing arbitrary values to Choice fields, regardless of whether the field is configured to allow free-form input. The free-form input restriction only applies to the web interface. |
|
Computed |
Yes |
Not implemented |
String value that was generated by SharePoint |
|
ContentTypeId |
Yes |
No |
Integer value |
|
Counter |
Yes |
Yes |
32-bit signed integer value |
|
CrossProjectLink |
No |
No |
|
|
Currency |
Yes |
Yes |
Floating point value |
|
DateTime |
Yes |
Yes |
SharePoint stores values in UTC time zone only. The SharePoint web interface adjusts values to the local time zone. The SharePoint reader converts values to FME datetime format. The SharePoint writer accepts values in FME datetime format. If input values do not specify a time zone, the writer assumes the local time zone, adjusting for daylight saving time, if necessary. |
|
Error |
No |
No |
|
|
File |
No |
No |
|
|
GeoLocation |
Yes |
Yes |
String value that contains a latitude, longitude and an optional altitude, delimited by semicolons (for example, 45.0; 90.0; 100.0). Specifications for valid coordinates can be found in Microsoft documentation. |
|
GridChoice |
No |
No |
|
|
Guid |
Yes |
Yes |
String representation of a GUID |
|
Integer |
Yes |
Yes |
32-bit signed integer value |
|
Lookup |
Yes |
Yes |
Single integer ID, or a JSON list of integer IDs for fields that allow multiple values. The SharePoint Reader only retrieves IDs in Lookup fields, and does not support expanding values. The SharePoint Writer supports writing to existing Lookup fields, but not creating new Lookup fields. |
|
ModStat |
Yes |
Yes |
String value of the following options:
|
|
MultiChoice |
Yes |
Yes |
String value, where each choice is delimited by a semicolon. The SharePoint writer creates fields of this type in a manner similar to the Choice type. However, fields of this type may appear to be read-only when viewed from the SharePoint web interface. |
|
Note |
Yes |
Yes |
Contains HTML to allow for line breaks and other paragraph styling. |
|
Number |
Yes |
Yes |
Floating point value |
|
PageSeparator |
No |
No |
|
|
Recurrence |
No |
No |
|
|
TaskOutcome |
Yes |
Yes |
String value |
|
Text |
Yes |
Yes |
Single line of text |
|
ThreadIndex |
No |
No |
|
|
Threading |
No |
No |
|
|
URL |
Yes |
Yes |
String value, where either a forward slash or one of the following URL schemes is required: file://, ftp://, http://, https://, mailto://, mms://, news://, nntp://, rtsp:// |
|
User |
Yes |
Yes |
String value of a valid SharePoint site user. Strings that represent invalid users (that is, they do not exist) will not be written. |
|
WorkflowEventType |
Yes |
Yes |
Numeric string literal |
|
WorkflowStatus |
No |
No |
|