microsoft / microsoft/PowerPlatformConnectors
Snowflake connector in Power Automate issue
Nobody has claimed this yet.
- 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
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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