Use the Update Lists activity to update lists in MS SharePoint.
About this task
Use this task to update list properties like Title 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 Update
Lists activity. The Update Lists activity will be added to the orchestration.
Double click the activity. The MS SharePoint Update Lists Checklist is
displayed.
- In the Checklist, click Retry. Review the default settings and make the
required changes.
- 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:
- updateBy (Valid values are LIST_ID and LIST_TITLE)
- listId (Required if updateBy is given as LIST_ID)
- listTitle(Required if updateBy is given as LIST_TITLE)
- NewTitle
Sample Input Request
<?xml version="1.0" encoding="UTF-8"?>
<UpdateList xmlns="http://www.IBM.com/xmlns/prod/websphere/j2ca/Sharepoint/updatelist">
<!-- 1. updateBy value as LIST_TITLE -->
<UpdateListRequestDetails xmlns="">
<updateBy>LIST_TITLE</updateBy>
<listTitle>List100</listTitle>
<NewTitle>UpdatedTitle</NewTitle>
</UpdateListRequestDetails>
<!-- updateBy value as LIST_ID -->
<UpdateListRequestDetails xmlns="">
<updateBy>LIST_ID</updateBy>
<listId>087176c2-a1b9-4c97-b7fd-17787d6797de</listId>
<NewTitle>Test Title Updated</NewTitle>
</UpdateListRequestDetails>
</UpdateList>
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 Update Lists activity.
Note: You can update properties of multiple lists at one go using this activity since the input
variable is unbounded.