I am experiencing a validation error on my JSON Parse step and I'm not sure where my error exists.
ValidationFailed. The schema validation failed.
Schema:
{
"type": "object",
"properties": {
"data": {
"type": "array",
"items": {
"type": "object",
"properties": {
"variant_id": {
"type": "integer"
},
"location_id": {
"type": "integer"
},
"reorder_point": {
"type": "string"
},
"average_cost": {
"type": "string"
},
"value_in_stock": {
"type": "string"
},
"quantity_in_stock": {
"type": "string"
},
"quantity_committed": {
"type": "string"
},
"quantity_expected": {
"type": "string"
},
"quantity_missing_or_excess": {
"type": "string"
}
},
"required": [
"variant_id",
"location_id",
"reorder_point",
"average_cost",
"value_in_stock",
"quantity_in_stock",
"quantity_committed",
"quantity_expected",
"quantity_missing_or_excess"
]
}
}
}
}
Content:
{
"data": [
{
"variant_id": 6861410,
"location_id": 28299,
"reorder_point": "0.00000",
"average_cost": "0.0721608936",
"value_in_stock": "3391.5620000000",
"quantity_in_stock": "47000.00000",
"quantity_committed": "0.00000",
"quantity_expected": "180000.00000",
"quantity_missing_or_excess": "227000.00000"
},
{
"variant_id": 6861411,
"location_id": 28299,
"reorder_point": "0.00000",
"average_cost": "0.0326992683",
"value_in_stock": "2681.3400000000",
"quantity_in_stock": "82000.00000",
"quantity_committed": "0.00000",
"quantity_expected": "180000.00000",
"quantity_missing_or_excess": "262000.00000"
}
]
}
Error Output:
[
{
"message": "Invalid type. Expected String but got Null.",
"lineNumber": 0,
"linePosition": 0,
"path": "data[21].average_cost",
"schemaId": "#/properties/data/items/properties/average_cost",
"errorType": "type",
"childErrors": []
},
{
"message": "Invalid type. Expected String but got Null.",
"lineNumber": 0,
"linePosition": 0,
"path": "data[22].average_cost",
"schemaId": "#/properties/data/items/properties/average_cost",
"errorType": "type",
"childErrors": []
},
{
"message": "Invalid type. Expected String but got Null.",
"lineNumber": 0,
"linePosition": 0,
"path": "data[24].average_cost",
"schemaId": "#/properties/data/items/properties/average_cost",
"errorType": "type",
"childErrors": []
},
{
"message": "Invalid type. Expected String but got Null.",
"lineNumber": 0,
"linePosition": 0,
"path": "data[26].average_cost",
"schemaId": "#/properties/data/items/properties/average_cost",
"errorType": "type",
"childErrors": []
}
]
Thank you for your help.
