Coalescesoftware Jobs

Name: Jobs API
Brand: Jobs
Availability: InStock

★ Only Publicly Available OpenAPI DocumentDeveloper ToolsCi CdapiKey,bearer11 EndpointsREST

For Agents

Trigger Coalesce data transformation runs, list environments and nodes, and fetch run results so an agent can orchestrate Snowflake pipelines without using the Coalesce UI.

Install Jentic One Beta

Connect the Jobs to your agent

Jentic One is a self-hosted execution layer for AI agents. It lets your agent call the Jobs, or any other public or private API you need. You set the rules, the agent never sees your credentials, and every call is logged.

Two steps, two machines. Install the instance in a safe environment, then register your agent from wherever it runs.

Step 1: Jentic One Host machine

# On the machine that will host your Jentic One instance:
curl -fsSL https://raw.githubusercontent.com/jentic/jentic-one/main/tools/install.sh | sh

Step 2: Agent machine

# On the machine where your agent runs (keep this separate from the instance):
curl -fsSL https://raw.githubusercontent.com/jentic/jentic-one/main/tools/install.sh | sh
jentic register       # connects your agent to your Jentic One instance

Jentic One is in public beta. The setup above keeps your agent separate from the instance, which is what you want before using real credentials: an agent running as the same OS user as Jentic One can read its stored keys directly. Just evaluating? A single local install is fine to start. See the secure deployment guide for the tiers.

Capabilities

What an agent can do with Jobs API.

Trigger a scheduled Coalesce run via the /scheduler/startRun endpoint

Cancel an in-flight run with /scheduler/cancelRun before it consumes more compute

Re-run a failed transformation through /scheduler/rerun without rebuilding the schedule

GET STARTED

Start building with Jobs API

Explore with Jentic

View OpenAPI Document

Use Cases

Patterns agents use Jobs API for, with concrete tasks.

★ External Scheduler Integration

Orchestrate Coalesce transformation runs from Airflow, Dagster, or a custom scheduler by calling /scheduler/startRun with the target environment and job, then polling /scheduler/runStatus until the run completes. This pattern replaces relying on Coalesce's built-in scheduler when teams already have a wider data orchestration stack and want a single source of truth for DAG dependencies.

Call POST /scheduler/startRun with environmentID and jobID, then poll /scheduler/runStatus every 30 seconds until status is SUCCESS or FAILED and surface the result

Run Failure Recovery

Detect failed Coalesce runs from a monitoring layer and recover by calling /scheduler/rerun with the failed run ID. Combined with /api/v1/runs/{runID}/results this lets a recovery agent identify which nodes failed, decide whether a rerun is safe, and trigger it without human intervention for idempotent transformations.

Fetch GET /api/v1/runs/{runID}/results for the latest failed run, identify node failures, and call /scheduler/rerun if all failed nodes are marked retry-safe

Environment and Node Discovery

Build internal tooling that documents which Coalesce environments and nodes exist across regions by listing /api/v1/environments and walking nodes for each environment. This is useful for governance teams cataloguing transformation assets or building lineage graphs across multiple Coalesce deployments.

List all environments via GET /api/v1/environments, then for each environment enumerate nodes via /api/v1/environments/{environmentID}/nodes and write a flat catalog to storage

Agent-Driven Pipeline Operations

Allow an AI agent to manage Coalesce data pipelines through natural language by exposing run start, cancel, rerun, and status checks as Jentic operations. The agent looks up Coalesce by intent, loads the operation schema, and executes calls without storing the bearer token in conversation context.

Search Jentic for 'trigger a coalesce run', load the startRun schema, and execute the call with environment 'prod' and the job ID requested by the user

Key Endpoints

11 endpoints — the coalesce jobs api lets data teams trigger, monitor, and manage data transformation runs in the coalesce platform programmatically.

METHOD

PATH

DESCRIPTION

POST

/scheduler/startRun

Trigger a scheduled run

GET

/scheduler/runStatus

Check status of a run

POST

/scheduler/rerun

Re-run a failed job

POST

/scheduler/cancelRun

Cancel an in-flight run

GET

/api/v1/environments

List environments

GET

/api/v1/runs

List runs

GET

/api/v1/runs/{runID}/results

Get results for a specific run

POST

/scheduler/startRun

Trigger a scheduled run

GET

/scheduler/runStatus

Check status of a run

POST

/scheduler/rerun

Re-run a failed job

POST

/scheduler/cancelRun

Cancel an in-flight run

GET

/api/v1/environments

List environments

GET

Why Jentic?

Three things that make agents converge on Jentic-routed access.

Credential isolation

Coalesce bearer tokens and Authorization API keys are stored encrypted in the Jentic vault (MAXsystem). Agents call operations through scoped tokens — raw Coalesce credentials never reach the agent's context.

Intent-based discovery

Agents search by intent (e.g. 'trigger a coalesce run' or 'cancel a coalesce job') and Jentic returns the matching scheduler operations with their input schemas, so the agent can call the right endpoint without browsing Coalesce docs.

Time to first call

Direct Coalesce integration: 1-2 days for auth, run polling, and error handling. Through Jentic: under 1 hour — search, load schema, execute.

FAQs

Specific to using Jobs API through Jentic.

What authentication does the Coalesce Jobs API use?

The Coalesce Jobs API supports two schemes: HTTP bearer tokens and an apiKey passed in the Authorization header. Through Jentic the bearer token is held in the encrypted vault (MAXsystem) and never enters agent context — agents receive scoped, short-lived access only.

Can I trigger a Coalesce run programmatically with this API?

Yes. POST /scheduler/startRun starts a scheduled run for a given job and environment, and /scheduler/runStatus returns its current state. /scheduler/cancelRun and /scheduler/rerun give you control over in-flight and failed runs respectively.

What are the rate limits for the Coalesce Jobs API?

The OpenAPI spec does not publish explicit rate limits. Coalesce runs are gated by your warehouse compute and account plan rather than a per-minute API quota — check your Coalesce account dashboard for current limits before high-frequency polling.

How do I trigger a Coalesce run through Jentic?

Run pip install jentic, then search for 'trigger a coalesce run' through the Jentic SDK. Jentic returns the /scheduler/startRun operation with its input schema; load the schema, populate environmentID and jobID, and execute.

Which Coalesce regions does this API cover?

The spec lists base URLs for US, EU, Canada, and Australia across AWS, Azure, and GCP, including PrivateLink variants for AWS. Pick the server URL that matches your Coalesce deployment region — the path layout is identical across regions.

Can I get per-node results for a completed run?

Yes. GET /api/v1/runs/{runID}/results returns the per-node outcome for a specific run, which is the recommended way to drive failure-recovery logic before calling /scheduler/rerun.

Coalescesoftware Jobs

Connect the Jobs to your agent

Capabilities

Start building with Jobs API

Use Cases

Key Endpoints

Why Jentic?

Related APIs

FAQs