Get Resources from the Master Rate Sheet
GET /ws/rest/service/v2/rate/sheet/resources?source={sourceApplication}
Purpose
Retrieve the list of resources synced from a source application based on the source provided in the request.
Prerequisites
The user has access to fetch the data.
Request Format
https://<SERVER_URL>/rest1/ws/rest/service/v2/rate/sheet?source="Primavera Cloud"
Sample Response For Oracle Primavera Cloud
{
"data": [
{
"resourceStatus": "Active",
"unitsPerTime": 1.0,
"resourceCurrency": "USD1",
"resourceCode": "RateDemo5",
"workspaceCode": "NON_PROD2",
"rates": [
{
"ratesBreakdown": [
{
"rateType": null,
"costType": null,
"id": 901,
"resourceStandardRate": 100.1234567890124
},
{
"rateType": null,
"costType": null,
"id": 902,
"resourceStandardRate": 120.0
}
],
"resourceEffectiveDate": "2020-02-03T00:00:00",
"id": 902
},
{
"ratesBreakdown": [
{
"rateType": null,
"costType": null,
"id": 903,
"resourceStandardRate": 50.0
},
{
"rateType": null,
"costType": null,
"id": 904,
"resourceStandardRate": 100.0
}
],
"resourceEffectiveDate": "2020-02-05T00:00:00",
"id": 903
}
],
"resourceName": "RateDemo5",
"id": 111,
"parentResourceCode": "Parent",
"resourceType": "Labor"
},
{
"resourceStatus": "Active",
"unitsPerTime": 1.0,
"resourceCurrency": "USD",
"resourceCode": "30May12",
"workspaceCode": "NON_PROD2",
"rates": [
{
"ratesBreakdown": [
{
"rateType": "Direct",
"costType": "Food",
"id": 1040,
"resourceStandardRate": 100.0
},
{
"rateType": "Indirect",
"costType": "Standard",
"id": 1041,
"resourceStandardRate": 20.12
}
],
"resourceEffectiveDate": "2024-02-03T00:00:00",
"id": 984
},
{
"ratesBreakdown": [
{
"rateType": "Direct",
"costType": "Food",
"id": 1042,
"resourceStandardRate": 500.98
},
{
"rateType": "Indirect",
"costType": "Standard",
"id": 1043,
"resourceStandardRate": 60.23
}
],
"resourceEffectiveDate": "2025-02-05T00:00:00",
"id": 985
}
],
"resourceName": "30May12update2222",
"id": 183,
"parentResourceCode": "Parent",
"resourceType": "Nonlabor"
}
],
"message": [
"success"
],
"status": 200,
"rest_audit_id": 1929
}
Sample Response For P6
{
"data": [
{
"resourceStatus": "Active",
"unitsPerTime": 1.0,
"resourceCurrency": "USD",
"resourceCode": "Child4",
"rates": [
{
"resourceEffectiveDate": "2020-02-03T00:00:00",
"id": 1020
}
],
"resourceName": "Child4",
"id": 211,
"parentResourceCode": "",
"resourceType": "Labor"
},
{
"resourceStatus": "Active",
"unitsPerTime": 100.0,
"resourceCurrency": "INR",
"resourceCode": "P6C2",
"rates": [
{
"ratesBreakdown": [
{
"rateType": "Direct",
"costType": "Food",
"id": 1238,
"resourceStandardRate": 30.5
},
{
"rateType": "Indirect",
"costType": "Food",
"id": 1239,
"resourceStandardRate": 100.0
}
],
"resourceEffectiveDate": "2020-02-03T00:00:00",
"id": 1093
}
],
"resourceName": "C2update",
"id": 229,
"parentResourceCode": "p6res",
"resourceType": "Nonlabor"
}
],
"message": [
"success"
],
"status": 200,
"rest_audit_id": 1930
}
Sample Response For Other Applications
{
"data": [
{
"resourceStatus": "Active",
"unitsPerTime": 1.0,
"resourceCurrency": "USD",
"resourceCode": "res2",
"rates": [
{
"ratesBreakdown": [
{
"rateType": "Direct",
"costType": "Standard",
"id": 12,
"resourceStandardRate": 33.8
}
],
"resourceEffectiveDate": "2022-06-01T00:00:00",
"id": 12
},
{
"ratesBreakdown": [
{
"rateType": "Direct",
"costType": "Standard",
"id": 27,
"resourceStandardRate": 40.0
}
],
"resourceEffectiveDate": "2022-05-27T00:00:00",
"id": 27
},
{
"ratesBreakdown": [
{
"rateType": "Direct",
"costType": "Standard",
"id": 30,
"resourceStandardRate": 10.0
}
],
"resourceEffectiveDate": "2022-04-29T00:00:00",
"id": 30
},
{
"ratesBreakdown": [
{
"rateType": "Direct",
"costType": "Food",
"id": 10,
"resourceStandardRate": 10.0
}
],
"resourceEffectiveDate": "2022-06-23T00:00:00",
"id": 10
},
{
"ratesBreakdown": [
{
"rateType": "Direct",
"costType": "Standard",
"id": 11,
"resourceStandardRate": 5.0
}
],
"resourceEffectiveDate": "2022-06-21T00:00:00",
"id": 11
},
{
"ratesBreakdown": [
{
"rateType": "Direct",
"costType": "Standard",
"id": 87,
"resourceStandardRate": 50.0
}
],
"resourceEffectiveDate": "2020-04-01T00:00:00",
"id": 87
},
{
"ratesBreakdown": [
{
"rateType": "Direct",
"costType": "Standard",
"id": 90,
"resourceStandardRate": 20.0
}
],
"resourceEffectiveDate": "2019-10-31T00:00:00",
"id": 90
}
],
"resourceName": "Resource2",
"id": 9,
"parentResourceCode": "",
"resourceType": "Labor"
},
{
"resourceStatus": "Active",
"unitsPerTime": 1.0,
"resourceCurrency": "USD",
"resourceCode": "NonLabor",
"rates": [],
"resourceName": "NonLabor",
"id": 223,
"parentResourceCode": "res2",
"resourceType": "Nonlabor"
}
],
"message": [
"success"
],
"status": 200,
"rest_audit_id": 1931
}
Sample Failed Response
{
"data": [],
"message": ["Invalid value was found in a field: 'source'. Allowed values: [Primavera Cloud]"],
"status": 12008,
"rest_audit_id": 4633
}
Related Topics
Create and Update Resources in the Master Rate Sheet
Create and Update Roles in the Master Rate Sheet
Get Roles from the Master Rate Sheet
Last Published Wednesday, April 9, 2025