Hello,
I want files that are uploaded in attachment type fields to be automatically transferred and stored in the appropriate SharePoint folder with below acceptance criteria.
Successful transfer
- Given a user uploads a file in ServiceNow to the configured storage action,
- When the upload completes successfully, Then the copy of the same file should be uploaded in the SharePoint folder.
Folder mapping
- Given a ServiceNow record with a target SharePoint folder mapping,
- When a file is uploaded for that record, Then the file must be placed in the mapped SharePoint folder (not a default or root folder)
Error notification
- Given the transfer to SharePoint fails,
- When the failure is detected, Then ServiceNow must record an error on the originating record and notify the configured admin group with an error summary
No duplicate orphan
- Given the transfer fails mid-process,
- When the file is not fully created in SharePoint, Then no partial or orphan file must be left in the SharePoint folder (or it must be automatically rolled back/cleaned)
Filename preservation
- Given a file with a filename and extension is uploaded in ServiceNow,
- When it is copied to SharePoint, Then the file name (including extension and case) must be identical in SharePoint.
Character set
- Given a filename containing special characters permitted by SharePoint,
- When transferred, Then those characters must be preserved
Conflict handling (same name)
- Given a file with the same name already exists in the target SharePoint folder,
- When the new file is transferred, Then the system must create a new version of the existing file (SharePoint versioning) rather than silently overwriting or failing. The operation must preserve both file contents and the original filename.
Permission enforcement
- Given a file exists in the SharePoint folder,
- When a user without access attempts to view the file, Then SharePoint must deny access (403 / Access Denied)
Thanks....
