Oracle Fusion HCM endpoint reference

Data Load Data Sets REST API

Get all data sets

GET https://your-pod.oraclecloud.com/hcmRestApi/resources/11.13.18.05/dataLoadDataSets

Everything on this page is extracted from Oracle's official OpenAPI specification for Fusion Cloud HCM: 18 queryable q fields, and 3 child resources. Unsure how q works? See the Oracle HCM API guide.

Supported operations

GET /dataLoadDataSets
GET /dataLoadDataSets/{id}

Queryable q fields (18)

Only these fields can appear in a q filter expression on /dataLoadDataSets. Filtering on any other field returns 400 Bad Request.

Example q request

GET /hcmRestApi/resources/11.13.18.05/dataLoadDataSets?q=ContentId='<value>'&onlyData=true&limit=25
Field Type Operators
ContentId string = !=
DataSetId integer = !=
DataSetName string = !=
DataSetStatusCode string = !=
DataSetStatusMeaning string = !=
ImportStatusCode string = !=
ImportStatusMeaning string = !=
IntegrationTypeCode string = !=
IntegrationTypeMeaning string = !=
LoadStatusCode string = !=
LoadStatusMeaning string = !=
RequestId integer = !=
SourceTypeCode string = !=
SourceTypeMeaning string = !=
SpreadsheetTemplateCode string = !=
SpreadsheetTemplateName string = !=
TransferStatusCode string = !=
TransferStatusMeaning string = !=

Child resources (3)

Each child is reachable at /dataLoadDataSets/{id}/child/<name> and most can also be inlined with expand.

businessObjectsmessagesprocesses

Response fields (46)

Top-level attributes returned for each row. Use fields= to request a subset and shrink the payload.

ContentIdCreatedByCreationDateDataSetIdDataSetNameDataSetStatusCodeDataSetStatusMeaningFailedLinesFileContentIdFailedLinesFileEncryptionKeyFailedLinesFileEncryptionTypeFileLineImportErrorCountFileLineImportSuccessCountFileLineTotalCountFileSizeImportPercentageCompleteImportStatusCodeImportStatusMeaningImportSuccessPercentageIntegrationTypeCodeIntegrationTypeMeaningLastUpdateDateLastUpdatedByLoadPercentageCompleteLoadStatusCodeLoadStatusMeaningLoadSuccessPercentageObjectLoadErrorCountObjectRollbackErrorCountObjectSuccessCountObjectTotalCountObjectUnprocessedCountProtectedFlagRequestIdReviewSourceTypeCodeSourceTypeMeaningSpreadsheetMessageSpreadsheetTemplateCodeSpreadsheetTemplateNameSpreadsheetTemplateUserTypeCodeSpreadsheetTemplateUserTypeMeaningTransferStatusCodeTransferStatusMeaningbusinessObjectsmessagesprocesses

Build this query visually in OPAL

OPAL bundles this endpoint — and 59,000+ more — fully searchable offline, with a visual Q Builder and Finder Builder that only offer the fields listed above, so your filter can't 400. Download free · see features.

Related reference & reading