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) turn 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

Decide how often you would like to schedule the data to refresh.