microsoft / microsoft/PowerPlatformConnectors

[BUG] Snowflake - Convert operation is expecting a property 'rowType' not defined in the swagger file

Open
#2,330 6 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

Independent Publisher Connector

Name of Connector

Snowflake

Describe the bug

The 'Convert result set rows from array to obects' is always failing with a 400 error:
{
"Message": "rowType or data parameter are empty!"
}

The reason is because the script file is expecting a 'rowType' property: (https://github.com/microsoft/PowerPlatformConnectors/blob/f7f4c9100692791b610228ce4f6a737bc2cad6b5/independent-publisher-connectors/snowflake/script.csx#L33)

This property is not defined in the swagger file definition. I see a property called 'resultSetMetaData' (https://github.com/microsoft/PowerPlatformConnectors/blob/f7f4c9100692791b610228ce4f6a737bc2cad6b5/independent-publisher-connectors/snowflake/apiDefinition.swagger.json#L1225).

They should be the same.

Is this a security bug?

No, this is not a security bug

What is the severity of this bug?

Severity 2 - One or more important connector features are down

To Reproduce

Just test the operation. You dont even need a working connection - since this is implemented in code.
You will always get this error.

Expected behavior

The operation succeeds.

Environment summary

N/A

Additional context

N/A

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 with independent-publisher-connectors/snowflake/script.csx near line 33 and compare its expected fields with independent-publisher-connectors/snowflake/apiDefinition.swagger.json near line 1225. Run the Snowflake Convert result set rows from array to objects operation without a connection, then verify it no longer returns the reported 400 error and that the API definition and script agree.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp
Domain
api
Issue type
Bug
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Clearly specified
Newbie friendliness
48/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.