topic Shortcut creation with code/API in Data Engineering

Shortcut creation with code/API

Anonymous — Fri, 01 Dec 2023 15:28:14 GMT

I have multiple delta tables in Azure Data Lake Storage Gen2. I would now like to create shortcuts to these delta tables. Instead of doing this manually in the lakehouse, I was wondering if this was possible with code (for example, Python) or an API. It would save a lot of time.

I saw the recent announcement about the Lakehouse API (https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-api), but I am not seeing anything about creating shortcuts.

Re: Shortcut creation with code/API

Anonymous — Fri, 01 Dec 2023 16:26:06 GMT

Hi @Anonymous
Thanks for using Fabric Community.
Currently API for creating shortcuts is not yet supported in Fabric. But this is on roadmap.

For more information please refer to this link: Link1

Hope this helps. Please do let us know if you have any further questions.

Re: Shortcut creation with code/API

ElektroHulk — Mon, 07 Apr 2025 11:13:25 GMT

Good day,
Has this been implemented already?
I have attempted to perform the shortcut creation to Dataverse programatically in Fabric Notebook, however I can not make it work.
Therefore, my question is, has the support for shortcut creation has already been added to the API or not yet?

Just in case, I will add some context to my case. I have created a Link to Microsoft Fabric from my Dataverse environment to a Lakehouse in Fabric. I have removed 1-2 tables in Fabric, thus removing the shortcuts. I want now to add the shortcuts back, but I need to do it programatically.
This is the code that I am using to call the API:

entity = 'actioncard' url = f"https://api.fabric.microsoft.com/v1/workspaces/{WORKSPACE_ID}/items/{LAKEHOUSE_ID}/shortcuts" headers = { "Authorization": f"Bearer {token}", "Content-Type": "application/json" } # create shortcuts for a list of entities for entity in MISSING_ENTITIES: print(entity) payload = { "name": entity, "path": f"Tables/{entity}", "target": { "dataverse" : { "deltaLakeFolder": "", "environmentDomain": DATAVERSE_END_URL, "tableName": f"{entity}", "connectionId": CONNECTION_ID } } } try: response = requests.post(url, headers=headers, json=payload)

I am getting the following 400 error:

Failed to create actioncard: 400 - {"requestId":"1534w4aa-e00a-4f05-aa9f-d4c5573456c9","errorCode":"BadRequest","moreDetails":[{"errorCode":"RequestBodyValidationFailed","message":"Shortcut target uri /actioncard:Dataverse is malformed."}],"message":"The request could not be processed due to missing or invalid information"}

If the support has been implemented but I am taking the wrong approach, please reffer to the correct documentation.

Thanks a lot in advance.