Microsoft Fabric Updates Blog

OneLake Shortcuts APIs available in Preview

Microsoft Fabric REST APIs allow users and developers to automate common actions and programmatically interact with Fabric. This allows teams and organizations to develop solutions that can scale and integrate with other parts of their systems.

Before today, OneLake shortcuts could only be created using the Fabric web experience. This meant that our users were limited to interactively creating and managing shortcuts through the web. We’ve heard from Fabric and OneLake users and developers that you need a way to work with shortcuts programmatically.

Today, Microsoft OneLake is introducing new REST APIs that allow programmatic creation and management of shortcuts!

With this initial Preview release of the OneLake shortcuts REST APIs, we’ve introduced three new operations:

  • Creating new shortcuts to OneLake folders and tables or to external storage locations, such as Azure Data Lake Storage (ADLS) Gen2, Amazon S3, or Dataverse.
  • Reading shortcut definition details of existing shortcuts
  • Deleting shortcuts

Soon, we will introduce a few additional operations to this set of APIs, including listing shortcuts and updating existing shortcuts – stay tuned!

Documentation

An introduction to the use of Fabric REST APIs can be found here – this will familiarize you with the prerequisite steps to using these REST APIs.

The reference material for the new OneLake REST API operations can be found here, and a walkthrough with examples can be found here.

Example – Create shortcut to ADLS Gen2 folder

Here’s a brief sample request for creating a shortcut to a folder in Azure Data Lake Storage (ADLS) Gen2. The connection ID can be found in the “Settings” area of your ADLS Gen2 cloud connection.

POST https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{itemId}/shortcuts

{

   "path": "Files/landingZone", //path to shortcut parent directory

   "name": "Contoso_Products ", //shortcut directory name

   "target": {

      "adlsGen2": {

         "location": "https://contosoadlsaccount.dfs.core.windows.net", //ADLS Gen2 account endpoint

         "subpath": "/mycontainer/data/ProductsLatest", //path to target directory (including container)

         "connectionId": "91324db9-8dc4-4730-a1e5-bafabf1fb91e" //cloud connection ID for the ADLS Gen2 account with the same location

      }

   }

}

Full details of the Create operation can be found here.


We expect these APIs will help you programmatically interact with OneLake and Fabric. As always, we appreciate your feedback and ideas for future improvements. Please submit any feedback or suggestions at Microsoft Fabric Ideas.

Zugehörige Blogbeiträge

OneLake Shortcuts APIs available in Preview

September 27, 2024 von Naama Tsafrir

Introducing tags – now in public preview. When it comes to data discovery and management, the modern data estate presents a set of daunting challenges for organizations and admins. An explosion in data sources coupled with rapid movement to the cloud is accommodating admins of all type, as well as CDOs and data stewards busy. … Continue reading “Tag your data to enrich item curation and discovery”

September 25, 2024 von Wilson Lee

Mirroring for Snowflake is now generally available, a frictionless way to add your entire Snowflake databases into OneLake data estate. Setting up Mirroring is trivial and simple. Once Mirroring starts the replication process, the mirrored data is automatically kept up to date at near real-time in OneLake. With your Snowflake data landed into OneLake, the … Continue reading “Announcing the General Availability of Mirroring for Snowflake in Microsoft Fabric”