Configuring the Components - 6.5

Talend Cloud

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Talend Cloud components
Data Quality and Preparation > Third-party systems > Talend Cloud components
Design and Development > Third-party systems > Talend Cloud components
EnrichPlatform
Talend Studio

About this task

The input file in Dropbox contains some information about customers:

Procedure

  1. Double-click tDropboxConnection to open the component basic settings view.
  2. In the Access Token field, press Ctrl + Space to get the list of available parameters and select context.connection_dropbox_access_token.
    For further information about how to define/import context parameters, see Setting context parameters.
  3. Double-click tDropboxGet to open the component basic settings view.
  4. Select the Use Existing Connection check box and select the tDropboxConnection component used in the Job from the list.
  5. In the Path field, press Ctrl + Space to get the list of available parameters and select context.parameter_download_path.
    For further information about how to define/import context parameters, see Setting context parameters.
  6. Click Edit schema and define two schema columns: fileName and content. Set the type of the content column to Object.
  7. Double-click tFlowToIterate to open the component basic settings view and select the Use the default (key, value) in global variables check box.
    The system uses the default value of the global variable in the current Integration Action.
  8. Double-click the first tJobLog component and set the following parameters in the component basic settings:
  9. Double-click tFileInputExcel and set the following parameters in the component basic settings:
    • In the File name/Stream field, press Ctrl+Space and from the global variable list select tFlowToIterate_1.content to add the following value in the field ((Object)globalMap.get("row1.content")).

    • Add one column in theSheet list table and define the sheet you want to process.

    • Set 1 in the First column to process the first sheet.

    • Create the schema through the Edit Schema button and set the data type in the Type column.

      Accept to propagate the changes when prompted. This passes the schema you define to the next component in the Job, namely tActionOutput.