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.
Input:
https://<SERVER_URL>/rest1/ws/rest/service/v2/rate/sheet?source="Primavera Cloud"
Output (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
}
Output (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
}
Output (Other):
{
"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
}
Error 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 Tuesday, July 1, 2025