+1Hi FME fans,
I am using the MS Sharepoint List writer to update values - this is using Feature Operation 'Update' using Row Selection 'sharepoint item id'.
This works fine when I give it a new value, eg a different date, however if I set the value to null in FME the value in sharepoint doesnot change. How can I set the value to null?
Thanks,
Owen
+18
+1
+18
+10Can it be that the date field is an obligatory field and that null-values aren't accepted?
+1
+1Can it be that the date field is an obligatory field and that null-values aren't accepted?
+1After a few abortive attempts at ever more complex solutions to this precise problem (SharePoint list value needing to be cleared as an update) I have found a solution, at least for single line text fields.
Use a NullAttributeMapper to map null to a carriage return
The Writer then has “something” to write and so does include that in the JSON payload, but SharePoint ignores it since it isn’t valid.
No help for multiline fields of course but hopefully helpful.
Why it took me so long to think of this I don’t know, I’d tried mapping empty strings and all sorts of custom writers, but the simple solutions are the best.
