Working with Integration Scripts

Integration Scripts

Integration scripts are the same as FPL Scripts used when creating Ebase Forms. See Working with FPL Scripts.

Integration scripts cannot be used to change display properties as there are no display to a user. Although the Integration Script will still process without an error if a display property is called from within an Integration Script e.g show/hide fields from FPL script.

Working with Integration Scripts

Integration scripts are only associated with Integration Services. The Integration Scripts can be found on the Designer Tree: Integration Server -> Integration Services -> Scripts. An Integration Script can be created from the main menu: File -> New -> Integration -> Integration Script.

Integration Scripts should be written to control any business rules and control any integration to business resources, such as Database Resource or External Resource, associated to the Integration Service.

The verify button can be used to syntax check the script.

The save button can be used to save the script.

The info button displays information about the script.

The documentation button displays documentation for the script to be maintained.

The help button displays the FPL script syntax page from the Help documentation.

Integration Service Tables and Forms

It is possible to call forms and other scripts from Integration Scripts.

fetchtable must be called from an Integration Script to read the contents of a table from an Integration Resource.

updatetable must be called from in an Integration Script to write the contents of a table back to an Integration Resource.

Web Service Specific System Variables

There are two Integration System Variables available to Integration Scripts:

− $WEB_SERVICE_OPERATION: This System Variable is set when an incoming request comes in for a specific Web Service call setting the operation name that has been invoked for that particular web service call.

− $INTEGRATION_CALL_SOURCE: This System Variable is set depending on how the Integration Service was called. There are four possible values :

o Web

o Designer

o Form

o Schedule (set from schedule task or ebasetrigger)

See FPL Script Syntax for more details on FPL scripting.