---
updatedAt: 2026-06-18T05:34:13.000Z
agentTools:
  projectIndex: https://developers.venasolutions.com/llms.txt
---

# List ETL Templates

Returns a list of available ETL templates that can be used to start ETL jobs

# OpenAPI definition

```json
{
  "openapi": "3.0.0",
  "info": {
    "title": "Vena API",
    "description": "Vena's API allows users to extract data from their data model, import new data to Vena, query ETL templates, and create asynchronous Vena Table snapshot exports (**Beta**). For all endpoints, the URL parameter `hub` is required (the region of your Vena cloud instance).",
    "license": {
      "name": "Apache 2.0",
      "url": "http://www.apache.org/licenses/LICENSE-2.0.html"
    },
    "version": "1.0.0",
    "contact": {
      "name": "Vena Support",
      "url": "https://support.venasolutions.com/hc/en-us/requests/new"
    }
  },
  "servers": [
    {
      "url": "https://{hub}.vena.io/api/public/v1",
      "description": "Vena API v1",
      "variables": {
        "hub": {
          "default": "us1",
          "enum": [
            "us1",
            "us2",
            "us3",
            "us4",
            "eu1",
            "eu2",
            "ca3"
          ]
        }
      }
    }
  ],
  "security": [
    {
      "basicAuth": []
    }
  ],
  "tags": [
    {
      "name": "Import API",
      "description": "Endpoints to import data into Vena"
    }
  ],
  "paths": {
    "/etl/templates": {
      "get": {
        "tags": [
          "Import API"
        ],
        "summary": "List ETL Templates",
        "description": "Returns a list of available ETL templates that can be used to start ETL jobs",
        "operationId": "listTemplates",
        "responses": {
          "200": {
            "description": "successfully processed template request",
            "content": {
              "application/json": {
                "schema": {
                  "type": "array",
                  "items": {
                    "$ref": "#/components/schemas/ETLTemplate"
                  }
                },
                "example": [
                  {
                    "id": "1234567890123456789",
                    "name": "LoadGL",
                    "lastRunTime": 1714564800000,
                    "modelId": "123456789012345678",
                    "modelName": "Financial Model",
                    "steps": [
                      {
                        "stepName": "Import Hierarchy",
                        "dataType": "hierarchy",
                        "inputId": "139865491454323"
                      },
                      {
                        "stepName": "Stream \"Channel Source\" into \"Channel Destination\" (user_defined)"
                      }
                    ]
                  },
                  {
                    "id": "1234567890123456789",
                    "name": "ExportGL",
                    "lastRunTime": null,
                    "modelId": "123456789012345678",
                    "modelName": "Financial Model",
                    "steps": [
                      {
                        "stepName": "Importing data to Vena Table",
                        "inputId": "14913234259562"
                      }
                    ]
                  }
                ]
              }
            }
          },
          "401": {
            "description": "Invalid authentication credentials"
          },
          "406": {
            "description": "Invalid Accept header"
          }
        }
      }
    }
  },
  "components": {
    "schemas": {
      "ETLTemplate": {
        "type": "object",
        "properties": {
          "id": {
            "type": "string"
          },
          "name": {
            "type": "string"
          },
          "lastRunTime": {
            "type": "integer",
            "nullable": true
          },
          "modelId": {
            "type": "string"
          },
          "modelName": {
            "type": "string"
          },
          "steps": {
            "type": "array",
            "items": {
              "$ref": "#/components/schemas/ETLStep"
            }
          }
        }
      },
      "ETLStep": {
        "type": "object",
        "properties": {
          "stepName": {
            "type": "string"
          },
          "dataType": {
            "type": "string"
          },
          "inputId": {
            "type": "string"
          }
        }
      }
    },
    "securitySchemes": {
      "basicAuth": {
        "type": "http",
        "scheme": "basic"
      }
    }
  },
  "x-readme": {
    "explorer-enabled": false,
    "samples-languages": [
      "http",
      "shell",
      "javascript",
      "python",
      "ruby"
    ]
  }
}
```