Hi @zdames,
Which Response type do you specify within your Open API definition file?
Could you please share more details about the Open API definition file of your custom connector?
Based on the error message that you provided, it seems to tell that the property (query parameter) of the control is required to provide a Table value, but your custom connector formula return a Text value.
Based on the Response screenshot that you provided, I think you have defined your Response type as Object within your OpenAPI definition file, is it true?
Please consider take a try to define your Response type as array within your OpenAPI definition file as below:
{
"swagger": "2.0",
"info": {
"version": "1.0.0",
"title": "SentimentDemo",
"description": "Uses the Cognitive Services Text Analytics Sentiment API to determine whether text is positive or negative"
},
"host": "westus.api.cognitive.microsoft.com",
"basePath": "/",
"schemes": [
"https"
],
"consumes": [],
"produces": [
"application/json"
],
"paths": {
"/text/analytics/v2.0/sentiment": {
"post": {
"summary": "Returns a numeric score representing the sentiment detected",
"description": "The API returns a numeric score between 0 and 1. Scores close to 1 indicate positive sentiment, while scores close to 0 indicate negative sentiment.",
"operationId": "DetectSentiment",
"parameters": [
{
...
}
],
"responses": {
"200": {
"description": "200",
"schema": {
"type": "array", /* <-- Modify here. Change the Response type from object into array */
"properties": {
"documents": {
"type": "array",
"items": {
"type": "object",
"properties": {
}
},
"description": "documents",
"x-ms-summary": "documents"
},
...
}
}
}
}
}
}
},
"definitions": {},
"parameters": {},
"responses": {},
"securityDefinitions": {
...
}
},
"security": [],
"tags": []
}
then re-create a new custom connector based on your OpenAPI definition file, check if the issue is solved.
Please also check and see if the following thread would also help in your scenario:
https://powerusers.microsoft.com/t5/General-Discussion/How-do-I-bind-my-custom-API-to-a-dropdown-control/td-p/178455
Best regards,
Kris
