Forum Discussion
Issues with Fabric Connection REST API and On-Prem Connections
Hi raym85 , Thank you for reaching out to the Microsoft Community Forum.s
Based on the error message you’re receiving (400 - invalid input: the Values field is required) and the payload you shared, the problem likely stems from incorrect formatting of the connectionDetails.parameters section. In Fabric’s REST API, the parameters field typically requires a values property, which should contain an array of parameter values. The API might expect the SQL connection string in a specific format rather than individual server and database parameters.
Fabric REST APIs - Create Connection
If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
Hi raym85 , Thank you for reaching out to the Microsoft Community Forum.s
Based on the error message you’re receiving (400 - invalid input: the Values field is required) and the payload you shared, the problem likely stems from incorrect formatting of the connectionDetails.parameters section. In Fabric’s REST API, the parameters field typically requires a values property, which should contain an array of parameter values. The API might expect the SQL connection string in a specific format rather than individual server and database parameters.
Fabric REST APIs - Create Connection
If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
No the example in the documentation does not give a sample to show what the payload should look like. Can you show me what it should look like?
Hi , Thank you for reaching out to the Microsoft Community Forum.
You’re right, the docs at Create Connection show cloud and VNet examples but don’t give a sample for an on-premises SQL connection. I just mentioned the documentation for reference. Please try below:
{
"connectivityType": "OnPremisesGateway",
"gatewayId": "your-gateway-id-here",
"displayName": "sqlconnonprem",
"connectionDetails": {
"type": "SQL",
"creationMethod": "SQL",
"parameters": [
{ "dataType": "Text", "name": "server", "value": "your_server_name" },
{ "dataType": "Text", "name": "database", "value": "your_database_name" }
]
},
"privacyLevel": "Organizational",
"credentialDetails": {
"singleSignOnType": "None",
"connectionEncryption": "Any",
"skipTestConnection": false,
"credentials": {
"credentialType": "Basic",
"username": "your_username",
"password": "your_password"
}
}
}
If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
