Custom connector action getting System Error

(1) Share

Report

Posted on by irwanto_andrew

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!

Categories:

Calling actions from Copilot Studio

I have the same question (0)

All responses (8)

Answers (0)

adilei Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Can you share the YAML for your topic? What is the data type of the variable that is mapped to the connector input?

Was this reply helpful? Yes No
irwanto_andrew 15 on at

Like (0)

Report
Copy link

Link copied!

-

Was this reply helpful? Yes No
irwanto_andrew 15 on at

Like (0)

Report
Copy link

Link copied!
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} "

Was this reply helpful? Yes No
irwanto_andrew 15 on at

Like (0)

Report
Copy link

Link copied!

-

Was this reply helpful? Yes No
irwanto_andrew 15 on at

Like (0)

Report
Copy link

Link copied!

-

Was this reply helpful? Yes No
irwanto_andrew 15 on at

Like (0)

Report
Copy link

Link copied!

-

Was this reply helpful? Yes No
irwanto_andrew 15 on at

Like (0)

Report
Copy link

Link copied!

Hi @AD ,
Do let me know if there are anything else needed, thank you!

Was this reply helpful? Yes No
Suggested answer

CU19070401-0 32 on at

Like (0)

Report
Copy link

Link copied!

Here is a list of very useful working demo resources on how to create a custom connector in Power Automate and how to call that custom connector in Copilot Studio. Using this, you can connect to your live API:

YouTube Video on how to add and call custom connector in Copilot Studio: https://www.youtube.com/watch?v=J5i16kAzwpI

Blog article on how to add and call custom connector in Copilot Studio: https://global-sharepoint.com/copilot/call-custom-connector-in-copilot/

YouTube Video on how to create custom connector in Power Automate with Third Party API: https://youtu.be/CygB6TCZFO4

Blog article on how to create custom connector in Power Automate with Third Party API: https://global-sharepoint.com/sharepoint/power-automate-custom-connector/

YouTube video on how to create custom topic with GenAI in Copilot Studio: https://youtu.be/VSmo5KQRnTY

Was this reply helpful? Yes No