Hi I hope some could help me
im getting this error when i try to add a flow to powerapps
I use the http response conector to return a json
this is the schema, cannot find anything wrong,someone knows what may be causing the error?
{
"type": "object",
"properties": {
"Table1": {
"type": "array",
"items": {
"type": "object",
"properties": {
"Contrato": {
"type": "string"
},
"TipoContrato": {
"type": "integer"
},
"TipoProveedor": {
"type": "string"
},
"IdProveedor": {
"type": "integer"
},
"Cliente": {
"type": "integer"
},
"Grupo": {
"type": "string"
},
"FechaInicio": {
"type": "string"
},
"FechaFin": {
"type": "string"
},
"Observacion": {
"type": "string"
},
"NoMeses": {
"type": "integer"
},
"Status": {
"type": "string"
},
"FechaEntrega": {
"type": [
"string",
"null"
]
},
"idAbogado": {
"type": [
"string",
"null"
]
},
"Id": {
"type": [
"string",
"null"
]
},
"Nombre": {
"type": [
"string",
"null"
]
},
"Correo": {
"type": [
"string",
"null"
]
}
},
"required": [
"Contrato",
"TipoContrato",
"TipoProveedor",
"IdProveedor",
"Cliente",
"Grupo",
"FechaInicio",
"FechaFin",
"Observacion",
"NoMeses",
"Status",
"FechaEntrega",
"idAbogado",
"Id",
"Nombre",
"Correo"
]
}
}
}
}
I add the this because some fields can be null
"Id": {
"type": [
"string",
"null"
]
}
Solved! Go to Solution.
also I forgot to mention that I have a "parse json" before the http response , i guess that parse json cannot handle nulls because i deleted and then it works
You need to try to parse out Table1 from the JSON and only send that back, with the appropriate Schema. Assuming this is a SQL result there should be a dynamic content variable called Results Table1. That's what you want to return, not Body. I see you are returning Results set, but you want Results Set Table1.
@Pstork1 The "Resultsets" was right, i have another flows and that works, y receibe a json "Table1" in powerapps.
making test i delete all the
"type": [
"string",
"null"
]
and now i can add to powerapps but i get another error
also I forgot to mention that I have a "parse json" before the http response , i guess that parse json cannot handle nulls because i deleted and then it works
User | Count |
---|---|
89 | |
41 | |
22 | |
20 | |
16 |
User | Count |
---|---|
131 | |
51 | |
48 | |
36 | |
26 |