Question

Update sharepoint list

owen
Badge +1

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

7 replies

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

 

 

owen
Badge +1
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

 

 

itay
Rank
Badge +16
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?

 

 

lars_de_vries
Badge +10

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

owen
Badge +1
Any chance 'missing' or empty values work better?

 

 

No, joy with missing or empty values

 

 

owen
Badge +1

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

 

 

E

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

Reply


Community Stats

28,692
Posts
109,432
Replies
36,543
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.