Hi,
I created a custom connector to call a BigQuery API to insert data to BQ. I am able to test it successfully from the custom connector. But I get the following error when I try calling it from powerapps. Below is a valid json tested and successfully working from the custom connector test . I don't get any syntax errors on the json from powerapp, but get the following run time error. I am desperate for help with all the issues with custom connectors. Any help would be greatly appreciated.
Request Json
{
"ignoreUnknownValues": false,
"kind": "bigquery#tableDataInsertAllRequest",
"skipInvalidRows": false,
"templateSuffix": "",
"rows": [
{
"insertId": "TEST",
"json": {
"Id": "2",
"name": "werewrewren",
"city": "Hwerwerd"
}
}
]
}
Thanks,
Haripriya