EORI Validation: JSON import interface

With the import interface for JSON files, the module “EORI Validation” provides you with a way to Check your entire database from your master data.

We ensure that compatibility is maintained when extending the JSON EORI interface. This allows you to use the latest version without additional effort when integrating into your ERP system.

In order to be able to uniquely assign a JSON record from your ERP system in the EORI Validation, you have the option to up to two unique keys in the import file. These are returned in the export file and can be used for reimport into your ERP system. However, you can leave these two fields (key1 and key2) blank.

The EORI interface responses the complete data like company name, street, etc. We work on the functionality for a future release of our EORI Validation to extend the JSON import format to be able to compare your stored datasets with the response to find differences on your site.

Please note that all bold fields must be specified in the import file.

Structure — EORI JSON Import File

KeyFormatExample
key1String4711
key2String2
eoriStringEN123456

Example in the form of a JSON file with two entries:

[
{
"key1": "a",
"key2": "b",
"eori": "EN123456"
},
{
"key1": "a",
"key2": "b",
"eori": "EN789012"
}
]

Structure — EORI JSON Export File

The JSON export file of the EORI Validation contains the returned values of each validation, also, unless otherwise specified, in the same Data format. Please note that the JSON interface outputs all available fields and thus represents the most complete format.

KeyFormatExample
key1String4711
key2String2
eoriStringDE123456
nameStringSample Company
addressString
streetStringSamplestreet 1
postalCodeString12345
cityStringVillage of Samples
countryStringGermany
statusString0
statusDescrStringValid
errorReasonString
requestdateString

Example in the form of a JSON file (with standard delimiter):

[
{
"eori": "EN123456";
"status": "0",
"StatusDescr": "Valid",
'name' means 'sample company';
"street": "Sample Street 1",
"PostalCode": "12345",
"city": "Musterdorf",
"country": "Germany",
"requestdate": "30/01/2021",
"key1": "4711",
"key2": "2"
}
]

Unlike XLSX or CSV, we agreed on the purely English notation of the keys of the EORI Validation within JSON. This allows us to avoid run-time errors in case of incorrect conversion.

Please note that the fields in the export file of the EORI Validation are not always output in the same order as shown in the table above.