For information on the parameters in this dialog that are common to all readers, see:
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 |
|---|---|---|---|
| Integer | Yes | Yes | 32-bit signed integer value |
| Text | Yes | Yes | Single line of text |
| Note | Yes | Yes | Contains HTML to allow for line breaks and other paragraph styling |
| 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. |
| Counter | Yes | Yes | 32-bit signed integer value |
| 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. |
| Lookup | Not implemented | Not implemented | |
| Boolean | Yes | Yes | True or False |
| Number | Yes | Yes | Floating point value |
| Currency | Yes | Yes | Floating point value |
| 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:// |
| Computed | Yes | Not implemented | String value that was generated by SharePoint. |
| Threading | No | No | |
| Guid | Yes | Yes | String representation of a GUID |
| 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. |
| GridChoice | No | No | |
| Calculated | Yes | Not implemented | String representing a formula |
| File | No | No | |
| Attachment | Yes | No | Boolean stating whether an attachment exists on an Item |
| 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. |
| Recurrence | No | No | |
| CrossProjectLink | No | No | |
| ModStat | Yes | Yes | String value of the following options: Approved, Rejected, Pending, Draft, Scheduled (case-insensitive) or an integer value from 0 to 4 inclusive, representing the strings listed above. |
| Error | No | No | |
| ContentTypeId | Yes | No | Integer value |
| PageSeparator | No | No | |
| ThreadIndex | No | No | |
| WorkflowStatus | No | No | |
| AllDayEvent | No | No | |
| WorkflowEventType | Yes | Yes | Numeric string literal |
| 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. |
| TaskOutcome | Yes | Yes | String value |