microsoft / microsoft/PowerPlatformConnectors

Snowflake connector in Power Automate issue

Open
#2,296 7 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

bug
Dominant language
C#
Stars
1.3k
Forks
1.5k
Avg merge
5d 15h
Merged PRs (30d)
11

Description

Type of Connector

Certified Connector

Name of Connector

Submit SQL Statement for Execution (Snowflake)

Describe the bug

I am getting the following error when trying to use the connector in power Automate.

"The API 'snowflakeip' returned an invalid response for workflow operation 'Submit_SQL_Statement_for_Execution' of type 'OpenApiConnection'. Error details: 'The API operation 'ExecuteSqlStatement' requires the property 'body' to be of type 'Object' but is of type 'String'.'"

I am simply adding the information as required, so the instance, writing the required SQL statement in the statement section etc .

Can you advise how i can resolve this?

Is this a security bug?

No, this is not a security bug

What is the severity of this bug?

Severity 1 - Connector is broken or there is a Serious issue

To Reproduce

Select Submit SQL Statement for Execution from power automate actions

add the instance app.snowflake.com/north-europe.azure/inidividualidentifier

Statement :
SELECT ACTIVITYID
FROM ANALYTICS.DYN.EMAIL

Database: ANALYTICS

Schema: ANALYTICS.DYN

Expected behavior

connection should run successfully without producing error

Environment summary

Install Method (e.g. pip, interactive script, apt-get, Docker, MSI, edge build)
CLI version (paconn --version)
OS version
Shell Type (e.g. bash, cmd.exe, Bash on Windows)

Additional context

Same error is occurring for the other actions provided by this connector.

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the Submit SQL Statement for Execution action in Power Automate with the Snowflake instance and SQL shown in the issue. Check whether the same invalid response occurs for the connector's other actions. Done means the actions execute without the API reporting that body is a String instead of an Object.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
api
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.