v1

latestOpenAPI 3.0.0Apache 2.02026-07-24112122.9 KB
Import API

Start with Data

Create an ETL job, upload JSON data, and start the job in a single step. The maximum JSON payload size is 25MB

post/etl/templates/{templateId}/startWithData

Path parameters

templateIdstring required
Example:123456789012345678

ID of the ETL template

Request body

Example request

{
  "input": {
    "data": [
      [
        "Account",
        "Entity",
        "Department",
        "Placeholder 1",
        "Placeholder 2",
        "Placeholder 3",
        "Placeholder 4",
        "Year",
        "Period",
        "Scenario",
        "Currency",
        "Measure",
        "Value"
      ],
      [
        "3910",
        "V001",
        "D10",
        "Undefined",
        "Undefined",
        "Undefined",
        "Undefined",
        "2019",
        "1",
        "Actual",
        "Local",
        "Value",
        "2511.71"
      ],
      [
        "3910",
        "V001",
        "D10",
        "Undefined",
        "Undefined",
        "Undefined",
        "Undefined",
        "2019",
        "2",
        "Actual",
        "Local",
        "Value",
        "2511.71"
      ],
      [
        "3910",
        "V001",
        "D10",
        "Undefined",
        "Undefined",
        "Undefined",
        "Undefined",
        "2019",
        "3",
        "Actual",
        "Local",
        "Value",
        "2511.71"
      ]
    ]
  }
}

Response

Successfully started job, data has been received by Vena

idstring
namestring
status'EDITING' | 'NOT_STARTED' | 'SUBMITTED' | 'RUNNING' | 'COMPLETED' | 'ERROR' | 'CANCELLED' | 'WAITING' | 'QUEUED' | 'EXPIRED'
modelIdstring
modelNamestring
createdDateinteger
updatedDateinteger
userNamestring