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"
]
}
}
}
}
Solved! Go to Solution.
I figured it out. It was a data type issue. If I had just looked it told me it was expecting a integer but got number. I changed the data type in the schema and all is working.
Hi @keithschm,
Can you use the outputs of the second record, which is failing and use that to generate a parse json schema and compare it with your current schema? Maybe you are missing a couple of fields which are used in the second record?
Thank you for the reply. I verified it is not the data by altering the SP to select different rows. All columns have data.
I figured it out. It was a data type issue. If I had just looked it told me it was expecting a integer but got number. I changed the data type in the schema and all is working.
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.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
64 | |
27 | |
22 | |
15 | |
15 |
User | Count |
---|---|
123 | |
46 | |
43 | |
35 | |
31 |