Skip to main content
GET
/
organizations
/
{orgId}
/
lookuptables
/
{lookupTableId}
/
revisions
/
{lookupTableRevisionId}
/
data
Get LookupTableRevisionData
curl --request GET \
  --url https://api.m3ter.com/organizations/{orgId}/lookuptables/{lookupTableId}/revisions/{lookupTableRevisionId}/data \
  --header 'Authorization: Bearer <token>'
{
  "items": [
    {}
  ],
  "dtCreated": "2023-11-07T05:31:56Z",
  "dtLastModified": "2023-11-07T05:31:56Z",
  "createdBy": "<string>",
  "lastModifiedBy": "<string>",
  "version": 123
}

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.

​
lookupTableId
string
required

UUID of the Lookup Table.

​
lookupTableRevisionId
string
required

UUID of the Lookup Table Revision.

Query Parameters

​
limit
integer<int32>
default:2000

The maximum number of Data items to return. Defaults to 2000. You can set this to return fewer items if required.

If you expect the Revision to contain more than 2000 Data items, you can use the Trigger Downlad URL Job to download the Lookup Table Revision Data.

​
additional
string[]

Comma separated list of additional fields. For example, you can use additional=lookupKey to get the lookup key returned for each Data item. You can then use a lookup key for the Get/Upsert/Delete data entry endpoints in this section.

Response

Returns the LookupTableRevisionData

Response containing data for a Lookup Table Revision

​
items
object[]
required

The Lookup Table Revision Data.

Maximum array length: 2000
​
dtCreated
string<date-time>

The DateTime when the Lookup Table Revision Data was created.

​
dtLastModified
string<date-time>

The DateTime when the Lookup Table Revision Data was last modified.

​
createdBy
string

The id of the user who created the Lookup Table Revision Data.

​
lastModifiedBy
string

The id of the user who last modified the Lookup Table Revision Data.

​
version
integer<int64>

The version of the Lookup Table Revision Data.