GET /api/v3/import/reading/profile

Retrieves all interval data (reading) import profiles

GetReadingImportProfilesV3 Permissions: IntervalData (Manage)
Use this endpoint to list all available reading import profiles. These profiles define how delimited text files are mapped to channel readings during import. Requires Interval Data Manage permission.

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.

Responses

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

Response Body Parameters

Array of:

ReadingImportProfileResponse
Property Description Type
channelImportIdColumnNumber The number of the column that holds the Channel import identifier integer (int32)
channelIntervalInSeconds The interval of the readings integer (int32)
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)
dataMapping A list of columns from the import sheet with their observation type and unit ReadingImportProfileColumn[]
ReadingImportProfileColumn properties
Property Description Type
columnNumber The number of the column Must be between 1 and 2147483647 integer (int32)
observationTypeCode The observation type code of the reading Required Must be between 0 and 16 characters string
unitCode The unit code of the reading Required Must be between 0 and 16 characters 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
delimiter The string that represents how the file contents are delimited. Valid options are “\t” for tab, " " for space and “,” for comma. 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
meterImportIdColumnNumber The number of the column that holds the Meter import identifier integer (int32)
noteColumnNumber Column number that holds a note to be stored with the reading integer (int32)
numberOfColumns The total number of columns in the import sheet integer (int32)
numberOfHeaderRows Number of header rows before the data begins integer (int32)
profileCode The profile code string
profileId The profile Identifier 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
timestampColumnNumber The number of the column that holds the timestamp integer (int32)
timestampFormat The format for the timestamp of the readings. An example is MM/dd/yyyy mm:hh:ss:zzz string
Example Response application/json 
[
  {    "channelImportIdColumnNumber": 1,    "channelIntervalInSeconds": 1,    "createdBy": {      "fullName": "string",      "userCode": "string",      "userId": 1
    },    "dataMapping": [
      {      "columnNumber": 1,      "observationTypeCode": "string",      "unitCode": "string"
    }
    ],    "dateColumnNumber": 1,    "dateFormat": "string",    "delimiter": "string",    "estimated": {      "columnNumber": 1,      "indicator": "string"
    },    "meterImportIdColumnNumber": 1,    "noteColumnNumber": 1,    "numberOfColumns": 1,    "numberOfHeaderRows": 1,    "profileCode": "string",    "profileId": 1,    "timeColumnNumber": 1,    "timeFormat": "string",    "timeZone": {      "timeZoneCode": "string",      "timeZoneId": 1,      "timeZoneInfo": "string"
    },    "timestampColumnNumber": 1,    "timestampFormat": "string"
  }
]