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.
Solved! Go to Solution.
Hi @stinsora :
The key is that there may be records in your content where the value of the "average_cost" field is empty.
Please try this 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": {},
"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"
]
}
}
}
}
I think this link will help you a lot:
Best Regards,
Bof
Hi @stinsora :
The key is that there may be records in your content where the value of the "average_cost" field is empty.
Please try this 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": {},
"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"
]
}
}
}
}
I think this link will help you a lot:
Best Regards,
Bof
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
70 | |
24 | |
18 | |
16 | |
13 |
User | Count |
---|---|
133 | |
43 | |
32 | |
32 | |
28 |