Salesforce

SharePoint - XML (Magic xpi 3.x)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

SharePoint - XML (Magic xpi 3.x)

The SharePoint connector is designed to work with Magic xpi’s XML interface. When you drag the SharePoint component into a flow, the Component Properties dialog box opens. Click Configuration to open the SharePoint Configuration dialog box.

This dialog box contains the following fields:

Property

Description

Connection

Resource Name

The name of the resource, previously defined in the Resource Repository, that you selected in the Component Properties dialog box's Settings tab.

Operation

Entity Type

The entity type that you want to work with. Select one of the following types from the drop-down list:

  • List (default): This is used to manipulate items and attachments. You can query, add, update, and delete items and attachments.

  • Libraries: This is used to manipulate documents in the SharePoint server. This is a specialized list type, and is therefore supported by Lists and Libraries. Documents can be uploaded into SharePoint, moved to and from different locations on the server, and can also be queried, deleted, and updated. (Since version: V3.2 SP3)

Entity

Click to open the Lists Collection dialog box. Select the entity that the operation will be performed on.

Operation

Select one of the following operations from the drop-down list:

  • Query: This is used to retrieve data from an entity. You can use the Data Mapper to retrieve entities based on specific criteria. For example, you can retrieve all contacts with Title = Professor.

  • Add: This is used to add new entities to your organization’s data. You can use the Data Mapper to specify new entity fields’ values.

  • Update: This is used to update a specific entity in your organization’s data. When you update an entity, you need to know its ID. For example, you can use the Query operation (above) to retrieve an entity ID, and then you can call the Update operation. You should use the Data Mapper to set the entity ID, as well as the other fields that you want to update.

  • Delete: This is used to delete a specific entity from your organization’s data. If you want to delete an entity, you need to know its ID. For example, you can use the Query operation (above) to retrieve an entity ID, and then you can call the Delete operation. You should use the Data Mapper to set the entity ID. This is the only value that you should set.

  • Move: This is used to move documents to and from different locations on the SharePoint server. This operation is available only when you select the Libraries Entity Type (above). (Since version: V3.2 SP3)

Return Fields

This is only available when you select an entity in the Entity field, and the Operation field is set to Query. This determines the fields that are returned by the query.

Select one of the following from the drop-down list:

  • All (default): Returns all of the fields in the query.

  • Selection: Returns specified fields only. To select the fields that you want to return, click to select fields from the Entity Fields List. You must select at least one field from the list.

  • By View: Returns fields according to the specified view. To select the required view, click to open the Views Collection dialog box. If no view is selected, the default view is automatically used.

Since version: V3.2 SP1b

Folder

This is available when you select Query, Add, or Update in the Operation field. Records can be organized in specific folders. This field enables you to query all records in a specific folder when you supply the folder's name.

Click to open the Expression Editor and enter the name of the folder.

Include Attachments

This is only available when you select Query in the Operation field.

If the list item has attachments, and if this field is checked, the attachments are returned as Base64 in the result XML. If this field is unchecked, only the attachment name and its URL (if it has one) are returned.

Since version: V3.2 SP1b

Result Options

Store Result In

Defines where you want to store the resulting XML file. Select one of the following from the drop-down list:

  • Variable: Select a variable to hold the entity data that is returned by SharePoint.
    Click to open the Variables List. Select a variable where this information is to be stored (the default is C.UserBlob).

  • File: Select a file to hold the entity data that is returned by SharePoint
    Click to open the Expression Editor, or click and enter the file path where this information is to be stored.

Operation Success

This field lets you easily determine if the data entity was successfully located in SharePoint. Select one of the following from the drop-down list:

  • None: Select this option if you do not want to save the connector’s success or failure status.

  • Variable: Click to open the Variables List. Select the variable where you want to store the connector's success or failure status.

Reference
Attachment 
Attachment