Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
You can use this function The External Mapping Validation provides a way to validate the REST API. Therefore, this feature provides a framework to call the validation rules of the destination elements using REST API that was defined in the REST account during the Template/Transaction creation.
This feature is only visible when:
- You have selected the Enable External Mapping Validation checkbox and REST account from Template/Transaction settings Settings page.
- You open the mapper from the Define Mapping page of Template/Transaction.
This feature is not supported if you open mapping from Manage Objects Mappings page.
Steps to validate REST API
Open the mapping from Define Mapping from Define Mapping page of Template/Transaction.
Click Validate icon from on the toolbar of mapperthe Mapper.
This will call the validation REST API that was defined in the REST account during the Template/Transaction creationThis will validate the REST API.
After validationOnce the validation completes:
- A message is displayed to confirm that the validation is completed without any error.
- The validate icon will change into Validated.
- In case of any validation error, the errors will be displayed.
Request/Response for the External Mapping Validation
The External Mapping Validation provides the way to validate the rules of the destination elements using REST API that was defined in the REST account during the Template/Transaction creation. Following are the Request and Response JSON format for Request and Response are generated in JSON format when you perform an External Mapping Validation in Web Mapper.
Request Format for the External Mapping Validation
Following example presents the request format of API for the layout shown in the below image:Image Removed
The following example represents a Request payload in JSON format.
Code Block | ||||
---|---|---|---|---|
| ||||
{ "destinationDetails": [ { "fieldName": "Root", "MinOccursXSDVersion": "1", "MaxOccursfieldSeparator": "1\\t", "leafrecordSeparator": false"\\n", "schemaNameallowLessFields": "AC_TextSchema_Tragetfalse", "fieldPathremoveInvalidChar": "/Root" }false", { "fieldName"enclosedChar": "Record", "MinOccurs": "1", "MaxOccurs": "unbounded1", "leaf": false, "schemaName": "AC_TextSchema_Traget", "fieldPathschemaId": "/Root/Record" }, { "fieldName192168001145138613618814700005", "entityTypedId": "Field1TextSchema:192168001145138613618814700005", "parentindex": 0, "depth": "1, "Documentationexpanded": ""true, "BaseTypeexpandable": "string"true, "MinOccurschecked": "0null, "cls": "", "MaxOccursiconCls": "1", "leaficon": true"", "schemaNameglyph": "AC_TextSchema_Traget", "isMappedroot": truefalse, "fieldPathisLast": true, "/Root/Record/Field1" }, { "fieldName": "@recordNumber", "Documentation": "", "isAttribute": "true", "leaf": true, "BaseType": "string", "schemaName": "AC_TextSchema_Traget", "fieldPath": "/Root/Record/@recordNumber" } ], "sourceDetails": [{ "fieldName": "Root", "MinOccurs": "1", "MaxOccurs": "1", "leaf": false, "schemaNameisFirst": true, "allowDrop": true, "allowDrag": true, "loaded": true, "loading": false, "href": "", "hrefTarget": "", "qtip": "", "qtitle": "", "qshowDelay": 0, "visible": true, "text": "", "isAttributeAndNamespaceProcessed": true, "targetName": "AC_TextSchema_SourceTraget", "fieldPath": "/Root" }, { "fieldName": "Record", "MinOccurs": "1", "MaxOccurs": "unbounded", "leaf": false, "schemaNameindex": "AC_TextSchema_Source"0, "fieldPathdepth": "/Root/Record" }, { "fieldName": "Field1", "parent2, "expanded": true, "expandable": true, "checked": null, "cls": " ", "DocumentationiconCls": "", "BaseTypeicon": "string", "MinOccursglyph": "0", "MaxOccursroot": false, "1isLast": true, "leafisFirst": true, "schemaNameallowDrop": "AC_TextSchema_Source"true, "isMappedallowDrag": true, "fieldPathloaded": "/Root/Record/Field1" }, { "fieldNametrue, "loading": false, "href": "@recordNumber", "DocumentationhrefTarget": "", "isAttribute"qtip": "", "qtitle": "", "qshowDelay": 0, "visible": true, "text": "", "leafisAttributeAndNamespaceProcessed": true, "BaseTypeschemaName": "stringAC_TextSchema_Traget", "schemaNametargetName": "AC_TextSchema_SourceTraget", "fieldPath": "/Root/Record/@recordNumber" } ], { "mappingDetailsfieldName": { "cloneElements"Field1", "format": "AAAAAAA", "filtersparent": " ", "variablesDocumentation": { "variable"", "BaseType": [ ] }, "globalParameters": { "keys": { "key": [ ] }, "contextVariables": { "contextVariable": [ ] } }, "connections": { "connectionVariable": [ ] }, "functions": { "externalFunction": [ ] }, "filterUnmappedElements": false, "indentOutputXML": true, "xslVersion": "1.1", "enableStreaming"string", "MinOccurs": "0", "MaxOccurs": "1", "leaf": true, "index": 0, "depth": 3, "expanded": false, "expandable": true, "checked": null, "cls": "", "iconCls": "", "icon": "", "glyph": "", "root": false, "filterEmptyElementsisLast": false, "xslTransformerisFirst": "Saxon"true, "characterSetEncodingallowDrop": true, "ISO-8859-1"allowDrag": true, "disableOuputNodesloaded": {false, "disableOutputNodePropertyloading": [ ] }, "GlobalPreCustomXSLfalse, "href": "", "hrefTarget": "", "GlobalPostCustomXSLqtip": "", "xslTemplatesqtitle": { "xslTemplateData"", "qshowDelay": [ ] }, "namespace": "", "namespaceList": [ ], "contextSchemaDefinition": "", "maps": [{ "order": 1, "targetName": "AC_TextSchema_Traget", "targetfield": "Field1", "targetfieldpath": "/Root/Record/Field1", "targetrecord": "Record", "mapping": [{ "sourceName": "AC_TextSchema_Source", "operatortype": "field", "sourcefield": "Field1", "sourcefielddisplayname": "Field1", "sourcefieldpath": "/Root/Record/Field1", "sourcerecord": "Record" }] }] } } |
0,
"visible": true,
"text": "",
"isAttributeAndNamespaceProcessed": true,
"schemaName": "AC_TextSchema_Traget",
"targetName": "AC_TextSchema_Traget",
"fieldPath": "/Root/Record/Field1"
},
{
"fieldName": "@recordNumber",
"Documentation": "",
"isAttribute": "true",
"leaf": true,
"BaseType": "string",
"index": 1,
"depth": 3,
"expanded": false,
"expandable": true,
"checked": null,
"cls": "",
"iconCls": "",
"icon": "",
"glyph": "",
"root": false,
"isLast": true,
"isFirst": false,
"allowDrop": true,
"allowDrag": true,
"loaded": false,
"loading": false,
"href": "",
"hrefTarget": "",
"qtip": "",
"qtitle": "",
"qshowDelay": 0,
"visible": true,
"text": "",
"isAttributeAndNamespaceProcessed": true,
"schemaName": "AC_TextSchema_Traget",
"targetName": "AC_TextSchema_Traget",
"fieldPath": "/Root/Record/@recordNumber"
}
],
"sourceDetails": [
{
"fieldName": "Root",
"XSDVersion": "1",
"fieldSeparator": "\\t",
"recordSeparator": "\\n",
"allowDiscontinousOrder": "false",
"allowIgnoreCase": "false",
"allowLessFields": "false",
"removeLastNewLineSeperator": "false",
"removeInvalidChar": "false",
"enclosedChar": "",
"startRowNumber": "",
"skippedBottomRows": "",
"allowMoreFields": "false",
"MinOccurs": "1",
"MaxOccurs": "1",
"leaf": false,
"schemaName": "AC_TextSchema_Source",
"schemaId": "192168001145138613617495100003",
"entityTypedId": "TextSchema:192168001145138613617495100003",
"index": 0,
"depth": 1,
"expanded": true,
"expandable": true,
"checked": null,
"cls": "",
"iconCls": "",
"icon": "",
"glyph": "",
"root": false,
"isLast": true,
"isFirst": true,
"allowDrop": true,
"allowDrag": true,
"loaded": true,
"loading": false,
"href": "",
"hrefTarget": "",
"qtip": "",
"qtitle": "",
"qshowDelay": 0,
"visible": true,
"text": "",
"isAttributeAndNamespaceProcessed": true,
"sourceName": "AC_TextSchema_Source",
"fieldPath": "/Root"
},
{
"fieldName": "Record",
"MinOccurs": "1",
"MaxOccurs": "unbounded",
"leaf": false,
"index": 0,
"depth": 2,
"expanded": true,
"expandable": true,
"checked": null,
"cls": "",
"iconCls": "",
"icon": "",
"glyph": "",
"root": false,
"isLast": true,
"isFirst": true,
"allowDrop": true,
"allowDrag": true,
"loaded": true,
"loading": false,
"href": "",
"hrefTarget": "",
"qtip": "",
"qtitle": "",
"qshowDelay": 0,
"visible": true,
"text": "",
"isAttributeAndNamespaceProcessed": true,
"schemaName": "AC_TextSchema_Source",
"sourceName": "AC_TextSchema_Source",
"fieldPath": "/Root/Record"
},
{
"fieldName": "Field1",
"format": "AAAAAAA",
"originalName": "Field",
"parent": " ",
"Documentation": "",
"BaseType": "string",
"MinOccurs": "0",
"MaxOccurs": "1",
"leaf": true,
"index": 0,
"depth": 3,
"expanded": false,
"expandable": true,
"checked": null,
"cls": "",
"iconCls": "",
"icon": "",
"glyph": "",
"root": false,
"isLast": false,
"isFirst": true,
"allowDrop": true,
"allowDrag": true,
"loaded": false,
"loading": false,
"href": "",
"hrefTarget": "",
"qtip": "",
"qtitle": "",
"qshowDelay": 0,
"visible": true,
"text": "",
"isAttributeAndNamespaceProcessed": true,
"schemaName": "AC_TextSchema_Source",
"sourceName": "AC_TextSchema_Source",
"fieldPath": "/Root/Record/Field1"
},
{
"fieldName": "@recordNumber",
"Documentation": "",
"isAttribute": "true",
"leaf": true,
"BaseType": "string",
"index": 1,
"depth": 3,
"expanded": false,
"expandable": true,
"checked": null,
"cls": "",
"iconCls": "",
"icon": "",
"glyph": "",
"root": false,
"isLast": true,
"isFirst": false,
"allowDrop": true,
"allowDrag": true,
"loaded": false,
"loading": false,
"href": "",
"hrefTarget": "",
"qtip": "",
"qtitle": "",
"qshowDelay": 0,
"visible": true,
"text": "",
"isAttributeAndNamespaceProcessed": true,
"schemaName": "AC_TextSchema_Source",
"sourceName": "AC_TextSchema_Source",
"fieldPath": "/Root/Record/@recordNumber"
}
],
"mappingDetails": {
"json": {
"category": "mapping",
"type": "mapping",
"encoding": "UTF-8",
"version": "1.0"
},
"cloneElements": "",
"filters": "",
"variables": {
"variable": []
},
"globalParameters": {
"keys": {
"key": []
},
"contextVariables": {
"contextVariable": []
}
},
"connections": {
"connectionVariable": []
},
"functions": {
"externalFunction": []
},
"filterUnmappedElements": false,
"indentOutputXML": true,
"xslVersion": "1.1",
"enableStreaming": false,
"filterEmptyElements": false,
"xslTransformer": "Saxon",
"characterSetEncoding": "UTF-8",
"DataViewerRecordCount": 50,
"dbQueryCaching": false,
"isQuickSplittingEnabled": false,
"TreeExpandLevelCountForWebService": 5,
"TreeExpandLevelForEasySchemaExtensions": 10,
"SelfRecursionLevel": 0,
"EnableTypesBuffering": true,
"TreeExpandLevelCount": 3,
"onDemandLoadingOfXMLSchemaTree": true,
"settingConfigs": {
"xslVersion": "1.1",
"xslTransformer": "Saxon",
"filterUnmappedElements": false,
"indentOutputXML": true,
"filterEmptyElements": false,
"enableStreaming": false,
"characterSetEncoding": "UTF-8",
"DataViewerRecordCount": 50,
"dbQueryCaching": false,
"isQuickSplittingEnabled": false,
"TreeExpandLevelCountForWebService": 5,
"TreeExpandLevelForEasySchemaExtensions": 10,
"SelfRecursionLevel": 0,
"EnableTypesBuffering": true,
"TreeExpandLevelCount": 3,
"onDemandLoadingOfXMLSchemaTree": true,
"cDataSectionElements": "",
"excludeResultPrefixes": "saxonJavaMappingTransformation saxonJavaMapperQueryExecutor saxonJavaAggregateFunctionHandler str",
"cacheIncludedSchemas": false,
"processElementFormDefault": true,
"isAutoSaveEnable": true
},
"disableOuputNodes": {
"disableOutputNodeProperty": []
},
"isCustomXSLT": false,
"contextSchemaLoadedAtSource": false,
"contextSchemaLoadedAtTarget": false,
"webservice": {
"consumers": {
"consumer": []
}
},
"GlobalPreCustomXSL": "",
"GlobalPostCustomXSL": "",
"xslTemplates": {
"xslTemplateData": []
},
"mappingTempId": null,
"sourceXpath": "",
"targetXpath": "",
"cDataSectionElements": "",
"splittingData": false,
"splitNumberOfRecords": "500",
"parallelProcessing": false,
"maximumConcurrentProcessor": "1",
"CustomAutoMapInUse": "",
"excludeResultPrefixes": "saxonJavaMappingTransformation saxonJavaMapperQueryExecutor saxonJavaAggregateFunctionHandler str",
"cacheIncludedSchemas": false,
"metaData": "",
"processElementFormDefault": true,
"mappingInformation": {
"mappingVersion": "6.1",
"mappingName": "dgdiuw",
"mappingProject": "Default",
"mappingDescription": "ye",
"sourceSchemaID": "TextSchema:192168001145138613617495100003",
"targetSchemaID": "TextSchema:192168001145138613618814700005",
"mappingOwnerGroup": "",
"mappingOwner": "",
"mappingLastModifiedBy": "",
"mappingCreationDate": "",
"mappingModifiedDate": "",
"reusable": null
},
"namespace": "",
"namespaceList": [],
"foreach": "",
"targetRoots": {
"targetRoot": [
{
"name": "Root",
"schemaName": "AC_TextSchema_Traget",
"schemaID": "TextSchema:192168001145138613618814700005",
"stream": "output_1"
}
]
},
"sourceRoots": {
"sourceRoot": [
{
"name": "Root",
"schemaName": "AC_TextSchema_Source",
"schemaID": "TextSchema:192168001145138613617495100003"
}
]
},
"contextSchemaDefinition": "",
"maps": [],
"sourceExpandLevel": 3,
"targetExpandLevel": 3,
"sourceTargetSchemaDetails": {
"sourceSchema": {
"name": "",
"root": false,
"leaf": false,
"schemaName": "Input_undefined",
"schemaType": "",
"xpath": "/",
"namespacePrefix": "",
"currentForEach": "",
"currentMapping": "",
"currentComment": "",
"preCustomXSL": "",
"postCustomXSL": "",
"disableOutputEscaping": false,
"order": 1,
"filter": false,
"loadedOptimized": false,
"namespaceRemoved": "",
"attribute": false,
"localVariableList": [],
"sortList": [],
"children": [
{
"name": "Root",
"root": true,
"leaf": false,
"schemaName": "Input_AC_TextSchema_Source",
"schemaNameWithoutInput": "AC_TextSchema_Source",
"schemaType": "TextSchema",
"xpath": "/Root",
"namespacePrefix": "",
"currentForEach": "",
"currentMapping": "",
"currentComment": "",
"preCustomXSL": "",
"postCustomXSL": "",
"disableOutputEscaping": false,
"order": 1,
"filter": false,
"loadedOptimized": false,
"namespaceRemoved": "",
"attribute": false,
"localVariableList": [],
"sortList": [],
"children": [
{
"name": "Record",
"root": false,
"leaf": false,
"schemaName": "Input_AC_TextSchema_Source",
"schemaNameWithoutInput": "AC_TextSchema_Source",
"schemaType": "",
"xpath": "/Root/Record",
"namespacePrefix": "",
"currentForEach": "",
"currentMapping": "",
"currentComment": "",
"preCustomXSL": "",
"postCustomXSL": "",
"disableOutputEscaping": false,
"order": 1,
"filter": false,
"loadedOptimized": false,
"namespaceRemoved": "",
"attribute": false,
"localVariableList": [],
"sortList": [],
"children": [
{
"name": "Field1",
"root": false,
"leaf": true,
"schemaName": "Input_AC_TextSchema_Source",
"schemaNameWithoutInput": "AC_TextSchema_Source",
"schemaType": "",
"xpath": "/Root/Record/Field1",
"namespacePrefix": "",
"currentForEach": "",
"currentMapping": "",
"currentComment": "",
"preCustomXSL": "",
"postCustomXSL": "",
"disableOutputEscaping": false,
"order": 1,
"filter": false,
"loadedOptimized": false,
"namespaceRemoved": "",
"attribute": false,
"localVariableList": [],
"sortList": [],
"children": [],
"totalChildMappings": 0
},
{
"name": "@recordNumber",
"root": false,
"leaf": true,
"schemaName": "Input_AC_TextSchema_Source",
"schemaNameWithoutInput": "AC_TextSchema_Source",
"schemaType": "",
"xpath": "/Root/Record/@recordNumber",
"namespacePrefix": "",
"currentForEach": "",
"currentMapping": "",
"currentComment": "",
"preCustomXSL": "",
"postCustomXSL": "",
"disableOutputEscaping": false,
"order": 1,
"filter": false,
"loadedOptimized": false,
"namespaceRemoved": "",
"attribute": "true",
"localVariableList": [],
"sortList": [],
"children": [],
"totalChildMappings": 0
}
],
"totalChildMappings": 0
}
],
"totalChildMappings": 0
}
],
"totalChildMappings": 0
},
"destinationSchema": {
"name": "",
"root": false,
"leaf": false,
"schemaName": "Input_undefined",
"schemaType": "",
"xpath": "/",
"namespacePrefix": "",
"currentForEach": "",
"currentMapping": "",
"currentComment": "",
"preCustomXSL": "",
"postCustomXSL": "",
"disableOutputEscaping": false,
"order": 1,
"filter": false,
"loadedOptimized": false,
"namespaceRemoved": "",
"attribute": false,
"localVariableList": [],
"sortList": [],
"children": [
{
"name": "Root",
"root": true,
"leaf": false,
"schemaName": "Input_AC_TextSchema_Traget",
"schemaNameWithoutInput": "AC_TextSchema_Traget",
"schemaType": "TextSchema",
"xpath": "/Root",
"streamName": "output_1",
"namespacePrefix": "",
"currentForEach": "",
"currentMapping": "",
"currentComment": "",
"preCustomXSL": "",
"postCustomXSL": "",
"disableOutputEscaping": false,
"order": 1,
"filter": false,
"loadedOptimized": false,
"namespaceRemoved": "",
"attribute": false,
"localVariableList": [],
"sortList": [],
"children": [
{
"name": "Record",
"root": false,
"leaf": false,
"schemaName": "Input_AC_TextSchema_Traget",
"schemaNameWithoutInput": "AC_TextSchema_Traget",
"schemaType": "",
"xpath": "/Root/Record",
"streamName": "output_1",
"namespacePrefix": "",
"currentForEach": "",
"currentMapping": "",
"currentComment": "",
"preCustomXSL": "",
"postCustomXSL": "",
"disableOutputEscaping": false,
"order": 1,
"filter": false,
"loadedOptimized": false,
"namespaceRemoved": "",
"attribute": false,
"localVariableList": [],
"sortList": [],
"children": [
{
"name": "Field1",
"root": false,
"leaf": true,
"schemaName": "Input_AC_TextSchema_Traget",
"schemaNameWithoutInput": "AC_TextSchema_Traget",
"schemaType": "",
"xpath": "/Root/Record/Field1",
"streamName": "output_1",
"namespacePrefix": "",
"currentForEach": "",
"currentMapping": "",
"currentComment": "",
"preCustomXSL": "",
"postCustomXSL": "",
"disableOutputEscaping": false,
"order": 1,
"filter": false,
"loadedOptimized": false,
"namespaceRemoved": "",
"attribute": false,
"localVariableList": [],
"sortList": [],
"children": [],
"totalChildMappings": 0
},
{
"name": "@recordNumber",
"root": false,
"leaf": true,
"schemaName": "Input_AC_TextSchema_Traget",
"schemaNameWithoutInput": "AC_TextSchema_Traget",
"schemaType": "",
"xpath": "/Root/Record/@recordNumber",
"streamName": "output_1",
"namespacePrefix": "",
"currentForEach": "",
"currentMapping": "",
"currentComment": "",
"preCustomXSL": "",
"postCustomXSL": "",
"disableOutputEscaping": false,
"order": 1,
"filter": false,
"loadedOptimized": false,
"namespaceRemoved": "",
"attribute": "true",
"localVariableList": [],
"sortList": [],
"children": [],
"totalChildMappings": 0
}
],
"totalChildMappings": 0
}
],
"totalChildMappings": 0
}
],
"totalChildMappings": 0
}
}
},
"UserDetails": {
"UserId": "127000000001107055536473900001",
"UserName": "admin",
"FirstName": "Admin",
"LastName": "User",
"Role": {
"id": "1",
"description": "Sys Admin",
"entityName": "Sys Admin",
"aisUserType": "sysadmin",
"baseRole": null,
"policy": "{\"role\":{\"networkAccess\":{\"category\":\"all\"},\"networkListAccess\":{\"category\":\"all\"},\"projectAccess\":{\"category\":\"all\"},\"permissions\":[{\"name\":\"template\",\"permission\":\"LRCEX\"},{\"name\":\"transaction\",\"permission\":\"LRCEX\"},{\"name\":\"network\",\"permission\":\"LRCEX\"},{\"name\":\"partner\",\"permission\":\"LRCEX\"},{\"name\":\"usermanagement\",\"permission\":\"LRCEX\"},{\"name\":\"project\",\"permission\":\"LRCEX\"},{\"name\":\"webform\",\"permission\":\"LRCEX\"},{\"name\":\"aisentities\",\"permission\":\"LRCEX\"},{\"name\":\"secureentities\",\"permission\":\"LRCEX\"},{\"name\":\"dashboardmonitor\",\"permission\":\"LRX\"},{\"name\":\"themesettings\",\"permission\":\"LRCEX\"},{\"name\":\"processflow\",\"permission\":\"LRCEX\"},{\"name\":\"administer\",\"permission\":\"LRCEX\"},{\"name\":\"audittrail\",\"displayName\":\"AuditTrail\",\"permission\":\"LRE\"}],\"aisAccess\":true,\"viewUserData\":true}}",
"customPolicy": null,
"otherPolicies": null,
"modifiedDate": 1657264312377,
"createdUser": null,
"modifiedUser": null,
"type": 3800,
"isUsed": null,
"firstActivityNumber": null,
"firstActivityText": null,
"recentActivityNumber": null,
"recentActivityText": null
}
},
"Authorization": "",
"externalRequestUrl": "https://qamonitorapi.adeptia.com:443/wsapi/success",
"methodName": "POST"
}
|
Request JSON has these details:
User Details: This show the details of the user who is performing the validation.
Destination Details: This shows the details of each element of destination layout.
Source Details: This shows the details of each element of source layout.
Mapping Details: This shows the mapping details applied on destination layout.
Response Format for the External Mapping Validation
These information must available in Response JSON:
In case the Validation is successful
{"status":"success","errorDetails":{}}
In case the validation is not successful
{ "status":"error",
"errorDetails":{
"/Root/Record/Field1" :{
"message": "Field1 is mandatory.",
"schemaName" : "AC_TextSchema_Target"
},
"/Root/Record/@recordNumber" :{
"message": "@recordNumber is mandatory.",
"schemaName" : "AC_TextSchema_Target"
}
}
}
Where,
Status: This shows the validation status 'error' or 'success'. If
successsuccessful, the error details will be blank
otherwise error detailselse it contains the list of field path which are having errors.
Error Details: This contains the field path.
Field Path: This contains message and schema name.
Panel | ||||
---|---|---|---|---|
| ||||
What's newBest practicesTraining guidesFrequently asked questionsAdeptia Connect APIsAdeptia security report |