POST /api/v202407/import/esareading/profile

Creates an ESA reading import profile

CreateEsaReadingImportProfileV202407 Permissions: Meters (Create)

Request Headers

Header Value Required Description
ECI-ApiKey string Yes Your API key. See Authentication.
Content-Type application/json Yes All requests must specify JSON content type, including the request body.

Request Body

EsaReadingImportProfileCreate
Property Description Type
channelImportId ColumnNumberOrOverrideValueString
ColumnNumberOrOverrideValueString properties
Property Description Type
columnNumber Column number integer (int32)
overrideValue The value of the column string
dataPointImportId ColumnNumberOrOverrideValueString
ColumnNumberOrOverrideValueString properties
Property Description Type
columnNumber Column number integer (int32)
overrideValue The value of the column string
dateColumnNumber The number of the column that holds the date Mandatory when Date Format column is provided Required when DateFormat is set Must be between 1 and 104 integer (int32)
dateFormat The format for the date of the readings. An example is MM/dd/yyyy Only one of DateFormat, DateTimeFormat can be set string
dateTimeColumnNumber The number of the column that holds the Date and Time Mandatory when Date Time Format column is provided Required when DateTimeFormat is set Must be between 1 and 104 integer (int32)
dateTimeFormat The format for the Date and Time of the readings. An example is MM/dd/yyyy mm:hh:ss:zzz Only one of DateFormat, DateTimeFormat can be set Only one of TimeFormat, DateTimeFormat can be set string
decimalSeparator The string that represents how the decimal values are separated Must be between 1 and 2 characters One of ‘,’, ‘.’ Case sensitive string
delimiter The string that represents how the file contents are delimited Required Must be between 1 and 2 characters string
estimated Estimated
Estimated properties
Property Description Type
columnNumber Column number specifying where to look for the estimated indicator Required Must be between 1 and 2147483647 integer (int32)
indicator The string used to indicate the reading is estimated If this value is found in the column number specified the reading will be marked as estimated Example: e, E, 1, 0, est, *, this is my estimated read Required string
interval ColumnNumberOrOverrideValueNullableInt32
ColumnNumberOrOverrideValueNullableInt32 properties
Property Description Type
columnNumber Column number integer (int32)
overrideValue The value of the column integer (int32)
intervalDataTypes A list of columns from the import sheet with their observation type and unit Cannot be Empty NULL Valid Required when DataPointImportId is set Only one of ReadingValueColumnNumber, IntervalDataTypes can be set EsaReadingImportProfileColumn[]
EsaReadingImportProfileColumn properties
Property Description Type
columnNumber The number of the column Must be between 1 and 104 integer (int32)
observationTypeCode The observation type code of the reading Required Must be between 0 and 16 characters string
numberOfHeaderRows Number of header rows before the data begins (Skip Rows) Required Must be between 0 and 2147483647 integer (int32)
profileDescription Description of the import profile Max length of 255 string
profileInfo Name of the import profile Max length of 50 Required string
readingNoteColumnNumber Column number that holds a note to be stored with the reading Must be between 1 and 104 integer (int32)
readingValueColumnNumber Column number that holds reading value to be imported onto the ChannelImportId Must be between 1 and 104 Required when ChannelImportId is set Only one of ReadingValueColumnNumber, IntervalDataTypes can be set integer (int32)
timeColumnNumber The number of the column that holds the time Mandatory when Date Format column is provided Required when DateFormat is set Must be between 1 and 104 integer (int32)
timeFormat The format for the time of the readings. An example is mm:hh:ss:zzz Mandatory when Date Format column is provided Required when DateFormat is set Only one of TimeFormat, DateTimeFormat can be set string
timeZoneId The time zone for the import profile integer (int32)
Example Request Body application/json 
{  "channelImportId": {    "columnNumber": 1,    "overrideValue": "string"
  },  "dataPointImportId": {    "columnNumber": 1,    "overrideValue": "string"
  },  "dateColumnNumber": 1,  "dateFormat": "string",  "dateTimeColumnNumber": 1,  "dateTimeFormat": "string",  "decimalSeparator": "string",  "delimiter": "string",  "estimated": {    "columnNumber": 1,    "indicator": "string"
  },  "interval": {    "columnNumber": 1,    "overrideValue": 1
  },  "intervalDataTypes": [
    {    "columnNumber": 1,    "observationTypeCode": "string"
  }
  ],  "numberOfHeaderRows": 1,  "profileDescription": "string",  "profileInfo": "string",  "readingNoteColumnNumber": 1,  "readingValueColumnNumber": 1,  "timeColumnNumber": 1,  "timeFormat": "string",  "timeZoneId": 1
}

