This section covers data type conversions between the and SharePoint.

NOTE: The listed in this page reflect the raw data type of the converted column. Depending on the contents of the column, the Transformer Page may re-infer a different data type, when a dataset using this type of source is loaded.

Access/Read

NOTE: Image, Link, and Address fields from SharePoint are imported into as JSON strings. Incorrect formatting or modification of these strings within the product may result in errors when published back to SharePoint Lists.


Source Data TypeSupported?

Notes
Choice (menu)YString
CurrencyYFloat
Date and TimeYDatetime
Link and ImageYString (JSON)
LookupYString
AddressYString (JSON)
Multiple lines of textYStringLines in the source are demarcated in the String value using the newline character.
NumberYFloat
Person or GroupYString (JSON)
Single line of textYString
Task outcomeYString
Yes/NoYBoolean

Publish/Write

SharePoint List Data TypesNotes
String

String

Note

Text

Varchar

URL

Choice

 

NOTE: Secondary types are published only if appending or truncating an existing table. See below.

IntegerInteger 
Decimal

Float

Currency

 
DatetimeDate and Time
BoolBoolean 
Map

Note

String

Text

Varchar

NOTE: Secondary types are published only if appending or truncating an existing table. See below.

Array

Note

String

Text

Varchar

NOTE: Secondary types are published only if appending or truncating an existing table. See below.

All other data typesString 

For more information, see http://cdn.cdata.com/help/RSF/jdbc/pg_datatypemapping.htm.

Depending on the publishing action, output data types may vary.

Appending or truncating a SharePoint List:

If you are appending or truncating an existing SharePoint List, all column data types are published to the target data types as expected, as long as the data being published can be parsed and published by SharePoint.

Writing to a new SharePoint List:

Some data types in  do not have a direct mapping to SharePoint List data types. Examples: