1 Reply Latest reply on Jul 12, 2018 6:37 AM by Thomas Righele

    Delete List Event using SharePoint Connector

    Thomas Righele Active Member

      Hello all-

       

      I am having an issue when deleting data using our SharePoint connector.

       

      To give the full background, we are pulling information from a SQL table and using it to populate the SharePoint calendar. This part I have gotten to work okay. I am able to upsert the information using the connector.

       

      However, the problem we have is keeping these tables in sync. If the SQL table has a row removed, we need it removed from the SharePoint calendar.

       

      I created a new mapping that compares the two sources (SQL and SharePoint calendar) and outputs which IDs are different. I then try to send this information through the connector to delete the IDs in SharePoint. As a test, I first sent this information to a flat file and it looks fine to me:

       

      "ContentTypeID","Id","ContentType"

      "0x01020092B6293F1C347F408568091C2AA57685","840","Event"

      "0x01020092B6293F1C347F408568091C2AA57685","850","Event"

      "0x01020092B6293F1C347F408568091C2AA57685","220","Event"

      "0x01020092B6293F1C347F408568091C2AA57685","221","Event"

       

      However when I run the delete operation through the connector, it comes back with 0 rows processed and successful. The calendar events still exist in SharePoint.

       

      Anyone have any ideas as to what this might be?

       

      Some troubleshooting I've done so far:

      -Ensured all field types are the same from source and target

      -Ensured that Ids do exist in SharePoint

       

      Any help is greatly appreciated!!

       

      Thanks,

      Tom