Procedure
- Double-click tDropboxConnection to open the component basic settings view.
-
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.
- Double-click tActionInput to open the component basic settings view.
- Click Edit schema and define the schema columns: First_name, Last_name, Address, zip, City, Country and Gender.
- Set the data type in the Type column and click OK.
- Accept to propagate the schema to all other components in the Job when prompted.
-
Double-click tFileOutputExcel and set the
following parameters in the component basic settings:
-
Select the Use Output Stream check box.
In the File name/Stream field, press Ctrl+Space and from the global variable list select tDropboxPut_1.OUTPUTSTREAM to add the following value in the field ((java.io.OutputStream)globalMap.get("tDropboxPut_1_OUTPUTSTREAM")).
-
-
Double-click tDropboxPut to open the
component basic settings view.
- Select the Use Existing Connection check box and select from the list the tDropboxConnection component used in the Job.
- For the Upload Mode, select the Rename if Existing option.
- Select the Expose As OutputStream option to upload data to Dropbox as a data flow.