Skip to main content
  • EN

Hi 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

Hi Owen, this sounds logical since a null value will not be found in the item id, or am I missing something?

 

 

Hi Owen, this sounds logical since a null value will not be found in the item id, or am I missing something?

 

 

Hi Itay, no this isnt updating the item id, but other attributes. Basically I want to clear these attributes out, not update them but setting the values to null doesnt trigger any change

 

 

Hi Itay, no this isnt updating the item id, but other attributes. Basically I want to clear these attributes out, not update them but setting the values to null doesnt trigger any change

 

 

Any chance 'missing' or empty values work better?

 

 

Can it be that the date field is an obligatory field and that null-values aren't accepted?

Any chance 'missing' or empty values work better?

 

 

No, joy with missing or empty values

 

 

Can it be that the date field is an obligatory field and that null-values aren't accepted?

Hi Lars, thanks but no it can have blank/null values in the field

 

 

@owen​ did you ever find a solution? I'm facing the same issue

After 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.

Reply


Community Stats

30,351
Posts
115,341
Replies
38,080
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.