PolyDict Functions

Overview

Knowledge is power! PolyDict functions are how we make automation happen. Each function is assigned to the appropriate data connection and can perform the necessary actions requested at the connection point. A function is triggered via the Webservice API Interface or the task scheduler, and the results are returned to the source trigger. Each function can be enabled via the Webservice API and can optionally log whenever it is triggered. Here are the 5 types of functions available:

Select

You can use standard query language to retrieve data tables from your chosen data connection. Parameters can be created to allow third-party systems to request specific data, and these parameters can be used within the command. The Select function can return up to two data tables simultaneously. So, if, for example, a function was returning a list of products, then a single table would be suitable. But if it were returning details relating to a customer invoice, then it would be appropriate to utilize two data table returns; sending the invoice header and the invoice row information.

Update

Again, it is possible to apply standard query language to change your chosen data via its configured connection. Employ user-supplied parameters within the command, and the results and any errors or warnings are returned within the response.

Insert

Like the Update command type described above, this time creating new records within your required dataset.

Delete

Instructs the deletion of entire rows of records from your dataset.

VB.Net

Used when associated with a VB.Net data connection, programmers can enter uncompiled VB code to allow refined control over the data connection in use. This function type also allows for additional programming references, such as third-party SDK libraries. The "Compile" button will enable you to test your code for syntax and referencing errors before they get used.