You’re offline. This is a read only version of the page.
Announcements
15
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:
Share
Report
All responses (
Answers (
[
{
"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} "
-
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
