Use the Delete Attachments activity to delete attachments of list item for existing lists
in MS SharePoint.
About this task
Use this task to delete attachments of list item for existing lists in MS SharePoint instance.
The call to this activity is a synchronous call where the input data is sent to the activity for
processing and the response is sent back to the orchestration.
Procedure
- Right click the Orchestrations section and select new orchestration.
- Drag the newly created MS SharePoint endpoint to the orchestration and select Delete
Attachments activity. The Delete Attachments activity will be added to the
orchestration. Double click the activity. The MS SharePoint Delete Attachments
Checklist is displayed.
- In the Checklist, click Retry. Review the default settings and make the
required changes.
- In the Checklist, click Configure. Click
Browse. The List Selection Dialogue is displayed with Lists of only supported
base templates which includes base template id as 100, 105 and 120. Select a List and Click
OK.
- Select the Map Inputs in the Checklist. The XML
Schemas generated from that operation are displayed as nodes under the request input parameter in
the To Activity panel.
- Create a map between the orchestration variables and the input parameter of the activity.
Mandatory Fields:
- itemId (Id of the item for which user wants to delete an attachment)
- filename (name of the file attached to the item)
Sample Input Request
<?xml version="1.0" encoding="UTF-8"?>
<DeleteAttachments xmlns="http://www.IBM.com/xmlns/prod/websphere/j2ca/Sharepoint/deleteattachments">
<DeleteAttachmentsRequestDetails xmlns="">
<itemId>4</itemId>
<fileName>test123.txt</fileName>
</DeleteAttachmentsRequestDetails>
</DeleteAttachments>
Note: Values must be provided at run time for the mandatory elements of the input structure. A
value can be provided by specifying a default value for element or by linking the element with an
input node. During run time if no value is provided for a mandatory element, the activity throws an
exception, which is reported by the Web Management Console. If a value is not provided at run time
for an optional input parameter, no exception is thrown during run time.
- Select the Map Outputs in the Checklist. The XML
Schema generated to hold the response of the activity is displayed as nodes under the response
output parameter in the From Activity panel.
- Create a map between the output parameters and orchestration variables.
Results
You have configured the MS SharePoint Delete Attachments activity.
Note: You can delete multiple attachments at one go using this activity since the input variable is
unbounded.
Limitation for Custom Fields for a List:
Even though SharePoint supports custom fields starting with a digit or having space in field
names, App Connect Studio will fail to support them. This holds true for CRUD activities for List
Items and Attachments activities.
Note: If there is a change in schema (for example the list is changed from Configure section) the
default values set for previous lists are retained for the fields in Map Inputs. It is advisable to
do the mapping again in this case whenever the list is changed.
Note regarding Expand occurrences functionality:
There is a discrepancy in populating the Map Input section of the CRUD activities when user
selects the Expand Occurrences option for a recurring node. The details of the same are mentioned in
the below link: https://developer.ibm.com/answers/questions/251002/reselecting-the-same-objectfor-which-expand-occure.html#answer-251011.