Python Script General

Basic Information

Description	This node is used to execute python script and producing either files and/or tables
Input	A list of tables
Output	List of tables and/or files
Usage Tags	PYTHON , TRANSFORMATIONS

Node Settings

InputTables ( List<string>, optional) : A list of in process tables that will be used as a input in the do_work function.
JsonParameters (json, optional) : A json structure where some script parameters can be configured. This json will be available as the input argument of do_work function.
Script (string, required): A python script that processes given files. Follow Python Scripting documentation for syntax.

The Script must define a function do_work(tables, *kwargs) that returns the following object

PY

{
  "tables" : {
    "table1_name" : [], # A list of records in table1
    "table2_name" : []  # A list of records in table2
  },
  "files" : {
    "file_name.ext" : "base_64_encoded" # A base64 encoded file content
  }
}

Tips and Advanced usage

For more details and examples see Python Scripting