microsoft / microsoft/PowerPlatformConnectors
[BUG] Snowflake - Convert operation is expecting a property 'rowType' not defined in the swagger file
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
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
- 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 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