This node writes a KNIME table to a SharePoint list.
Notes:
- Writing tables with more than a few hundred rows can take long time. Overwriting an existing table can be also very slow in case a lot of rows need to be deleted.
- This node exports the ID of the written list to a flow variable called sharepoint_list_id . The ID can be be used in subsequent nodes to control the list setting via flow variable.
KNIME column type support
Fully supported KNIME column types:
- String and string-compatible columns map to Multiple lines of text
- Integer columns map to Number
- Boolean columns map to Yes/no
Partially supported KNIME columns types:
- Long columns map to Number . The node will fail for more than 15 significant digits (digits which remain after leading and trailing zeros are removed, i.e. in "401220500000" the digits "4012205" are significant and in "0.0004050114" the digits "4050114" are significant).
- Double columns map to Number . The node will fail for infinity, NaN and values outside of [1.79E308,-1.79E308], as well as for numbers with more than 15 significant digits.
- Local Date and Local Date Time columns map to Date and Time , which stores a UTC timestamp with second-precision. Hence, values from KNIME are mapped to an instant in UTC and truncated to second-precision. For example, 2022-02-02 08:00:00 is stored as 2022-02-02 08:00:00 UTC. The node will fail for values before 1900-01-01 00:00:00 UTC and after 8900-12-31 23:59:59 UTC.
- Zoned Date Time columns map to Date and Time , which stores a UTC timestamp with second-precision. Hence, Zoned Date Time values are converted to the UTC timezone and truncated to second-precision. For example, 2022-02-02 08:00:00 CET is stored as 2022-02-02 07:00:00 UTC. The node will fail for values before 1900-01-01 00:00:00 UTC and after 8900-12-31 23:59:59 UTC.
Unsupported KNIME column types:
All column types that do not belong to the above categories are unsupported and the node cannot be executed, since there is no corresponding type in SharePoint Online.