Responses

200 OK The request succeeded and the response body contains the requested data.

Response Body Parameters

EsaReadingImportProfileResponse
Property Description Type
channelImportId ColumnNumberOrOverrideValueString
ColumnNumberOrOverrideValueString properties
Property Description Type
columnNumber Column number integer (int32)
overrideValue The value of the column string
createdBy UserChild
UserChild properties
Property Description Type
fullName The user’s full name string
userCode The user code string
userId The user identifier integer (int32)
createdDate The date and time the import profile was modified string (date-time)
dataPointImportId ColumnNumberOrOverrideValueString
ColumnNumberOrOverrideValueString properties
Property Description Type
columnNumber Column number integer (int32)
overrideValue The value of the column string
dateColumnNumber The number of the column that holds the date integer (int32)
dateFormat The format for the date of the readings. An example is MM/dd/yyyy string
dateTimeColumnNumber The number of the column that holds the Date and Time integer (int32)
dateTimeFormat The format for the Date and Time of the readings. An example is MM/dd/yyyy mm:hh:ss:zzz string
decimalSeparator The string that represents how the decimal values are separated string
delimiter The string that represents how the file contents are delimited string
estimated Estimated
Estimated properties
Property Description Type
columnNumber Column number specifying where to look for the estimated indicator Required Must be between 1 and 2147483647 integer (int32)
indicator The string used to indicate the reading is estimated If this value is found in the column number specified the reading will be marked as estimated Example: e, E, 1, 0, est, *, this is my estimated read Required string
interval ColumnNumberOrOverrideValueNullableInt32
ColumnNumberOrOverrideValueNullableInt32 properties
Property Description Type
columnNumber Column number integer (int32)
overrideValue The value of the column integer (int32)
intervalDataTypes A list of columns from the import sheet with their observation type and unit EsaReadingImportProfileColumn[]
EsaReadingImportProfileColumn properties
Property Description Type
columnNumber The number of the column Must be between 1 and 104 integer (int32)
observationTypeCode The observation type code of the reading Required Must be between 0 and 16 characters string
modifiedBy UserChild
UserChild properties
Property Description Type
fullName The user’s full name string
userCode The user code string
userId The user identifier integer (int32)
modifiedDate The date and time the import profile was modified string (date-time)
numberOfHeaderRows Number of header rows before the data begins integer (int32)
profileDescription Description of the import profile string
profileId Identifier of the record import profile integer (int32)
profileInfo Name of the import profile string
readingNoteColumnNumber Column number that holds a note to be stored with the reading integer (int32)
readingValueColumnNumber Column number that holds reading value to be imported onto the ChannelImportId integer (int32)
timeColumnNumber The number of the column that holds the time integer (int32)
timeFormat The format for the time of the readings. An example is mm:hh:ss:zzz string
timeZone TimeZoneChild
TimeZoneChild properties
Property Description Type
timeZoneCode string
timeZoneId integer (int32)
timeZoneInfo string
Example Response application/json 
{  "channelImportId": {    "columnNumber": 1,    "overrideValue": "string"
  },  "createdBy": {    "fullName": "string",    "userCode": "string",    "userId": 1
  },  "createdDate": "2026-03-30",  "dataPointImportId": {    "columnNumber": 1,    "overrideValue": "string"
  },  "dateColumnNumber": 1,  "dateFormat": "string",  "dateTimeColumnNumber": 1,  "dateTimeFormat": "string",  "decimalSeparator": "string",  "delimiter": "string",  "estimated": {    "columnNumber": 1,    "indicator": "string"
  },  "interval": {    "columnNumber": 1,    "overrideValue": 1
  },  "intervalDataTypes": [
    {    "columnNumber": 1,    "observationTypeCode": "string"
  }
  ],  "modifiedBy": {    "fullName": "string",    "userCode": "string",    "userId": 1
  },  "modifiedDate": "2026-03-30",  "numberOfHeaderRows": 1,  "profileDescription": "string",  "profileId": 1,  "profileInfo": "string",  "readingNoteColumnNumber": 1,  "readingValueColumnNumber": 1,  "timeColumnNumber": 1,  "timeFormat": "string",  "timeZone": {    "timeZoneCode": "string",    "timeZoneId": 1,    "timeZoneInfo": "string"
  }
}