Zynk Workflow Documentation

This task will export data using the Sage 50 SDO based on the settings you provide. This is mainly used to retrieve fields that are not available via ODBC.

Settings

Sage 50 Connection

Required
The connection to Sage 50 UK to use. See the Connecting to Sage 50 UK article if you require more information on how to create/manage connections.

Export Data Type

Required
The type of data you wish to export

Export Settings

Required

Fields

Required
The list of fields you wish to export.

Where

Required
The collection of where clauses you wish to append to your query.

Output File

Required
The name of the file to export to. Data is exported in Zynk XML format

Zynk Settings

See Common Task Settings

Examples

Sample output file:

<?xml version="1.0" encoding="utf-8"?>
<Company xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Records>
    <Record>
      <UniqueId>88</UniqueId>
      <Fields>
        <Field>
          <Name>INVOICE_NUMBER</Name>
          <Value>88</Value>
        </Field>
        <Field>
          <Name>ACCOUNT_REF</Name>
          <Value>JOE001</Value>
        </Field>
        <Field>
          <Name>EMAILED</Name>
          <Value>0</Value>
        </Field>
      </Fields>
    </Record>
  </Records>
</Company>

Back | Edit on Github