Fabric REST APIs - SQL Database - Return connection details

[garddolau]

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

[akatesmith]

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

[garddolau]

@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]

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.

[garddolau]

This is now completed and documentation updated to match