I have a workspace that reads from non-SharePoint sources and writes to SharePoint. I am using a change detector along with fme_db_operation to insert, delete, or update accordingly. However, I recently noticed an error message that the updates were not updating and required a sharepoint_item_id.
1) Is there a way to update SharePoint without the sharepoint_item_id, perhaps on a separate unique attribute, or is sharepoint_item_id mandatory?
2) If 1) requires sharepoint_item_id, what is the best way to attach sharepoint_item_id to records. I can imagine a reader, then join, but wondering if there is a best practice for these cases.
Thank you,
Tyler
