NewsOperate As is live. Send your first client one link
Operate As

Integration

Matillion

Data integration and ELT: projects, pipelines and executions. Your client pastes their Matillion key once, and your agent or your code works with their access.

Spreadsheets and databases

About Matillion

Through Operate As, your agent, n8n workflow or code works in Matillion with your client's own access. Your client pastes their client ID from Matillion once. We store it encrypted, so it never sits in an email or a shared doc. Your agent reaches any endpoint of Matillion's API through the request tool, with the client's access attached.

Common uses in Spreadsheets and databases

  • Log leads, orders or form entries as they arrive
  • Keep a shared tracker up to date without copying and pasting
  • Pull rows into a weekly report

Matillion

Matillion · Spreadsheets and databases

API key

Data integration and ELT: projects, pipelines and executions

The client pastes their client ID from Matillion's settings. We store it encrypted.

Tested against Matillion's live API.

Building with Matillion? The docs have setup steps and code for every tool.

Open the Matillion docs

Tools

Your agent calls any endpoint of Matillion's API with the request tool, with the client's access attached.

Base URL for request

https://us1.api.matillion.com/dpc

  • request

    HTTPS ANY /v1/clients/{clientId}/matillion/{path}

    Any endpoint of Matillion's own API, with the client's access attached.

    servicestringrequired
    This service: matillion
    methodstringrequired
    GET, POST, PUT, PATCH or DELETE
    pathstringrequired
    The path under https://us1.api.matillion.com/dpc
    queryobjectoptional
    Query parameters
    bodyobjectoptional
    A JSON body

Over MCP every tool also takes client_id, from list_clients. Over HTTPS send it as clientId to https://api.operate.as/v1.

What the client approves

  • Use the Matillion key you paste, with only the access you gave that key

Related

More in Spreadsheets and databases

Browse every service

Get started

Send your next client one link

Add a client, select the services, copy the link. You'll get an email the moment their access is ready. Start free, no card required. Paid plans are one flat monthly price, and a busy month never takes your agents offline.

Prefer email? hello@operate.as