| Templates |
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.
NoteTable retrieves are limited to 8 million operations per hour per customer account. Non-retrieves are limited to 1 million operations per hour per user.
- 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 TemplatesThe 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.