You can use a notebook NB_GetWorkspaceNameById to convert ID into name. In a notebook you can use the Fabric API to get info on a workspace by ID.
Workspaces - Get Workspace - REST API (Core) | Microsoft Learn
However you need an access token with user interaction to use Fabric API. I currently have pipelines that need you to get an access token in NB_GetAccessToken before running the pipeline.
Maybe you could even do it without notebook and in the pipeline with a web activity:
Re: Fabric API - Service Principle alternatives - Microsoft Fabric Community
NB_GetWorkspaceNameById
# parameter cell start #
workspace_id = ''
access_token = ''
# parameter cell end #
import requests
url = f'https://api.fabric.microsoft.com/v1/workspaces/{workspace_id}'
headers = {
'Authorization': f'Bearer {access_token}'
}
response = requests.get(url, headers=headers)
response_json = response.json()
print(response.status_code)
print(response_json)
workspace_name = response_json['displayName']
NB_GetAccessToken
# parameter cell start #
tenant_id = ''
client_id = ''
# parameter cell end #
import requests
import json
from msal import PublicClientApplication
from datetime import datetime, timedelta
import pytz
app = PublicClientApplication(
client_id = client_id,
authority = 'https://login.microsoftonline.com/' + tenant_id
)
print("json response:")
scopes = ['https://api.fabric.microsoft.com/Workspace.ReadWrite.All https://api.fabric.microsoft.com/Item.ReadWrite.All']
json_response = app.initiate_device_flow(scopes = scopes)
print(json_response)
# Return the token as soon as user completes her/his part of device code flow
response_dict = app.acquire_token_by_device_flow(json_response)
try:
access_token = response_dict['access_token']
print("\naccess token:")
print(access_token)
expiration_time = datetime.now(pytz.timezone('Europe/Amsterdam')) + timedelta(seconds=response_dict['expires_in'])
print(f"\nexpiration time: {expiration_time}")
except:
print('\nSomething went wrong')
print(response_dict['error_description'])
