Adapter Properties and Commands

This section lists the properties and commands supported by the SharePoint adapter.

When configuring a connection, card, action, or node for the adapter in the web UI, the adapter command line is assembled automatically behind the scenes when the map or flow is compiled.

The direct use of the adapter command line is required when using the GET and PUT map rules to utilize the adapter, or when card inputs and outputs need to be overridden when invoking the maps programmatically or at the command line level.

Client ID

Specifies client ID of the user who has access to SharePoint. It is the ID of the application that will connect to the Microsoft Azure Active Directory.

The corresponding adapter command is -CI clientid (or -CLIENTID clientid).

Client Secret

Specifies client secret of the user who has access to SharePoint. It is the key that will be used as the secret in the connection.

The corresponding adapter command is -CS clientsecret (or -CLIENTSECRET clientsecret).

Tenant ID

Specifies tenant ID. It is the ID of the Microsoft Azure Active Directory to retrieve information.

The corresponding adapter command is -TI tenantid (or -TENANTID tenantid).

Site

Specifies the site resource that provides metadata and relationships for a SharePoint site.

The corresponding adapter command is -SI site (or -SITE site).

Drive

Specifies the document library for a SharePoint site. It represents a logical container of files or folders.

The corresponding adapter command is -DR drive (or -DRIVE drive).

Folder

Specifies the folders residing under a drive. It contains file objects.

The corresponding adapter command is -FO folder (or -FOLDER folder).

File

Represents an item within a drive, like a document.

The corresponding adapter command is -FI file (or -FILE file).

Read Chunk Size (Bytes)

Assigns chunk size to read the data in chunks.

The corresponding adapter command is -RCS readchunksize (or -READCHUNKSIZE readchunksize).

Convert Data

Specifies to convert data to parsed form. If the property is enabled, it supports converting CSV, Avro, Excel, Parquet, and JSON documents into sets of data records in the CSV format. This means that the data produced by the converters can be loaded directly into relational databases.

Data Format

Specifies the data format. This is a mandatory property. Select one of the following as per the data format type. This property field is applicable when Convert Data property toggle is enabled.

  • CSV
  • Excel
  • Avro
  • Parquet
  • JSON
Header

If enabled, specifies whether the CSV data contains a header row.

Quote

Specifies the quote character. Default value is ".

Delimiter

Specifies the field delimiter character. Default value is ,.

Escape

Specifies the escape character.

Separator

Specifies the row separator characters. Default value is \r\n.

Character Set

Specifies the character set of the data. Default value is UTF-8.

Limit

Specifies the maximum number of records to return.

Sample Size

Specifies the number of records to analyze when determining the data structure. Default value is 100.

Worksheet Index

Specifies the index of the worksheet. The index of the first worksheet is 1 (default).

Select Source Tables

Select which arrays of objects in the AVRO data you wish to map to tables in the target.

Find Array

If enabled, specifies that the output will iterate on the first array found in the JSON document.

Array Path

Specifies the path of the JSON array within the document. Omit if the document is an array. For example, "/resources".