1 403 355 8901 info@guild1.com
Query Database

Query Database

This action executes an ad hoc query against a database to create a table containing the results of the query. If the optional key list is input, you can use the ${key.name} syntax to substitute key values in your query. If no key list is input, the query is run once...
List Files

List Files

This action generates a list of the absolute path of the files and folders from the specified directory. Best Practice: This action can be used in conjunction with the Get User Input (Page 152) action where the user is prompted to enter in a folder path. Field...
Import XML From File or URL

Import XML From File or URL

This action reads XML from a file or URL and outputs it as XML data. Field Description Label A label to identify the action. This label appears under the Action name inside the Action box. If this field is left blank, the default value is “Untitled.” Description A...
Import Table From URL

Import Table From URL

This action imports a specified file or URL and converts it into a Synergy table. Supported types include Excel (*.xls), Excel_XML(*.xlsx), CSV, and delimited data. Field Description Label A label to identify the action. This label appears under the Action name inside...
Import Table From File

Import Table From File

This action imports a specific file into a Synergy table. Supported file types include Excel, CSV, and delimited text files. Field Description Label A label to identify the action. This label appears under the Action name inside the Action box. If this field is left...