Get Rate Card Templates

get

/rest/v16/pricingSetup/rateCardTemplates

Use this endpoint to retrieve all rate card templates.

Request

Query Parameters
  • When this parameter is provided, the specified children are included in the resource payload (instead of just a link). More than one child can be specified using comma as a separator. Example: ?expand=columns. To include all the children and grandchildren, specify the value of this query parameter to be "all".
  • This parameter filters the resource attributes. Only the specified attributes are returned, which means that if no attributes are specified, all attributes are returned.
  • Used as a predefined finder to search the collection.
    Format: ?finder=<finderName>;<VarName>=<variableValue>
    The following are the available finder names and corresponding finder variables:
    • findByKeyword: Find pricing matrix templates using name,VarName and description.
      Finder Variable:
      • keyword;string: The search text. The character '%' if present will be treated as a wild card otherwise, the default is 'contains' search
  • This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
  • Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
  • The resource item payload will be filtered in order to contain only data (no links section, for example).
  • This parameter orders a resource collection based on the specified attributes. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "ASC" or "DESC". Specify "ASC" for ascending and "DESC" for descending. The default value is "ASC". For example, ?orderby=field1:ASC,field2:DESC.
  • Filter (a 'where' clause) to restrict the items returned in the collection. By default, no filtering is applied.
  • The resource collection representation will include the total row count when "?totalResults=true", otherwise the count is not included. The default value is "false".
Back to Top

Response

Supported Media Types

200 Response

Success
Body ()
Root Schema : PricingResourceCollection_PricingMatrixTemplate
Type: object
Show Source
  • Title: Count
    Read Only: true
    The number of resource instances returned in the current range.
  • Created By
    Title: Created By
    Read Only: true
    The details of the user who created the record.
  • Title: HasMore
    Read Only: true
    Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
  • items
  • Last Modified By
    Title: Last Modified By
    Read Only: true
    The details of the user who modified the record.
  • Title: Limit
    Read Only: true
    The actual paging size used by the server.
  • Links
  • Title: OffSet
    Read Only: true
    The offset value used in the current page.
  • Title: Total Results
    Read Only: true
    Captures the total count of the resource instances, which not only includes the instances in the current range, but all instances on the server that satisfy the request.
Nested Schema : Created By
Title: Created By
Read Only: true
The details of the user who created the record.
Match All
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : Last Modified By
Title: Last Modified By
Read Only: true
The details of the user who modified the record.
Match All
Show Source
Nested Schema : UserDetails
Type: object
Show Source
Nested Schema : PricingMatrixTemplate
Type: object
Show Source
Nested Schema : Allowed Charge Definitions
Type: array
Title: Allowed Charge Definitions
The list of charge definitions that this pricing matrix will apply to.
Show Source
Nested Schema : Pricing Matrix Template Columns
Title: Pricing Matrix Template Columns
Read Only: true
List of columns for the Pricing Matrix Template. Ignored if rate card template.
Match All
Show Source
Nested Schema : Created By
Title: Created By
Read Only: true
The details of the user who created the record.
Match All
Show Source
Nested Schema : Last Modified By
Title: Last Modified By
Read Only: true
The details of the user who modified the record.
Match All
Show Source
Nested Schema : PricingMenuItem
Type: object
Show Source
Nested Schema : PricingResourceCollection_PricingMatrixTemplateColumn
Type: object
Show Source
  • Title: Count
    Read Only: true
    The number of resource instances returned in the current range.
  • Created By
    Title: Created By
    Read Only: true
    The details of the user who created the record.
  • Title: HasMore
    Read Only: true
    Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
  • items
  • Last Modified By
    Title: Last Modified By
    Read Only: true
    The details of the user who modified the record.
  • Title: Limit
    Read Only: true
    The actual paging size used by the server.
  • Links
  • Title: OffSet
    Read Only: true
    The offset value used in the current page.
  • Title: Total Results
    Read Only: true
    Captures the total count of the resource instances, which not only includes the instances in the current range, but all instances on the server that satisfy the request.
