I am getting data using Execute stored procedure (V2) from an Onprem SQL server using a Gateway an adding to a share point list. I ran it and grabbed the output for ResultSets and Generated from sample for Parse JSON. But It keep failing Validation. Will pass for one record and work but not for more then 1. Any thoughts?
Here is the schema:
{
"type": "object",
"properties": {
"Table1": {
"type": "array",
"items": {
"type": "object",
"properties": {
"CpnyId": {
"type": "string"
},
"Division": {
"type": "string"
},
"Project_Desc": {
"type": "string"
},
"Project": {
"type": "string"
},
"Office": {
"type": "string"
},
"Salesperson": {
"type": "string"
},
"Contract_Dt": {
"type": "string"
},
"Discount": {
"type": "integer"
},
"Good_Bad_Amt": {
"type": "integer"
},
"Sign_Contract_Price": {
"type": "number"
},
"Sign_TotalCost": {
"type": "number"
},
"Sign_MI": {
"type": "number"
},
"Sign_MI_Percent": {
"type": "number"
},
"Sign_Comm": {
"type": "number"
},
"Sign_Comm_Percent": {
"type": "number"
},
"Clear_Contract_Price": {
"type": "integer"
},
"Clear_TotalCost": {
"type": "number"
},
"Clear_MI": {
"type": "number"
},
"Clear_MI_Percent": {
"type": "number"
},
"Clear_Comm": {
"type": "integer"
},
"Clear_Comm_Percent": {
"type": "number"
},
"Cur_Contract_Price": {
"type": "number"
},
"Cur_TotalCost": {
"type": "number"
},
"Cur_MI": {
"type": "number"
},
"Cur_MI_Percent": {
"type": "number"
},
"Cur_Comm": {
"type": "integer"
},
"Cur_Comm_Percent": {
"type": "number"
},
"Dig_Date": {
"type": "string"
},
"Stage": {
"type": "string"
},
"Project_Status": {
"type": "string"
},
"NonWIPAmt": {
"type": "integer"
},
"SLX_Office": {
"type": "string"
}
},
"required": [
"CpnyId",
"Division",
"Project_Desc",
"Project",
"Office",
"Salesperson",
"Contract_Dt",
"Discount",
"Good_Bad_Amt",
"Sign_Contract_Price",
"Sign_TotalCost",
"Sign_MI",
"Sign_MI_Percent",
"Sign_Comm",
"Sign_Comm_Percent",
"Clear_Contract_Price",
"Clear_TotalCost",
"Clear_MI",
"Clear_MI_Percent",
"Clear_Comm",
"Clear_Comm_Percent",
"Cur_Contract_Price",
"Cur_TotalCost",
"Cur_MI",
"Cur_MI_Percent",
"Cur_Comm",
"Cur_Comm_Percent",
"Dig_Date",
"Stage",
"Project_Status",
"NonWIPAmt",
"SLX_Office"
]
}
}
}
}
