Skip to content

Importing Activities via ConnectWise REST Interface

This task will import activities into ConnectWise from an XML file. See below for a sample input file.

Records are created/updated based on the following rules:

  • If an <id> is specified, the task will update the record with this ID.
  • If an <externalId> is specified, and a corresponding entry is found in Zynk's truth table, the task will update the record with this ID.
  • If one or more <lookup> elements have been specified, Zynk will search for a match based on each one in turn, and will update the first matching record it finds.
  • If none of the above conditions are met, the task will create a new record.

When updating existing records, only writeable fields specified in the input file will be updated. Any other fields will keep their existing values.

Settings

ConnectWise REST Interface Connection

Required
The ConnectWise REST Interface connection to use. See the Connecting to ConnectWise REST Interface article if you require more information on how to create/manage connections.

Fail File

Required
The XML file to output any records that the task fails to process to. This can be an absolute or relative file path on the local computer or network. This will contain any errors which occur on the import.

Defaults to connectwise_import_activities_fail.xml

Input File

Required
The file containing the records to import into ConnectWise. This can be an absolute or relative file path on the local computer or network. The file must contain data in an XML format, a sample of which is shown below.

Defaults to (Output from previous task)

Success File

Required
The XML file to output any records that the task successfully processes to. This can be an absolute or relative file path on the local computer or network.

Defaults to connectwise_import_activities_success.xml

Prevent Reprocessing

Required
Set this option to True to prevent the same record being processed more than once by Zynk. An <externalId> must be provided in the input file for this to work.

Timeout

Optional
The maximum length of time to wait (in seconds) for API requests to be processed. Specifying this value will override the timeout set at the connection level. Leave blank to use the value specified in the connection.

Zynk Settings

See Common Task Settings

Examples

A sample input file is shown below.

<?xml version="1.0" encoding="utf-8"?>
<Activities xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Activity>
    <id>79</id>
    <externalId>124314</externalId>
    <name>Test Activity</name>
    <company>
      <id>2</id>
      <identifier>YourCompany</identifier>
    </company>
    <contact>
      <id>84</id>
      <name>Marc Mosiman</name>
    </contact>
    <phoneNumber>76342155</phoneNumber>
    <email>[email protected]</email>
    <status>
      <id>1</id>
      <name>Open</name>
    </status>
    <dateStart>2018-08-15T00:00:00</dateStart>
    <dateEnd xsi:nil="true" />
    <assignTo>
      <id>176</id>
      <identifier>Admin2</identifier>
    </assignTo>
    <scheduleStatus>
      <id>2</id>
      <name>Firm</name>
    </scheduleStatus>
    <where>
      <id>1</id>
      <name>On-Site</name>
    </where>
    <notifyFlag>false</notifyFlag>
    <currency>
      <id>3</id>
      <name>Euro</name>
      <symbol>€</symbol>
      <isoCode>EUR</isoCode>
    </currency>
  </Activity>
</Activities>