Retrieve Equipment Actual Locations By Code
  • 26 Sep 2024
  • 2 Minutes to read
  • Dark
    Light

Retrieve Equipment Actual Locations By Code

  • Dark
    Light

Article summary

Get
/em-rest-api/rest/1/emactloc

Query Standards

Finder

Following row finders are available for data filtering and optimizing request performance.

  • Find by Code
  • Find by Date
  • By UUID

Select by Code

Recommended finder parameters. Refer to Query Parameters for example.

ParameterDescriptionSample
locationCodeLocation code001-CHI

Select by Date

This is an optional finder for querying Equipment Actual Locations by Audit Date.

ParameterDescriptionSample
AuditDateCreate or update date time filter2022-12-20

By UUID

This is an optional finder for querying a specific Equipment Actual Location by row ID.

ParameterDescriptionSample
/VUUIDThe VUuid attribute is the Unique row ID/em-rest-api/rest/1/emactloc/001-CHI
Security
HTTP
Type basic

Basic authentication

Query parameters
finder
string
ExamplefindByCode; locationCode=001-CHI
limit
integer
Example500
offset
integer
Example0
totalResults
boolean
Exampletrue
orderBy
string
ExampleEmalActuallocCode:desc
Responses
200

OK

Headers
Content-Type
string
Exampleapplication/vnd.oracle.adf.resourcecollection+json
example-0

Successful Response - Finder - findByDate

