Excel Validation Results

After validation or import of an Excel file to Flex, the results will contain a node named content. It lists statistics and any errors:

rows	Total rows found, excluding header.	integer
valid	Total rows that have valid content, ready for import.	integer
invalid	Total rows that contain errors and will not be imported. See the `errors` array for the details.	integer
skipped	Total rows that lack a string ID or are empty and will not be imported. We do not count those as invalid.	integer
errors	An array of any errors in the data. Each element is an object with: r: The row in the Excel file starting at 1. c: The column in the Excel starting at 1. a value is 0 means that the issue relates to the entire row. f: The data field, which is the column title. e: The error message	object[]

Examples

An Excel with 4 data rows and no errors to report. Ready for import.

"content": {
    "rows": 4,
    "valid": 4,
    "invalid": 0,
    "skipped": 0,
    "errors": []
}

Here we import an Excel with an invalid value for the status:

"content": {
    "rows": 4,
    "valid": 4,
    "invalid": 1,
    "skipped": 0,
    "errors": [
        {
            "r": 3,
            "c": 5,
            "f": "Status - German",
            "e": "Allowed values are NONE, GREEN, RED or blank"
        }
    ]
}

The corresponding Excel is:

API v2

Excel Validation Results

Analytics

Examples