Click or drag to resize
Templates
Print this page

Data Exchange by Verizon Connect (TDE) lets you use data transfer templates to import data from a variety of file types and export data from Verizon Connect products to a variety of file types (see the [Template] section for the supported file types).

Each template, when executed, accomplishes a single data operation, which is called the intent of the template. These intents include:

  • Create - Create data in a TDE table.
  • Retrieve - Retrieve data from a TDE table into a file.
  • Update - Update data in a TDE table.
  • CreateOrUpdate - Update data in a TDE table for each row that exists, otherwise create a new row for each row that does not exist.
  • Delete - Delete data from a TDE table.

Importing and exporting is accomplished using a Web Service that transfers data based on the contents of a template file. Each template file contains mappings between published TDE tables and external fields.

Using Data Transfer Templates

The following topics describe how to use Templates in detail:

  • Data Types - describes the data types used in all TDE tables.
  • Functions in templates - describes the built-in and native .NET functions that you can use inside templates.
  • Tables - describes the each of the tables that you can access with templates, the requirements for each table, and the table columns that are available to you.
  • Template Files - describes the structure and syntax of template files. Each template file contains mappings between published Verizon Connect tables and external fields.
  • Template syntax - describes the syntax of template files, including how to use external keys and convert date/time values.
  • Using the Web Service - describes how to invoke the Verizon Connect Web Service to create, update, locate, and execute your templates.