Azure Synapse Analytics · Arazzo Workflow

Azure Synapse Analytics Provision Linked Service and Dataset

Version 1.0.0

Create a linked service, confirm it, then create a dataset bound to it.

1 workflow 2 source APIs 1 provider
View Spec View on GitHub AnalyticsApache SparkBig DataData IntegrationData WarehouseETLSQLArazzoWorkflows

Provider

microsoft-azure-synapse-analytics

Workflows

provision-linked-service-and-dataset
Stand up a linked service and a dataset that references it.
Creates or updates a linked service, verifies it was stored, then creates a dataset that binds to that linked service via its linkedServiceName reference.
3 steps inputs: apiVersion, dataset, datasetName, linkedService, linkedServiceName outputs: datasetId, linkedServiceId
1
createLinkedService
Create or update the linked service that defines the connection to the backing data store.
2
confirmLinkedService
Read the linked service back to confirm it was persisted before binding a dataset to it.
3
createDataset
Create or update a dataset whose linkedServiceName reference points at the linked service provisioned above.

Source API Descriptions

Arazzo Workflow Specification

Raw ↑
arazzo: 1.0.1
info:
  title: Azure Synapse Analytics Provision Linked Service and Dataset
  summary: Create a linked service, confirm it, then create a dataset bound to it.
  description: >-
    Datasets in Azure Synapse Analytics reference a linked service that defines
    the connection to the underlying data store. This workflow first publishes
    the linked service, reads it back to confirm it persisted, and then creates
    a dataset whose linkedServiceName reference points at the newly provisioned
    linked service. Every step spells out its request inline so the flow can be
    read and executed without opening the underlying OpenAPI description.
  version: 1.0.0
sourceDescriptions:
- name: datasetApi
  url: ../openapi/microsoft-azure-synapse-analytics-dataset-api-openapi.yml
  type: openapi
- name: linkedserviceApi
  url: ../openapi/microsoft-azure-synapse-analytics-linkedservice-api-openapi.yml
  type: openapi
workflows:
- workflowId: provision-linked-service-and-dataset
  summary: Stand up a linked service and a dataset that references it.
  description: >-
    Creates or updates a linked service, verifies it was stored, then creates a
    dataset that binds to that linked service via its linkedServiceName
    reference.
  inputs:
    type: object
    required:
    - apiVersion
    - linkedServiceName
    - linkedService
    - datasetName
    - dataset
    properties:
      apiVersion:
        type: string
        description: The Synapse data plane API version (e.g. 2020-12-01).
      linkedServiceName:
        type: string
        description: The name of the linked service to create or update.
      linkedService:
        type: object
        description: The LinkedServiceResource definition to publish.
      datasetName:
        type: string
        description: The name of the dataset to create or update.
      dataset:
        type: object
        description: >-
          The DatasetResource definition. Its
          properties.linkedServiceName.referenceName should match the linked
          service created in this flow.
  steps:
  - stepId: createLinkedService
    description: >-
      Create or update the linked service that defines the connection to the
      backing data store.
    operationId: LinkedService_CreateOrUpdateLinkedService
    parameters:
    - name: api-version
      in: query
      value: $inputs.apiVersion
    - name: linkedServiceName
      in: path
      value: $inputs.linkedServiceName
    requestBody:
      contentType: application/json
      payload: $inputs.linkedService
    successCriteria:
    - condition: $statusCode == 200
    outputs:
      linkedServiceId: $response.body#/id
  - stepId: confirmLinkedService
    description: >-
      Read the linked service back to confirm it was persisted before binding a
      dataset to it.
    operationId: LinkedService_GetLinkedService
    parameters:
    - name: api-version
      in: query
      value: $inputs.apiVersion
    - name: linkedServiceName
      in: path
      value: $inputs.linkedServiceName
    successCriteria:
    - condition: $statusCode == 200
    outputs:
      confirmedName: $response.body#/name
  - stepId: createDataset
    description: >-
      Create or update a dataset whose linkedServiceName reference points at the
      linked service provisioned above.
    operationId: Dataset_CreateOrUpdateDataset
    parameters:
    - name: api-version
      in: query
      value: $inputs.apiVersion
    - name: datasetName
      in: path
      value: $inputs.datasetName
    requestBody:
      contentType: application/json
      payload: $inputs.dataset
    successCriteria:
    - condition: $statusCode == 200
    outputs:
      datasetId: $response.body#/id
  outputs:
    linkedServiceId: $steps.createLinkedService.outputs.linkedServiceId
    datasetId: $steps.createDataset.outputs.datasetId

Work with this as data

Every workflow here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for arazzo workflows

4 MCP tools reach this
  • find_arazzoBrowse and filter every workflow in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This workflow
curl "https://apis.io/api/v1/arazzo/microsoft-azure-synapse-analytics-provision-linked-service-and-dataset-workflow"
All arazzo workflows
curl "https://apis.io/api/v1/arazzo?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.