Overview

TIBCO ActiveMatrix BusinessWorks™ Plug-in for Microsoft SharePoint plugs into TIBCO ActiveMatrix BusinessWorks™. You can use the plug-in to add, delete, update, and query data in the Microsoft SharePoint On-Premises server and Microsoft SharePoint Online server and listen to events that are triggered in the Microsoft SharePoint Online or On-Premises server.

TIBCO ActiveMatrix BusinessWorks™ is a leading integration platform that can integrate a wide variety of technologies and systems within enterprise and on cloud. TIBCO ActiveMatrix BusinessWorks™ includes an Eclipse-based graphical user interface (GUI) provided by TIBCO Business Studio™ for BusinessWorks™ (hereinafter referred to as "TIBCO Business Studio") for design, testing, and deployment. If you are not familiar with ActiveMatrix BusinessWorks™, see the TIBCO ActiveMatrix BusinessWorks™ documentation for more details.

ActiveMatrix BusinessWorks™ Plug-in for Microsoft SharePoint plugs into TIBCO ActiveMatrix BusinessWorks™ and adds SharePoint REST Palette to TIBCO Business Studio. You can create a connection between the plug-in and Microsoft SharePoint server, and then configure a process using the activities in the SharePoint REST palette to manage and query data in the Microsoft SharePoint server, and publish events and refresh data from external systems.

Note: The activities in the Microsoft SharePoint REST palette use REST API calls to communicate with the server.

Communication between the Plug-in and Microsoft SharePoint Server

The plug-in with REST Palette activities communicates with the Microsoft SharePoint server through REST API calls over HTTP or HTTPS.

When the plug-in queries REST metadata from the Microsoft SharePoint server, the plug-in communicates with the Microsoft SharePoint server through REST API calls over HTTP or HTTPS.

When the plug-in manages data, such as adding, deleting, updating, and deleted list items in the Microsoft SharePoint server, the plug-in communicates with the Microsoft SharePoint server through REST API calls over HTTP or HTTPS.

When the plug-in listens to events occurring in the Microsoft SharePoint server, the plug-in communicates with the Microsoft SharePoint server through the HTTP or HTTPS servers. The REST HTTP Notification listener activity can use either the HTTP or HTTPS communication mode to communicate with a Microsoft SharePoint server when receiving user event messages.

Main Functions of the Plug-in

For SharePoint REST Palette, the plug-in mainly provides the following functions:

  • The SharePoint REST Connection shared resource can be reused for the SharePoint REST Get Metadata tool and different activities.
  • You can use the SharePoint REST Get Metadata tool to get Microsoft SharePoint Rest metadata, which is used to configure various Microsoft SharePoint REST activities at design time.
  • You can use the SharePoint REST HTTP Notification Listener activity to listen to the events triggered on the Microsoft SharePoint server, such as adding, updating, deleted and deleting a list item. You can also use the activity to work with other activities to fetch data and populate the custom list with the data from an external source.
  • You can use the SharePoint REST Add ListItem, SharePoint REST Delete ListItem, and SharePoint REST Update ListItem activities to add, delete, and update list items in the Microsoft SharePoint servers. These activities also support adding, deleting, and updating multiple list items at a time using successive REST API calls but not using REST batch API calls.
  • You can use different query conditions to select list items that belong to a specific list type from the Microsoft SharePoint server through the SharePoint REST Select ListItem activity.
  • The SharePoint HTTP Notification Configuration Management tool is used to support the SharePoint HTTP Notification Listener activity. The tool is deployed on the Microsoft SharePoint server after you install the .NET solution components packaged within the ActiveMatrix BusinessWorks Plug-in for Microsoft SharePoint installer. You can use the SharePoint HTTP Notification Configuration Management tool to configure HTTP and destination information, set notification types, configure event handlers, and refresh data information.