tSharePointInput | Talend Components for Jobs Help
Skip to main content Skip to complementary content
Qlik Resources
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal

tSharePointInput

Last updated: 9/30/2026
Reads files from a SharePoint directory or reads a single SharePoint file using the configured format.

tSharePointInput Standard properties

These properties are used to configure tSharePointInput running in the Standard Job framework.

The Standard tSharePointInput component belongs to the Business and Cloud families.

The component in this framework is available in all Talend products.

Basic settings

Properties Description
Connection Component Reuse a tSharePointConnection component for authentication and connectivity.

Property Type

Select the way the connection details will be set.

  • Built-In: The connection details will be set locally for this component. You need to specify the values for all related connection properties manually.

  • Repository: The connection details stored centrally in Repository > Metadata will be reused by this component.

    You need to click the [...] button next to it and in the pop-up Repository Content dialog box, select the connection details to be reused, and all related connection properties will be automatically filled in.
Use an existing connection

Select this check box and in the Component List drop-down list, select the desired connection component to reuse the connection details you already defined.
Schema and Edit schema

A schema is a row description. It defines the number of fields (columns) to be processed and passed on to the next component. When you create a Spark Job, avoid the reserved word line when naming the fields.

  • Built-In: You create and store the schema locally for this component only.

  • Repository: You have already created the schema and stored it in the Repository. You can reuse it in various projects and Job designs.

Click Edit schema to make changes to the schema. If you make changes, the schema automatically becomes built-in.

  • View schema: choose this option to view the schema only.

  • Change to built-in property: choose this option to change the schema to Built-in for local changes.

  • Update repository connection: choose this option to change the schema stored in the repository and decide whether to propagate the changes to all the Jobs upon completion.

    If you just want to propagate the changes to the current Job, you can select No upon completion and choose this schema metadata again in the Repository Content window.

This component offers the advantage of the dynamic schema feature. This allows you to retrieve unknown columns from source files or to copy batches of columns from a source without mapping each column individually. For further information about dynamic schemas, see Dynamic schema.

This dynamic schema feature is designed for the purpose of retrieving unknown columns of a table and is recommended to be used for this purpose only; it is not recommended for the use of creating tables.
Guess schema Click this button to infer the schema from the file. If your file contains a header, click Set header first and configure it before guessing the schema.
Site Specify or select the SharePoint site.
Path Enter the path of the SharePoint directory to read.
File format Select the format used to read the files. Supported formats are CSV, Excel, Avro, and JSON.
Format configuration Configure the selected file format (separators, encoding, header, etc).
Input mode Read all files in a directory that match the configured format, starting with the first file, or read a single file.

Advanced settings

Properties Description
tStatCatcher Statistics Select this checkbox to collect the log data at the component level.
Escape character and Quote character
  • Escape character: Enter the character you want to be used as the escape character. The escape character used by default is \.
  • Quote character: Enter the character you want to be used as the quote character. The quote character used by default is ".

These options are available if you select CSV from the File format list in the Basic settings view.
Skip empty lines Select this option to prevent the component from generating an output record when the line of the CSV file is empty.

This option is available if you select CSV from the File format list in the Basic settings view.

Define a value for 'null' By default, the CSV format can only handle empty strings, not null values.

Select this option to enter a string that represent null values in the CSV file in the Value that represent ‘null’ field. When this value is found for a column or a row, this will generate a null value in the generated record.

This option is available if you select CSV from the File format list in the Basic settings view.

Usage

Usage guidance Description
Usage rule This component can reuse tSharePointConnection. No Close component is needed.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here