Nested Schema : Created By
Title: Created By
Read Only: true
The details of the user who created the record.
Match All
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : Last Modified By
Title: Last Modified By
Read Only: true
The details of the user who modified the record.
Match All
Show Source
Nested Schema : PricingMatrixTemplateColumn
Type: object
Show Source
Nested Schema : Created By
Title: Created By
Read Only: true
The details of the user who created the record.
Match All
Show Source
Nested Schema : Last Modified By
Title: Last Modified By
Read Only: true
The details of the user who modified the record.
Match All
Show Source
Back to Top

Examples

The following example shows how to retrieve all Rate Card Templates by submitting a GET request to the REST resource using cURL. For more information about cURL, see Use cURL.

curl -X GET -i -H "Authorization: Basic dXNlcm5hbWU6cGFzc3dvcmQg" -H "Accept: application/json"
https://sitename.oracle.com/rest/v16/pricingSetup/rateCardTemplates

Response Body Sample

{
  "items": [{
      "name": "Data Usage Rate Card Template",
      "variableName": "dataUsageRateCardTemplate",
      "active": true,
      "description": "Data rate per market (North America, Latin America, EMEA, APAC)",
      "rateCardCount": 1,
      "dateAdded": "2023-08-25T13:56:51Z",
      "dateModified": "2023-08-25T13:56:51Z",
      "links": [{
          "rel": "self",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/rateCardTemplates/dataUsageRateCardTemplate"
        }, {
          "rel": "parent",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/rateCardTemplates"
        }, {
          "rel": "child",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/rateCardTemplates/dataUsageRateCardTemplate/columns"
        }
      ]
    }, {
      "name": "Volume Rate Card Template",
      "variableName": "volumeRateCardTemplate",
      "active": true,
      "description": "Access rates based on usage (per Gb)",
      "rateCardCount": 1,
      "dateAdded": "2023-08-25T13:41:37Z",
      "dateModified": "2023-08-25T13:41:37Z",
      "links": [{
          "rel": "self",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/rateCardTemplates/volumeRateCardTemplate"
        }, {
          "rel": "parent",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/rateCardTemplates"
        }, {
          "rel": "child",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/rateCardTemplates/volumeRateCardTemplate/columns"
        }
      ]
    }, {
      "name": "Tech Support Rate Card Template",
      "variableName": "techSupportRateCardTemplate",
      "active": true,
      "description": "",
      "rateCardCount": 1,
      "dateAdded": "2023-08-25T14:00:02Z",
      "dateModified": "2023-08-25T14:00:02Z",
      "links": [{
          "rel": "self",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/rateCardTemplates/techSupportRateCardTemplate"
        }, {
          "rel": "parent",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/rateCardTemplates"
        }, {
          "rel": "child",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/rateCardTemplates/techSupportRateCardTemplate/columns"
        }
      ]
    }, {
      "name": "New Rate Card Template",
      "variableName": "newRateCardTemplate_c",
      "active": true,
      "description": "New rate card template description.",
      "rateCardCount": 0,
      "dateAdded": "2023-09-26T20:25:03Z",
      "dateModified": "2023-09-26T20:25:03Z",
      "links": [{
          "rel": "self",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/rateCardTemplates/newRateCardTemplate_c"
        }, {
          "rel": "parent",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/rateCardTemplates"
        }, {
          "rel": "child",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/rateCardTemplates/newRateCardTemplate_c/columns"
        }
      ]
    }
  ],
  "offset": 0,
  "limit": 1000,
  "count": 4,
  "hasMore": false,
  "links": [{
      "rel": "canonical",
      "href": "https://sitename.oracle.com/rest/v16/pricingSetup/rateCardTemplates"
    }, {
      "rel": "self",
      "href": "https://sitename.oracle.com/rest/v16/pricingSetup/rateCardTemplates?offset=0&limit=1000"
    }
  ]
}
Back to Top