{
  "items": [
    {
      "EmalActuallocCode": "032017",
      "EmalName": "HWY 47",
      "EmalSname": null,
      "EmalDefaultCompCode": "HIKUU",
      "EmalDefaultCompName": "CMiC Construction Canada Ltd.",
      "EmalDefaultJobCode": "032017",
      "EmalDefaultJobName": null,
      "EmalDefaultPhsCode": null,
      "EmalDefaultPhsName": null,
      "EmalDefaultCatCode": null,
      "EmalDefaultCatName": null,
      "EmalDefaultCustCode": "CITYOFED",
      "EmalDefaultCustName": "City of Edmonton",
      "EmalStatusFlag": "Y",
      "EmalRetireFlag": "N",
      "EmalExcldTargetUtilCalc": "N",
      "EmalIuCreateDate": "2017-02-06T04:31:27Z",
      "EmalIuUpdateDate": null,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emactloc/032017",
          "name": "emactloc",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emactloc/032017",
          "name": "emactloc",
          "kind": "item"
        }
      ]
    },
    {
      "EmalActuallocCode": "042016",
      "EmalName": "HWY 407",
      "EmalSname": null,
      "EmalDefaultCompCode": "001",
      "EmalDefaultCompName": "CMiC Construction Inc",
      "EmalDefaultJobCode": "042016",
      "EmalDefaultJobName": "CMiC Cloud Prod (July)",
      "EmalDefaultPhsCode": null,
      "EmalDefaultPhsName": null,
      "EmalDefaultCatCode": null,
      "EmalDefaultCatName": null,
      "EmalDefaultCustCode": "46001",
      "EmalDefaultCustName": "City of La Verne",
      "EmalStatusFlag": "Y",
      "EmalRetireFlag": "N",
      "EmalExcldTargetUtilCalc": "N",
      "EmalIuCreateDate": "2016-10-27T02:47:20Z",
      "EmalIuUpdateDate": null,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emactloc/042016",
          "name": "emactloc",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emactloc/042016",
          "name": "emactloc",
          "kind": "item"
        }
      ]
    },
    {
      "EmalActuallocCode": "2016-05-01T12:00:00Z",
      "EmalName": "33 Wells Road",
      "EmalSname": null,
      "EmalDefaultCompCode": "001",
      "EmalDefaultCompName": "CMiC Construction Inc",
      "EmalDefaultJobCode": "2016-05-01T12:00:00Z",
      "EmalDefaultJobName": "32 Wells Street",
      "EmalDefaultPhsCode": null,
      "EmalDefaultPhsName": null,
      "EmalDefaultCatCode": null,
      "EmalDefaultCatName": null,
      "EmalDefaultCustCode": "0588-11-01T12:00:00Z",
      "EmalDefaultCustName": "Minto Group Ltd",
      "EmalStatusFlag": "Y",
      "EmalRetireFlag": "N",
      "EmalExcldTargetUtilCalc": "N",
      "EmalIuCreateDate": "2016-08-18T01:06:56Z",
      "EmalIuUpdateDate": "2016-10-27T02:47:31Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emactloc/05-2016",
          "name": "emactloc",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emactloc/05-2016",
          "name": "emactloc",
          "kind": "item"
        }
      ]
    },
    {
      "EmalActuallocCode": "051188",
      "EmalName": "58 Bankers Hill",
      "EmalSname": null,
      "EmalDefaultCompCode": "001",
      "EmalDefaultCompName": "CMiC Construction Inc",
      "EmalDefaultJobCode": "051188",
      "EmalDefaultJobName": "58 Bankers Hill Renovations",
      "EmalDefaultPhsCode": null,
      "EmalDefaultPhsName": null,
      "EmalDefaultCatCode": null,
      "EmalDefaultCatName": null,
      "EmalDefaultCustCode": "0588-11-01T12:00:00Z",
      "EmalDefaultCustName": "Minto Group Ltd",
      "EmalStatusFlag": "Y",
      "EmalRetireFlag": "N",
      "EmalExcldTargetUtilCalc": "N",
      "EmalIuCreateDate": "2016-10-26T05:36:41Z",
      "EmalIuUpdateDate": null,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emactloc/051188",
          "name": "emactloc",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emactloc/051188",
          "name": "emactloc",
          "kind": "item"
        }
      ]
    },
    {
      "EmalActuallocCode": "072016",
      "EmalName": "Hilton Hotel",
      "EmalSname": null,
      "EmalDefaultCompCode": "002",
      "EmalDefaultCompName": "Fresenius Medical Care",
      "EmalDefaultJobCode": "072016",
      "EmalDefaultJobName": null,
      "EmalDefaultPhsCode": null,
      "EmalDefaultPhsName": null,
      "EmalDefaultCatCode": null,
      "EmalDefaultCatName": null,
      "EmalDefaultCustCode": "HHO001",
      "EmalDefaultCustName": "Hilton Hotels Inc.",
      "EmalStatusFlag": "Y",
      "EmalRetireFlag": "N",
      "EmalExcldTargetUtilCalc": "N",
      "EmalIuCreateDate": "2016-10-26T05:36:41Z",
      "EmalIuUpdateDate": null,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emactloc/072016",
          "name": "emactloc",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emactloc/072016",
          "name": "emactloc",
          "kind": "item"
        }
      ]
    }
  ],
  "count": 5,
  "hasMore": true,
  "limit": 5,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emactloc",
      "name": "emactloc",
      "kind": "collection"
    }
  ]
}
example-1

Successful Response - Finder - findByCode

{
  "items": [
    {
      "EmalActuallocCode": "001-CHI",
      "EmalName": "Chicago Yard / Warehouse",
      "EmalSname": null,
      "EmalDefaultCompCode": "001",
      "EmalDefaultCompName": "CMiC Construction Inc",
      "EmalDefaultJobCode": "2016-05-01T12:00:00Z",
      "EmalDefaultJobName": "32 Wells Street",
      "EmalDefaultPhsCode": "00750",
      "EmalDefaultPhsName": "Permits",
      "EmalDefaultCatCode": "O",
      "EmalDefaultCatName": "Other",
      "EmalDefaultCustCode": "0588-11-01T12:00:00Z",
      "EmalDefaultCustName": "Minto Group Ltd",
      "EmalStatusFlag": "Y",
      "EmalRetireFlag": "N",
      "EmalExcldTargetUtilCalc": "N",
      "EmalIuCreateDate": "2023-08-18T02:29:34Z",
      "EmalIuUpdateDate": null,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emactloc/001-CHI",
          "name": "emactloc",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emactloc/001-CHI",
          "name": "emactloc",
          "kind": "item"
        }
      ]
    }
  ],
  "count": 1,
  "hasMore": false,
  "limit": 5,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emactloc",
      "name": "emactloc",
      "kind": "collection"
    }
  ]
}
object