Skip to main content
POST
/
organizations
/
{orgId}
/
lookuptables
Create LookupTable
curl --request POST \
  --url https://api.m3ter.com/organizations/{orgId}/lookuptables \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "name": "<string>",
  "code": "<string>",
  "version": 123,
  "customFields": {}
}
'
{
  "id": "<string>",
  "version": 123,
  "customFields": {},
  "name": "<string>",
  "code": "<string>",
  "dtCreated": "2023-11-07T05:31:56Z",
  "dtLastModified": "2023-11-07T05:31:56Z",
  "createdBy": "<string>",
  "lastModifiedBy": "<string>",
  "activeRevision": {
    "id": "<string>",
    "version": 123,
    "customFields": {},
    "name": "<string>",
    "startDate": "2023-11-07T05:31:56Z",
    "fields": [
      {
        "name": "lookuptablerevisionfieldkey"
      }
    ],
    "keys": [
      "<string>"
    ],
    "dtCreated": "2023-11-07T05:31:56Z",
    "dtLastModified": "2023-11-07T05:31:56Z",
    "createdBy": "<string>",
    "lastModifiedBy": "<string>",
    "itemCount": 123,
    "lookupTableId": "<string>"
  }
}

Authorizations

​
Authorization
string
header
required

m3ter supports machine to machine authentication using the clientCredentials OAuth2 flow.

The authorizationCode flow controls access for human users via the m3ter Console application.

Path Parameters

​
orgId
string
required

UUID of the Organization. The Organization represents your company as a direct customer of the m3ter service.

Body

application/json
​
name
string
required

Descriptive name for the Lookup Table.

Required string length: 1 - 200
​
code
string
required

Code of the Lookup Table - unique short code used to identify the Lookup Table.

NOTE: Code has a maximum length of 80 characters and must not contain non-printable or whitespace characters (except space), and cannot start/end with whitespace.

Required string length: 1 - 80
Pattern: ^([^[\p{Cntrl}\s]])|([^[\p{Cntrl}\s]][[^[\p{Cntrl}\s]] ]*[^[\p{Cntrl}\s]])$
​
version
integer<int64>

The version number of the entity:

  • Create entity: Not valid for initial insertion of new entity - do not use for Create. On initial Create, version is set at 1 and listed in the response.
  • Update Entity: On Update, version is required and must match the existing version because a check is performed to ensure sequential versioning is preserved. Version is incremented by 1 and listed in the response.
​
customFields
object

User defined fields enabling you to attach custom data. The value for a custom field can be either a string or a number.

If customFields can also be defined for this entity at the Organizational level, customField values defined at individual level override values of customFields with the same name defined at Organization level.

See Working with Custom Fields in the m3ter documentation for more information.

Response

Return the created Lookup Table

​
id
string
required

The UUID of the entity.

​
version
integer<int64>

The version number:

  • Create: On initial Create to insert a new entity, the version is set at 1 in the response.
  • Update: On successful Update, the version is incremented by 1 in the response.
​
customFields
object

User defined fields enabling you to attach custom data. The value for a custom field can be either a string or a number.

If customFields can also be defined for this entity at the Organizational level,customField values defined at individual level override values of customFields with the same name defined at Organization level.

See Working with Custom Fields in the m3ter documentation for more information.

​
name
string

The name of the Lookup Table

​
code
string

The code of the Lookup Table

​
dtCreated
string<date-time>

The DateTime when the Lookup Table was created.

​
dtLastModified
string<date-time>

The DateTime when the Lookup Table was last modified.

​
createdBy
string

The id of the user who created this Lookup Table.

​
lastModifiedBy
string

The id of the user who last modified this Lookup Table.

​
activeRevision
object