Python

The Python plugin enables running Python scripts compatible with the IronPython implementation.

Name

Give your data source a name

Metadata

On the meta data tab the expected results of the executing script must be configured.
By default the setting is to do auto-detection. This means that columns in the return data set will be automatically read the first time. However in some cases it is necessary to specify these manually.

Auto-detection - Return data types are automatically parsed and recognized when the data source is saved and thereby created.
Manual - Here the fields expected must be manually added with name and type.
Script - In scripting mode the destination variables are created as a scripting structure. An example already shows how an Id, a company name and a created date can be added.

Data

The data tab is where you can insert a Python script.

The last value of the script is what will be returned to TARGIT Data Service, for example will c(1,2,3,4,5) return a dataset with no data but the columns 1,2,3,4 and 5.

Note: When clicking check syntax the script is executed and not just parsed.

Schedule

Use this setting to determine how often you would like to refresh your data from this data source.