I make a call to our system via HTML and receive the results I expect, But I am struggling to get this data back to a PowerApps collection, Please help 🙂
PowerApps Button =
ClearCollect(colGetCal,GetCalData.Run(Username)
Flow
This is the output from the parsing of the JSON
{
"perform_batch_result": {
"person_cal_except_hierarchy_select_result": {
"@result_name": "",
"person_cal_except": [
{
"metrix_row_num": "1",
"available": "N",
"description": "Core Training",
"end_dttm": "2022-01-01T17:00:00.0000000",
"exception_id": "470638",
"exception_type": "CORE_TRAIN",
"person_id": "TEST01",
"start_dttm": "2022-01-01T08:30:00.0000000"
},
{
"metrix_row_num": "2",
"available": "N",
"description": "Core Training",
"end_dttm": "2022-03-01T17:00:00.0000000",
"exception_id": "470639",
"exception_type": "CORE_TRAIN",
"person_id": "TEST01",
"start_dttm": "2022-03-01T08:30:00.0000000"
},
{
"metrix_row_num": "3",
"available": "N",
"description": "Core Training",
"end_dttm": "2022-04-01T17:00:00.0000000",
"exception_id": "470640",
"exception_type": "CORE_TRAIN",
"person_id": "TEST01",
"start_dttm": "2022-04-01T08:30:00.0000000"
}
]
}
}
}
, The SCHEMA
{
"type": "object",
"properties": {
"perform_batch_result": {
"type": "object",
"properties": {
"person_cal_except_hierarchy_select_result": {
"type": "object",
"properties": {
"@@result_name": {
"type": "string"
},
"person_cal_except": {
"type": "array",
"items": {
"type": "object",
"properties": {
"metrix_row_num": {
"type": "string"
},
"available": {
"type": "string"
},
"description": {
"type": "string"
},
"end_dttm": {
"type": "string"
},
"exception_id": {
"type": "string"
},
"exception_type": {
"type": "string"
},
"person_id": {
"type": "string"
},
"start_dttm": {
"type": "string"
}
},
"required": [
"metrix_row_num",
"available",
"description",
"end_dttm",
"exception_id",
"exception_type",
"person_id",
"start_dttm"
]
}
}
}
}
}
}
}
}
In the response I get the body from the JSON Parse and use the following schema
{
"type": "array",
"items": {
"type": "object",
"properties": {
"metrix_row_num": {
"type": "string"
},
"available": {
"type": "string"
},
"description": {
"type": "string"
},
"end_dttm": {
"type": "string"
},
"exception_id": {
"type": "string"
},
"exception_type": {
"type": "string"
},
"person_id": {
"type": "string"
},
"start_dttm": {
"type": "string"
}
},
"required": [
"metrix_row_num",
"available",
"description",
"end_dttm",
"exception_id",
"exception_type",
"person_id",
"start_dttm"
]
}
}
When i execute this from within PowerApps all i get is the headings, no data. i am obviously missing something
