Read From Worksheet

This connector is used when reading data from office 365 worksheet.

Settings

• Authentication: A valid office 365 credential item
• File Location: The folder where the spreadsheet to be read from is located.
• Select Spreadsheet: The spreadsheet containing the data to be read
• Select Sheet: The sheet within the spreadsheet to be read.

Header Settings

These settings apply only to the header of the sheet.

• Replace Spaces with Underscores: This removes spaces in the header name and replaces them with underscores. e.g. "Month Of the Year" becomes "Month_Of_the_Year".
• Remove dots?: This removes dots from the header name. e.g. "Phone No." becomes "Phone No".
• Convert to lowercase: This converts the header to lowercase characters.

Output

{
  success: true,
  data: [], // Array of Objects containing the content of the selected sheet.
}