Forum Discussion

raym85's avatar
raym85
Advocate I
1 year ago
Solved

Issues with Fabric Connection REST API and On-Prem Connections

  Hi everyone, I’ve been working with the Fabric Connection REST API (POST https://api.fabric.microsoft.com/v1/connections) and have run into challenges when trying to use it with an on-premises co...
data engineering
  • v-hashadapu's avatar
    v-hashadapu
    1 year ago

    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.

v-hashadapu's avatar
v-hashadapu
Community Support
1 year ago

Hi @raym85 , Please let us know if your issue is solved. If it is, consider marking the answers that helped 'Accept as Solution', so others with similar queries can find them easily. If not, please share the details.
Thank you.