garddolau's avatar
garddolau
Advocate III
1 year ago
Status:
Completed

Fabric REST APIs - SQL Database - Return connection details

Hi Team,

Great to get the ability to create a SQL Database via API are you working on the ability to return the connection details?


To make it more useful it would be great if we could get the connection details for the created database to (similar to how we can get in warehouse).

 

** Once completed can we update the offical documentation ASAP so the Terraform provided team can start using **

 

Return something like below:

 

{
  "id": "5b218778-e7a5-4d73-8187-f10824047715",
  "displayName": "SQLDatabase1",
  "description": "A SQLDatabase description.",
  "type": "SQLDatabase",
  "workspaceId": "cfafbeb1-8037-4d0c-896e-a46fb27ff229"
  "properties": {
    "serverFqdn": "dqjx2zrgh4uejnetrut54cdkau-g3353rbpoubuvclqhgoznhkmji.database.fabric.microsoft.com",
    "databaseName": "SQLDatabase1-b218778-e7a5-4d73-8187-f10824047715"
  },
}

 

Thanks,
Darren

4 Comments

  • akatesmith's avatar
    akatesmith
    Microsoft Employee
    Status changed:
    New
    to
    Completed

    If you don't see this available already, you should see it soon.  

  • akatesmith Can we get the official documentation updated to please? (The terraform team will only implement changes with the provider when they see it here)
  • akatesmith's avatar
    akatesmith
    Microsoft Employee

    This should be documented under the GET command in the REST API.  We do not return the connection string in the create command - you have to create, parse the id from the response and post a GET.

  • This is now completed and documentation updated to match

Recent ideas