I'm encountering a SystemError while attempting to execute a connector action using a custom connector on Copilot Studio.
The error message I've come across in the developer tools states:
"Expecting a TableType Json Array but got Record."
I have tried the parameters and executed successfully on Power Apps' Custom Connector test screen:
I have also tried checking online, however I haven't been able to find any references to this specific error, as such I am now unsure about how to proceed.
Has anyone else encountered this issue before? If so, could you please share any insights or advice on how to resolve it?
I'd greatly appreciate any guidance or suggestions on how to tackle this problem effectively.
Thank you in advance!
Hi @AD ,
Do let me know if there are anything else needed, thank you!
-
-
-
Hi adilei,
Thank you for your response!
The connector input should all be strings.
The output is as follows:
[
{
"submit_id": 3,
"emp_id": 4,
"emp_no": "12",
"emp_nm": "Jack",
"actor": 0,
"actor_txt": "申請",
"trans_payment": null,
"status_txt": "差戻",
"hd_sdate": null
}
]
The YAML of the topic is as follows (some values redacted):
kind: AdaptiveDialog
beginDialog:
kind: OnRecognizedIntent
id: main
intent:
triggerQueries:
- DGからデータを取得
actions:
- kind: Question
id: question_Z1SWNz
interruptionPolicy:
allowInterruption: true
variable: Topic.ホストURL
prompt: 使用するテナントのDGホストURLは?例:https://tenant-name.com/
entity: URLPrebuiltEntity
- kind: Question
id: question_FSvC0m
interruptionPolicy:
allowInterruption: true
variable: init:Topic.ロールID
prompt: 使用するロールのロールIDは?
entity:
kind: RegexEntityReference
entityId: crcfa_dgTest1.entity.ID
- kind: SendActivity
id: sendActivity_DJjpWW
activity: "{Topic.ホストURL} {Topic.ロールID} <query> <role-secret>"
- kind: InvokeConnectorAction
id: invokeConnectorAction_DlIYgp
input:
binding:
host_url: =Topic.ホストURL
query: <query>
role-id: =Topic.ロールID
role-secret: <role-secret>
output:
kind: SingleVariableOutputBinding
variable: Topic.odata
connectionReference: crcfa_dgTest1.cr.HhL_gJY5
connectionProperties:
mode: Maker
usageDescription:
operationId: odata
latencyMessageSettings:
allowLatencyMessage: true
latencyMessage: テスト
errorHandling:
kind: ContinueOnErrorBehavior
statusCode: Topic.Var1
errorResponseBody: Topic.Errorbody
requestTimeoutInMilliseconds: 30000
- kind: SendActivity
id: sendActivity_rADfvd
activity: "{Topic.odata}{Topic.Errorbody} {Topic.Var1} "
-
Can you share the YAML for your topic? What is the data type of the variable that is mapped to the connector input?