List data validation errors
| Time | Status | User Agent | |
|---|---|---|---|
| Make a request to see history. |
URL Expired
The URL for this request expired after 30 days.
📘
Interval Upload Automation Skip link to Interval Upload Automation
For automating the upload of device-level interval data, check out the Interval Data Upload (SFTP) guide.
job_id
uuid
required
``200 Successfully queried the ingestion attempt.
object
job_id
uuid
required
The job ID.
error_csv_file_path
string
Path of the CSV on the Leap SFTP server that contains the errors that occurred trying to ingest the file.
error_summary
array of objects
Aggregations of the errors.
error_summary
object
The list of file ingestion errors.
column
string
The column in the original file that produced the error(s).
code
string
required
The error code of the error.
count
integer
required
The amount of errors of this type.
errors
array of objects
required
The list of file ingestion errors.
errors*
object
The list of file ingestion errors.
line
int32
required
The line in the original file that produced the error(s).
column
string
The column in the original file that produced the error(s).
code
string
required
The error code of the error.
UNCATEGORISED: When the error is not categorised (basically never happens).
LIN_0001: Line is too short for the amount of columns.
MTR_0001: meter_id column is not present.
MTR_0002: meter_id value is not parsable.
MTR_0003: meter_id does not point to a known meter.
STM_0001: interval_start_time_utc is not present.
STM_0002: interval_start_time_utc is not parsable.
STM_0003: interval_start_time_utc is not correct. It either does not align to the right 15-minute start or is in the future.
ETM_0001: interval_end_time_utc is not present.
ETM_0002: interval_end_time_utc is not parsable.
ETM_0003: interval_end_time_utc is not correct. It either does not align to the right 15-minute end or is in the future.
DTR_0003: Date range is not correct. It is not 15 minutes in length (depicted by the interval_start_time_utc and interval_end_time_utc columns).
GEN_0002: energy_generated_kwh is not a number.
GEN_0003: energy_generated_kwh is not correct. It is probably negative.
NET_0002: energy_net_kwh is not a number,
CON_0002: energy_consumed_kwh is not a number,
CON_0003: energy_consumed_kwh is not correct. It is probably negative.
NRG_0001: No correct set of energy column present. Make sure you have energy_net_kwh a combination of energy_generated_kwh and energy_consumed_kwh, or provide all energy columns.
NRG_0003: The energy columns are providing conflicting information.
REG_0002: region is not parsable.
REG_0003: region is not a valid state.
FNL_0002: final is not parsable
message
string
required
The message associated with the error.
``400 Malformed or invalid query.
``401 You are not authorized to perform this operation.
``403 Not authorized to access the requested information.
``404 Information not found.
``500 An internal server error occurred.
Updated 11 months ago
Base URL
https://api.staging.leap.energy/v1.1/jobs/interval-data-uploads/{job_id}
xxxxxxxxxx
curl --request GET \
--url https://api.staging.leap.energy/v1.1/jobs/interval-data-uploads/job_id \
--header 'accept: application/json'
xxxxxxxxxx
{
"job_id": "c09240ce-8942-4eaf-a642-1c728e8d61a3",
"error_csv_file_path": "/interval-data/failed/devices-hvac-januari-2024.72.csv/c09240ce-8942-4eaf-a642-1c728e8d61a3.errors.csv",
"errors": [\
\
{\
\
"line": 12,\
\
"column": "meter_id",\
\
"errors": [\
\
"ba82dd27-8b52-479c-8b19-0a717d88c87z is not a valid UUID."\
\
]\
\
}\
\
]
}
Updated 11 months ago