Import API
Load JSON to Specific Input
Upload JSON data to a single ETL step of a job without executing the job
put/etl/jobs/{jobId}/inputs/{inputId}
Path parameters
jobIdstring required
Example:1234567890123456789
ID of the ETL Job (18 or 19 digits)
inputIdstring required
The Id of the ETL step. Can be found from the Get ETL template endpoint.
Request body
Example request
{
"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
No Content