Vena ETLs (Preview)

Vena's openAPI definition for performing model operations and doing ETL uploads and downloads

Contact

Email | support@venacorp.com This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
Flow Premium All Flow regions except the following:
     -   US Government (GCC)
PowerApps Premium All PowerApps regions except the following:
     -   US Government (GCC)

Creating a connection

To connect your account, you will need the following information:

Name Type Description
username securestring

The username for this api

password securestring

The password for this api

Throttling Limits

Name Calls Renewal Period
API calls per connection10060 seconds

Actions

Trigger an ETL job to import the file to Vena

Upload hierarchy, intersections, lids, or attributes to a model

Trigger an ETL job to import the file to Vena

Upload hierarchy, intersections, lids, or attributes to a model

Parameters

Name Key Required Type Description
Model
modelIdPath True string

Select model

ETL template
templateId True string

Select an ETL template

File name
fileName True string

Select the file name

File content to upload
file True string

Select the file content to upload

File type
fileType True string

Select the file type

Returns

Body
ETLJob

Definitions

ETLMetadata

Name Path Type Description
schemaVersion
schemaVersion integer
steps
steps array of ETLStep
name
name string

ETLJob

Name Path Type Description
status
status string
pauseRequested
pauseRequested boolean
templateId
templateId string
errorMessage
errorMessage string
userId
userId string
lockProperty
lockProperty string
resumable
resumable boolean
user
user object
createdDate
createdDate string
phase
phase string
id
id string
shortMessage
shortMessage string
saveJob
saveJob boolean
log
log array of object
date
log.date string
message
log.message string
lockId
lockId string
rollbackRequired
rollbackRequired boolean
cancelRequested
cancelRequested boolean
updatedDate
updatedDate string
version
version string
requestId
requestId string
error
error boolean
validationResults
validationResults string
attributes
attributes string
currentStepNumber
currentStepNumber string
numCalcOverwrite
numCalcOverwrite string
metadata
metadata ETLMetadata

ETLStep

Name Path Type Description
dataType
dataType string
stepType
stepType string