Adapter Properties and Commands

This section lists the properties and commands supported by the OneDrive 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 OneDrive. 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 the client secret of the user who has access to OneDrive. 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 the tenant ID. It is the ID of the unique identifier for the Azure Active associated with OneDrive.

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

Redirect URL

Specifies the redirect URL, which is the endpoint to which authentication responses are sent after the user sign-in. It is used to handle authentication callbacks and complete the login process.

The corresponding adapter command is -RU redirecturl (or –REDIRECTURL redirecturl).

Authorization URL

Specifies the authorization URL, which is the endpoint used to initiate the OAuth 2.0 authorization process. It directs users to sign in and grant permissions to the application.

The corresponding adapter command is -AU authorizationurl (or –AUTHURL authorizationurl).

Authorization Code

Specifies the authorization code, a temporary code received after user authentication. It is used to retrieve a refresh token to authenticate API requests.

The corresponding adapter command is -AC authorizationcode (or –AUTHCODE authorizationcode).

Refresh Token

Specifies the refresh token, which is used to obtain a new access token when the current one expires, allowing continued access to OneDrive without requiring the user to re-authenticate.

The corresponding adapter command is -RT refreshtoken (or –REFRESHTOKEN refreshtoken).

Drive

Specifies the document library for a OneDrive.The default value is OneDrive.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 property identifier is a file. 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. This property field is applicable when the Convert Data property toggle is enabled. Select one of the following as per the data format type.

CSV
Excel
Avro
Parquet
JSON

Header

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

Quote

Specifies the quote character. The default value is ".

Delimiter

Specifies the field delimiter character. The default value is ,.

Escape

Specifies the escape character.

Separator

Specifies the row separator characters. The default value is \r\n.

Character Set

Specifies the character set of the data. The 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. The 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".