Get
/em-rest-api/rest/1/emeqprates
Query Standards
Finder
Following row finders are available for data filtering and optimizing request performance.
- Select by Equipment Rates
- Select by Audit Date
- By UUID
Select by Equipment Rates
Recommended finder parameters. Refer to Query Parameters for example.
| Parameter | Description | Sample |
|---|---|---|
| CompCode | Company Code | 001 |
| TranCode | Transaction Code | ACHR |
| StartDate | Start Date | 2016-01-01 |
| EndDate | End Date | 2018-02-21 |
Select by Audit Date
This is an optional finder for querying equipment rates by Audit Date.
| Parameter | Description | Sample |
|---|---|---|
| AuditDate | create or update date time filter | 2022-12-20 |
By UUID
This is an optional finder for querying a specific equipment rate by row ID.
| Parameter | Description | Sample |
|---|---|---|
| /VUUID | The VUuid attribute is the Unique row ID | /em-rest-api/rest/1/emeqprate/AAAXkTAAIAAJJsLAAj |
Security
HTTP
Type basic
Basic authentication
Query parameters
finder
string
ExampleselectEqpRates;CompCode=001,TranCode=ACHR,StartDate=2016-01-01,EndDate=2018-12-31
limit
integer
Example500
offset
integer
Example0
totalResults
boolean
Exampletrue
orderBy
string
ExampleEmetEqpCode:desc
Responses
200
OK
Headers
Content-Type
string
Exampleapplication/vnd.oracle.adf.resourcecollection+json
example-0
Successful Response - Finder - selectEqpRates
{
"error": "{\n \"items\": [\n {\n \"DiscriminatorCode\": null,\n \"EmetActiveRateFlag\": \"Y\",\n \"EmetAddChargeAmt\": 0,\n \"EmetAmountType\": \"C\",\n \"EmetCompCode\": \"001\",\n \"EmetDailyChargeAmt\": 900,\n \"EmetEndDate\": \"2018-12-31T00:00:00-05:00\",\n \"EmetEqpCode\": \"1001.01\",\n \"EmetEqpName\": \"CAT Excavator 336\",\n \"EmetEqpOraseq\": 26311,\n \"EmetEtOraseq\": 66843553,\n \"EmetHrlyChargeAmt\": 120,\n \"EmetIuCreateDate\": \"2017-02-01T10:26:25-05:00\",\n \"EmetIuCreateUser\": \"ADWAIT\",\n \"EmetIuUpdateDate\": null,\n \"EmetIuUpdateUser\": null,\n \"EmetMonthlyChargeAmt\": 5500,\n \"EmetParentType\": \"EMEQP\",\n \"EmetRowid\": \"AAAXkTAAIAAJJsMAAC\",\n \"EmetStartDate\": \"2016-01-01T00:00:00-05:00\",\n \"EmetTenantId\": \"VF389BTEQP11127\",\n \"EmetTrancodeCode\": \"ACHR\",\n \"EmetTrancodeName\": \"Auto Charge\",\n \"EmetTrancodeOraseq\": 26142,\n \"EmetWeeklyChargeAmt\": 1700,\n \"EmetWmCode\": \"$\",\n \"EmetWmName\": \"Dollars\",\n \"links\": [\n {\n \"rel\": \"self\",\n \"href\": \"http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsMAAC\",\n \"name\": \"emeqprates\",\n \"kind\": \"item\"\n },\n {\n \"rel\": \"canonical\",\n \"href\": \"http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsMAAC\",\n \"name\": \"emeqprates\",\n \"kind\": \"item\"\n }\n ]\n },\n {\n \"DiscriminatorCode\": null,\n \"EmetActiveRateFlag\": \"Y\",\n \"EmetAddChargeAmt\": 0,\n \"EmetAmountType\": \"C\",\n \"EmetCompCode\": \"001\",\n \"EmetDailyChargeAmt\": 700,\n \"EmetEndDate\": \"2018-12-31T00:00:00-05:00\",\n \"EmetEqpCode\": \"055033\",\n \"EmetEqpName\": \"LULL 19617 FORKLIFT\",\n \"EmetEqpOraseq\": 26321,\n \"EmetEtOraseq\": 66843513,\n \"EmetHrlyChargeAmt\": 80,\n \"EmetIuCreateDate\": \"2017-02-01T10:26:21-05:00\",\n \"EmetIuCreateUser\": \"ADWAIT\",\n \"EmetIuUpdateDate\": null,\n \"EmetIuUpdateUser\": null,\n \"EmetMonthlyChargeAmt\": 4500,\n \"EmetParentType\": \"EMEQP\",\n \"EmetRowid\": \"AAAXkTAAIAAJJsLAAe\",\n \"EmetStartDate\": \"2016-01-01T00:00:00-05:00\",\n \"EmetTenantId\": \"VF389BTEQP11127\",\n \"EmetTrancodeCode\": \"ACHR\",\n \"EmetTrancodeName\": \"Auto Charge\",\n \"EmetTrancodeOraseq\": 26142,\n \"EmetWeeklyChargeAmt\": 1500,\n \"EmetWmCode\": \"$\",\n \"EmetWmName\": \"Dollars\",\n \"links\": [\n {\n \"rel\": \"self\",\n \"href\": \"http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsLAAe\",\n \"name\": \"emeqprates\",\n \"kind\": \"item\"\n },\n {\n \"rel\": \"canonical\",\n \"href\": \"http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsLAAe\",\n \"name\": \"emeqprates\",\n \"kind\": \"item\"\n }\n ]\n },\n {\n \"DiscriminatorCode\": null,\n \"EmetActiveRateFlag\": \"Y\",\n \"EmetAddChargeAmt\": 0,\n \"EmetAmountType\": \"C\",\n \"EmetCompCode\": \"001\",\n \"EmetDailyCh\nargeAmt\": 600,\n \"EmetEndDate\": \"2018-12-31T00:00:00-05:00\",\n \"EmetEqpCode\": \"100020\",\n \"EmetEqpName\": \"Backhoe\",\n \"EmetEqpOraseq\": 26344,\n \"EmetEtOraseq\": 66843589,\n \"EmetHrlyChargeAmt\": 70,\n \"EmetIuCreateDate\": \"2017-02-01T10:26:25-05:00\",\n \"EmetIuCreateUser\": \"ADWAIT\",\n \"EmetIuUpdateDate\": null,\n \"EmetIuUpdateUser\": null,\n \"EmetMonthlyChargeAmt\": 4200,\n \"EmetParentType\": \"EMEQP\",\n \"EmetRowid\": \"AAAXkTAAIAAJJsMAAR\",\n \"EmetStartDate\": \"2016-01-01T00:00:00-05:00\",\n \"EmetTenantId\": \"VF389BTEQP11127\",\n \"EmetTrancodeCode\": \"ACHR\",\n \"EmetTrancodeName\": \"Auto Charge\",\n \"EmetTrancodeOraseq\": 26142,\n \"EmetWeeklyChargeAmt\": 1600,\n \"EmetWmCode\": \"$\",\n \"EmetWmName\": \"Dollars\",\n \"links\": [\n {\n \"rel\": \"self\",\n \"href\": \"http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsMAAR\",\n \"name\": \"emeqprates\",\n \"kind\": \"item\"\n },\n {\n \"rel\": \"canonical\",\n \"href\": \"http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsMAAR\",\n \"name\": \"emeqprates\",\n \"kind\": \"item\"\n }\n ]\n },\n {\n \"DiscriminatorCode\": null,\n \"EmetActiveRateFlag\": \"Y\",\n \"EmetAddChargeAmt\": 0,\n \"EmetAmountType\": \"C\",\n \"EmetCompCode\": \"001\",\n \"EmetDailyChargeAmt\": 750,\n \"EmetEndDate\": \"2018-12-31T00:00:00-05:00\",\n \"EmetEqpCode\": \"078009\",\n \"EmetEqpName\": \"LOWBOY TAG-A-LONG WITH TRUCK\",\n \"EmetEqpOraseq\": 225545,\n \"EmetEtOraseq\": 66843565,\n \"EmetHrlyChargeAmt\": 80,\n \"EmetIuCreateDate\": \"2017-02-01T10:26:25-05:00\",\n \"EmetIuCreateUser\": \"ADWAIT\",\n \"EmetIuUpdateDate\": null,\n \"EmetIuUpdateUser\": null,\n \"EmetMonthlyChargeAmt\": 4800,\n \"EmetParentType\": \"EMEQP\",\n \"EmetRowid\": \"AAAXkTAAIAAJJsMAAH\",\n \"EmetStartDate\": \"2016-01-01T00:00:00-05:00\",\n \"EmetTenantId\": \"VF389BTEQP11127\",\n \"EmetTrancodeCode\": \"ACHR\",\n \"EmetTrancodeName\": \"Auto Charge\",\n \"EmetTrancodeOraseq\": 26142,\n \"EmetWeeklyChargeAmt\": 1550,\n \"EmetWmCode\": \"$\",\n \"EmetWmName\": \"Dollars\",\n \"links\": [\n {\n \"rel\": \"self\",\n \"href\": \"http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsMAAH\",\n \"name\": \"emeqprates\",\n \"kind\": \"item\"\n },\n {\n \"rel\": \"canonical\",\n \"href\": \"http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsMAAH\",\n \"name\": \"emeqprates\",\n \"kind\": \"item\"\n }\n ]\n },\n {\n \"DiscriminatorCode\": null,\n \"EmetActiveRateFlag\": \"Y\",\n \"EmetAddChargeAmt\": 0,\n \"EmetAmountType\": \"C\",\n \"EmetCompCode\": \"001\",\n \"EmetDailyChargeAmt\": 650,\n \"EmetEndDate\": \"2018-12-31T00:00:00-05:00\",\n \"EmetEqpCode\": \"100050\",\n \"EmetEqpName\": \"BACKHOE BUCKET - 12\\\"\",\n \"EmetEqpOraseq\": 225565,\n \"EmetEtOraseq\": 66843541,\n \"EmetHrlyChargeAmt\":\n 75,\n \"EmetIuCreateDate\": \"2017-02-01T10:26:25-05:00\",\n \"EmetIuCreateUser\": \"ADWAIT\",\n \"EmetIuUpdateDate\": null,\n \"EmetIuUpdateUser\": null,\n \"EmetMonthlyChargeAmt\": 4500,\n \"EmetParentType\": \"EMEQP\",\n \"EmetRowid\": \"AAAXkTAAIAAJJsLAAo\",\n \"EmetStartDate\": \"2016-01-01T00:00:00-05:00\",\n \"EmetTenantId\": \"VF389BTEQP11127\",\n \"EmetTrancodeCode\": \"ACHR\",\n \"EmetTrancodeName\": \"Auto Charge\",\n \"EmetTrancodeOraseq\": 26142,\n \"EmetWeeklyChargeAmt\": 1700,\n \"EmetWmCode\": \"$\",\n \"EmetWmName\": \"Dollars\",\n \"links\": [\n {\n \"rel\": \"self\",\n \"href\": \"http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsLAAo\",\n \"name\": \"emeqprates\",\n \"kind\": \"item\"\n },\n {\n \"rel\": \"canonical\",\n \"href\": \"http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsLAAo\",\n \"name\": \"emeqprates\",\n \"kind\": \"item\"\n }\n ]\n },\n {\n \"DiscriminatorCode\": null,\n \"EmetActiveRateFlag\": \"Y\",\n \"EmetAddChargeAmt\": 0,\n \"EmetAmountType\": \"C\",\n \"EmetCompCode\": \"001\",\n \"EmetDailyChargeAmt\": 500,\n \"EmetEndDate\": \"2018-12-31T00:00:00-05:00\",\n \"EmetEqpCode\": \"013065\",\n \"EmetEqpName\": \"SUPER SAWZALL\",\n \"EmetEqpOraseq\": 225521,\n \"EmetEtOraseq\": 66842550,\n \"EmetHrlyChargeAmt\": 50,\n \"EmetIuCreateDate\": \"2017-02-01T10:14:26-05:00\",\n \"EmetIuCreateUser\": \"ADWAIT\",\n \"EmetIuUpdateDate\": null,\n \"EmetIuUpdateUser\": null,\n \"EmetMonthlyChargeAmt\": 3800,\n \"EmetParentType\": \"EMEQP\",\n \"EmetRowid\": \"AAAXkTAAIAAJJsLAAZ\",\n \"EmetStartDate\": \"2016-01-01T00:00:00-05:00\",\n \"EmetTenantId\": \"VF389BTEQP11127\",\n \"EmetTrancodeCode\": \"ACHR\",\n \"EmetTrancodeName\": \"Auto Charge\",\n \"EmetTrancodeOraseq\": 26142,\n \"EmetWeeklyChargeAmt\": 1350,\n \"EmetWmCode\": \"$\",\n \"EmetWmName\": \"Dollars\",\n \"links\": [\n {\n \"rel\": \"self\",\n \"href\": \"http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsLAAZ\",\n \"name\": \"emeqprates\",\n \"kind\": \"item\"\n },\n {\n \"rel\": \"canonical\",\n \"href\": \"http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsLAAZ\",\n \"name\": \"emeqprates\",\n \"kind\": \"item\"\n }\n ]\n },\n {\n \"DiscriminatorCode\": null,\n \"EmetActiveRateFlag\": \"Y\",\n \"EmetAddChargeAmt\": 0,\n \"EmetAmountType\": \"C\",\n \"EmetCompCode\": \"001\",\n \"EmetDailyChargeAmt\": 800,\n \"EmetEndDate\": \"2018-12-31T00:00:00-05:00\",\n \"EmetEqpCode\": \"078006\",\n \"EmetEqpName\": \"GOOSENECK TRAILER WITH TRACTOR\",\n \"EmetEqpOraseq\": 225541,\n \"EmetEtOraseq\": 66843577,\n \"EmetHrlyChargeAmt\": 100,\n \"EmetIuCreateDate\": \"2017-02-01T10:26:25-05:00\",\n \"EmetIuCreateUser\": \"ADWAIT\",\n \"EmetIuUpdateDate\": null,\n \"EmetIuUpdateUser\": null,\n \"EmetMonthlyChargeAmt\": 5500,\n \"EmetParentType\": \"EMEQ\nP\",\n \"EmetRowid\": \"AAAXkTAAIAAJJsMAAM\",\n \"EmetStartDate\": \"2016-01-01T00:00:00-05:00\",\n \"EmetTenantId\": \"VF389BTEQP11127\",\n \"EmetTrancodeCode\": \"ACHR\",\n \"EmetTrancodeName\": \"Auto Charge\",\n \"EmetTrancodeOraseq\": 26142,\n \"EmetWeeklyChargeAmt\": 1800,\n \"EmetWmCode\": \"$\",\n \"EmetWmName\": \"Dollars\",\n \"links\": [\n {\n \"rel\": \"self\",\n \"href\": \"http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsMAAM\",\n \"name\": \"emeqprates\",\n \"kind\": \"item\"\n },\n {\n \"rel\": \"canonical\",\n \"href\": \"http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsMAAM\",\n \"name\": \"emeqprates\",\n \"kind\": \"item\"\n }\n ]\n }\n ],\n \"count\": 7,\n \"hasMore\": false,\n \"limit\": 50,\n \"offset\": 0,\n \"links\": [\n {\n \"rel\": \"self\",\n \"href\": \"http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates\",\n \"name\": \"emeqprates\",\n \"kind\": \"collection\"\n }\n ]\n}"
}example-1
Successful Response - Finder - selectByAuditDate
{
"items": [
{
"DiscriminatorCode": null,
"EmetActiveRateFlag": "Y",
"EmetAddChargeAmt": 0,
"EmetAmountType": "C",
"EmetCompCode": "001",
"EmetDailyChargeAmt": 150,
"EmetEndDate": "2020-12-31T00:00:00-05:00",
"EmetEqpCode": "100024",
"EmetEqpName": "FORD F250 PICKUP",
"EmetEqpOraseq": 26332,
"EmetEtOraseq": 66843529,
"EmetHrlyChargeAmt": 80,
"EmetIuCreateDate": "2017-02-01T10:26:25-05:00",
"EmetIuCreateUser": "ADWAIT",
"EmetIuUpdateDate": "2020-08-11T13:05:09-04:00",
"EmetIuUpdateUser": "CANDICE",
"EmetMonthlyChargeAmt": 2000,
"EmetParentType": "EMEQP",
"EmetRowid": "AAAXkTAAIAAJJsLAAj",
"EmetStartDate": "2016-01-01T00:00:00-05:00",
"EmetTenantId": "VF389BTEQP11127",
"EmetTrancodeCode": "ACHR",
"EmetTrancodeName": "Auto Charge",
"EmetTrancodeOraseq": 26142,
"EmetWeeklyChargeAmt": 350,
"EmetWmCode": "$",
"EmetWmName": "Dollars",
"links": [
{
"rel": "self",
"href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsLAAj",
"name": "emeqprates",
"kind": "item"
},
{
"rel": "canonical",
"href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsLAAj",
"name": "emeqprates",
"kind": "item"
}
]
},
{
"DiscriminatorCode": null,
"EmetActiveRateFlag": "Y",
"EmetAddChargeAmt": 0,
"EmetAmountType": "C",
"EmetCompCode": "001",
"EmetDailyChargeAmt": 800,
"EmetEndDate": "2018-12-31T00:00:00-05:00",
"EmetEqpCode": "100133",
"EmetEqpName": "Grove Rough Terrain Crane",
"EmetEqpOraseq": 26858,
"EmetEtOraseq": 130764242,
"EmetHrlyChargeAmt": 100,
"EmetIuCreateDate": "2018-01-03T08:21:12-05:00",
"EmetIuCreateUser": "MARKB",
"EmetIuUpdateDate": "2018-01-03T08:31:52-05:00",
"EmetIuUpdateUser": "MARKB",
"EmetMonthlyChargeAmt": 5000,
"EmetParentType": "EMEQP",
"EmetRowid": "AAAXkTAAIAAJJgvAAE",
"EmetStartDate": "2017-01-01T00:00:00-05:00",
"EmetTenantId": "VF389BTEQP11127",
"EmetTrancodeCode": "ACHR",
"EmetTrancodeName": "Auto Charge",
"EmetTrancodeOraseq": 26142,
"EmetWeeklyChargeAmt": 1700,
"EmetWmCode": "$",
"EmetWmName": "Dollars",
"links": [
{
"rel": "self",
"href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJgvAAE",
"name": "emeqprates",
"kind": "item"
},
{
"rel": "canonical",
"href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJgvAAE",
"name": "emeqprates",
"kind": "item"
}
]
},
{
"DiscriminatorCode": null,
"EmetActiveRateFlag": "Y",
"EmetAddChargeAmt": 0,
"EmetAmountType": "C",
"EmetCompCode": "001",
"EmetDailyChargeAmt": 900,
"EmetEndDate": "2017-12-31T00:00:00-05:00",
"EmetEqpCode": "055033",
"EmetEqpName": "LULL 19617 FORKLIFT",
"EmetEqpOraseq": 26321,
"EmetEtOraseq": 87651096,
"EmetHrlyChargeAmt": 100,
"EmetIuCreateDate": "2017-06-16T08:37:13-04:00",
"EmetIuCreateUser": "CANDICE",
"EmetIuUpdateDate": null,
"EmetIuUpdateUser": null,
"EmetMonthlyChargeAmt": 5000,
"EmetParentType": "EMEQP",
"EmetRowid": "AAAXkTAAIAAJJuQAAF",
"EmetStartDate": "2016-01-01T00:00:00-05:00",
"EmetTenantId": "VF389BTEQP11127",
"EmetTrancodeCode": "WORK",
"EmetTrancodeName": "Work Time",
"EmetTrancodeOraseq": 26153,
"EmetWeeklyChargeAmt": 1800,
"EmetWmCode": "$",
"EmetWmName": "Dollars",
"links": [
{
"rel": "self",
"href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJuQAAF",
"name": "emeqprates",
"kind": "item"
},
{
"rel": "canonical",
"href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJuQAAF",
"name": "emeqprates",
"kind": "item"
}
]
}
],
"count": 3,
"hasMore": false,
"limit": 50,
"offset": 0,
"links": [
{
"rel": "self",
"href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates",
"name": "emeqprates",
"kind": "collection"
}
]
}object