Oracle Cloud Infrastructure Documentation
Try Free Tier

One Subscription Ratecard Functions

Package: DBMS_CLOUD_OCI_OS_RATECARD

LIST_RATE_CARDS Function

List API that returns all ratecards for given Subscription Id and Account ID (if provided) and for a particular date range

Syntax

FUNCTION list_rate_cards (
  subscription_id varchar2,
  compartment_id varchar2,
  time_from timestamp with time zone DEFAULT NULL,
  time_to timestamp with time zone DEFAULT NULL,
  part_number varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  sort_order varchar2 DEFAULT NULL,
  sort_by varchar2 DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_os_ratecard_list_rate_cards_response_t;

Parameters

Parameter Description

subscription_id

(required) Line level Subscription Id

compartment_id

(required) The OCID of the root compartment.

time_from

(optional) This param is used to get the rate card(s) whose effective start date starts on or after a particular date

time_to

(optional) This param is used to get the rate card(s) whose effective end date ends on or before a particular date

part_number

(optional) This param is used to get the rate card(s) filterd by the partNumber

limit

(optional) The maximum number of items to return in a paginated \"List\" call. Default: (`50`) Example: '500'

page

(optional) The value of the 'opc-next-page' response header from the previous \"List\" call.

sort_order

(optional) The sort order to use, either ascending ('ASC') or descending ('DESC').

Allowed values are: 'ASC', 'DESC'

sort_by

(optional) The field to sort by. You can provide one sort order ('sortOrder').

Allowed values are: 'ORDERNUMBER', 'TIMEINVOICING'

opc_request_id

(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.

region

(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).

endpoint

(optional) The endpoint of the service to call using this function. e.g https://identity.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.

credential_name

(optional) The name of the credential for authenticating with the corresponding cloud native API.

Was this article helpful?