dbt · Arazzo Workflow

dbt Cloud Get Run and Fetch Its Artifacts

Version 1.0.0

Read a run, branch on whether it succeeded, and list its artifacts only on success.

1 workflow 1 source API 1 provider
View Spec View on GitHub Analytics EngineeringDataELTMetricsProjectSQLTransformationArazzoWorkflows

Provider

dbt

Workflows

run-and-fetch-artifacts
List artifacts for a run only when the run reports status 10 (success).
Reads the run, and if status is 10 (success) lists its artifacts; otherwise ends without fetching artifacts.
2 steps inputs: accountId, runId, token outputs: artifacts, status
1
getRun
Read the run resource. Status 10 means the run succeeded and produced artifacts; any other status means artifacts should not be fetched.
2
listArtifacts
List the artifacts produced by the successful run (manifest.json, catalog.json, run_results.json).

Source API Descriptions

Arazzo Workflow Specification

Raw ↑
arazzo: 1.0.1
info:
  title: dbt Cloud Get Run and Fetch Its Artifacts
  summary: Read a run, branch on whether it succeeded, and list its artifacts only on success.
  description: >-
    A guarded artifact retrieval flow. The workflow reads a known run, branches
    on the terminal success status (status code 10), and only when the run
    succeeded does it list the produced artifacts. This avoids attempting to
    pull artifacts for runs that are still in flight or that failed. 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: runsApi
  url: ../openapi/dbt-runs-api-openapi.yml
  type: openapi
workflows:
- workflowId: run-and-fetch-artifacts
  summary: List artifacts for a run only when the run reports status 10 (success).
  description: >-
    Reads the run, and if status is 10 (success) lists its artifacts; otherwise
    ends without fetching artifacts.
  inputs:
    type: object
    required:
    - accountId
    - runId
    - token
    properties:
      accountId:
        type: integer
        description: The dbt Cloud account id.
      runId:
        type: integer
        description: The id of the run to inspect.
      token:
        type: string
        description: The dbt Cloud service token (sent as Authorization Bearer Token).
  steps:
  - stepId: getRun
    description: >-
      Read the run resource. Status 10 means the run succeeded and produced
      artifacts; any other status means artifacts should not be fetched.
    operationId: getRun
    parameters:
    - name: Authorization
      in: header
      value: Bearer $inputs.token
    - name: accountId
      in: path
      value: $inputs.accountId
    - name: runId
      in: path
      value: $inputs.runId
    successCriteria:
    - condition: $statusCode == 200
    outputs:
      status: $response.body#/data/status
      isComplete: $response.body#/data/is_complete
    onSuccess:
    - name: succeeded
      type: goto
      stepId: listArtifacts
      criteria:
      - context: $response.body
        condition: $.data.status == 10
        type: jsonpath
    - name: notSucceeded
      type: end
      criteria:
      - context: $response.body
        condition: $.data.status != 10
        type: jsonpath
  - stepId: listArtifacts
    description: >-
      List the artifacts produced by the successful run (manifest.json,
      catalog.json, run_results.json).
    operationId: listRunArtifacts
    parameters:
    - name: Authorization
      in: header
      value: Bearer $inputs.token
    - name: accountId
      in: path
      value: $inputs.accountId
    - name: runId
      in: path
      value: $inputs.runId
    successCriteria:
    - condition: $statusCode == 200
    outputs:
      artifacts: $response.body#/data
  outputs:
    status: $steps.getRun.outputs.status
    artifacts: $steps.listArtifacts.outputs.artifacts

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/dbt-run-and-fetch-artifacts-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.