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