Cc Aggr Ocapi Request DMO

This DMO aggregates OCAPI request metrics by site, API name, resource, version, client, status code, and method.

Object API Name: CcAggrOcapiRequest_std__dlm
Category: Unassigned
Availability: Available in 260 and later versions
Primary Key Field: SiteId

• SiteId has a FOREIGNKEY relationship with the Cc Dim Site DMO Id field.

• ApiName
• ApiResource
• ApiVersion
• cdp_sys_record_currency
• ClientId
• DataSourceId
• DataSourceObjectId
• InternalOrganizationId
• KQ_SiteId
• Method
• NumberOfRequests
• NumberOfRequestsBucket1
• NumberOfRequestsBucket10
• NumberOfRequestsBucket11
• NumberOfRequestsBucket2
• NumberOfRequestsBucket3
• NumberOfRequestsBucket4
• NumberOfRequestsBucket5
• NumberOfRequestsBucket6
• NumberOfRequestsBucket7
• NumberOfRequestsBucket8
• NumberOfRequestsBucket9
• RequestDate
• ResponseTime
• SiteId
• StatusCode

• Field API Name: ApiName__c
• Data Type: TEXT
• Description: Name of the OCAPI API.

• Field API Name: ApiResource__c
• Data Type: TEXT
• Description: Specific OCAPI resource accessed.

• Field API Name: ApiVersion__c
• Data Type: TEXT
• Description: Version of the OCAPI API.

• Field API Name: cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: ClientId__c
• Data Type: TEXT
• Description: Client identifier making the request.

• Field API Name: DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: KQ_SiteId__c
• Data Type: TEXT
• Description: Key Qualifier system field for SiteId

• Field API Name: Method__c
• Data Type: TEXT
• Description: HTTP method used (e.g., GET, POST).

• Field API Name: NumberOfRequests__c
• Data Type: DOUBLE
• Description: Total number of requests.

• Field API Name: NumberOfRequestsBucket1__c
• Data Type: DOUBLE
• Description: Number of requests in response time bucket 1.

• Field API Name: NumberOfRequestsBucket10__c
• Data Type: DOUBLE
• Description: Number of requests in response time bucket 10.

• Field API Name: NumberOfRequestsBucket11__c
• Data Type: DOUBLE
• Description: Number of requests in response time bucket 11.

• Field API Name: NumberOfRequestsBucket2__c
• Data Type: DOUBLE
• Description: Number of requests in response time bucket 2.

• Field API Name: NumberOfRequestsBucket3__c
• Data Type: DOUBLE
• Description: Number of requests in response time bucket 3.

• Field API Name: NumberOfRequestsBucket4__c
• Data Type: DOUBLE
• Description: Number of requests in response time bucket 4.

• Field API Name: NumberOfRequestsBucket5__c
• Data Type: DOUBLE
• Description: Number of requests in response time bucket 5.

• Field API Name: NumberOfRequestsBucket6__c
• Data Type: DOUBLE
• Description: Number of requests in response time bucket 6.

• Field API Name: NumberOfRequestsBucket7__c
• Data Type: DOUBLE
• Description: Number of requests in response time bucket 7.

• Field API Name: NumberOfRequestsBucket8__c
• Data Type: DOUBLE
• Description: Number of requests in response time bucket 8.

• Field API Name: NumberOfRequestsBucket9__c
• Data Type: DOUBLE
• Description: Number of requests in response time bucket 9.

• Field API Name: RequestDate__c
• Data Type: DATETIME
• Description: Datetime of the request.

• Field API Name: ResponseTime__c
• Data Type: DOUBLE
• Description: Average response time for the requests.

• Field API Name: SiteId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_site.

• Field API Name: StatusCode__c
• Data Type: DOUBLE
• Description: HTTP status code of the response.