Data Integration Validation | Vantage CX - 1.4 - Data Integration Validation - Vantage Customer Experience

Vantage Customer Experience User Guide

Product
Vantage Customer Experience
Release Number
1.4
Release Date
June 2021
Content Type
User Guide
Publication ID
B035-3800-099K
Language
English (United States)
The tables that you use when you create an API data integration must be valid. This section includes the schema for each table type. See API Request and Response Tables.

Inbound Response and Outbound Source Table

Each row in the table represents the data sent or received in each individual API call.

CREATE MULTISET TABLE ${databaseName}.${tableName}, FALLBACK,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO,
     MAP = TD_MAP1
     (
      Execution_Id VARCHAR(12) CHARACTER SET LATIN CASESPECIFIC,
      Integration_Id VARCHAR(12) CHARACTER SET LATIN CASESPECIFIC,
      Object_Id VARCHAR(40) CHARACTER SET LATIN NOT CASESPECIFIC,
      Object_Order INTEGER,
      Path VARCHAR(32000) CHARACTER SET LATIN NOT CASESPECIFIC,
      Element_Property VARCHAR(32000) CHARACTER SET LATIN NOT CASESPECIFIC,
      Element_Property_Value VARCHAR(32000) CHARACTER SET LATIN NOT CASESPECIFIC,
      Element_Property_Datatype VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,
      Element_Order INTEGER,
      Request_Object_Order INTEGER,
      Request_Object_Id VARCHAR(40) CHARACTER SET LATIN NOT CASESPECIFIC,
      Response_Status INTEGER NOT NULL,
      Response_Content_Type VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,
      Response_Body VARCHAR(32000) CHARACTER SET LATIN NOT CASESPECIFIC
     )
PRIMARY INDEX ( Object_Id );

Outbound Response

CREATE MULTISET TABLE ${databaseName}.${tableName}, FALLBACK,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO,
     MAP = TD_MAP1
     (
      Execution_Id VARCHAR(12) CHARACTER SET LATIN CASESPECIFIC,
      Integration_Id VARCHAR(12) CHARACTER SET LATIN CASESPECIFIC,
      Object_Id VARCHAR(40) CHARACTER SET LATIN NOT CASESPECIFIC,
      Object_Order INTEGER,
      Path VARCHAR(32000) CHARACTER SET LATIN NOT CASESPECIFIC,
      Element_Property VARCHAR(32000) CHARACTER SET LATIN NOT CASESPECIFIC,
      Element_Property_Value VARCHAR(32000) CHARACTER SET LATIN NOT CASESPECIFIC,
      Element_Property_Datatype VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,
      Element_Order INTEGER,
      Request_Object_Order INTEGER,
      Request_Object_Id VARCHAR(40) CHARACTER SET LATIN NOT CASESPECIFIC,
      Response_Status INTEGER NOT NULL,
      Response_Content_Type VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,
      Response_Body VARCHAR(32000) CHARACTER SET LATIN NOT CASESPECIFIC
     )
PRIMARY INDEX ( Object_Id );