REST API Error When The Query Is Passed In Encoded Format (Doc ID 2445052.1)

Last updated on APRIL 09, 2023

Applies to:

Symptoms

On : 11.13.18.05.0 version, Data Load

When attempting to Perform a GET with REST API,
the following error occurs.

ERROR
-----------------------
Response: {responseString=URL request parameter fields with value ...is not valid., responseStatus=400}


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. GET on URL
{envURL}/hcmRestApi/resources/latest/emps?q=PersonId%3D<PersonID>&fields=%3BPers
onNumber%2CPersonId%2CWorkEmail%2CFirstName%2CMiddleName%2CDisplayName%2CPreviousLastName%
2CLastName%2CWorkPhoneNumber%2CSalutation%2CHonors%2CCorrespondenceLanguage%2CHireDate%2CN
ameSuffix%2CPreferredName%2CWorkPhoneCountryCode%2CWorkPhoneAreaCode%2CWorkPhoneNumber%2C
WorkPhoneExtension%2CWorkFaxCountryCode%2CWorkFaxAreaCode%2CWorkFaxNumber%2CWorkFaxExtensi
on%2CWorkMobilePhoneCountryCode%2CWorkMobilePhoneAreaCode%2CWorkMobilePhoneNumber%2CWorkMo
bilePhoneExtension%2CLegalEntityId%2CCountry%2CTerminationDate%2CEffectiveStartDate%2CUserName%2C
CreationDate%2CLastUpdateDate%3Bassignments%3AAssignmentName%2CPersonTypeId%2CBusinessUnitId%2
CLocationId%2CJobId%2CGradeId%2CDepartmentId%2CProjectedStartDate%2CWorkerCategory%2CAssignment
Category%2CWorkingAtHome%2CWorkingAsManager%2CFrequency%2CStartTime%2CEndTime%2CActionCode
%2CActionReasonCode%2CAssignmentStatus%2CWorkTaxAddressId%2CAssignmentId%2CEffectiveStartDate%2
CEffectiveEndDate%2CPositionId%2CTermsEffectiveStartDate%2CManagerAssignmentId%2CManagerId%2CAssig
nmentNumber%2CPeriodOfServiceId%2COriginalHireDate%2CPrimaryAssignmentFlag%2CAssignmentProjectedEn
dDate%2CActualTerminationDate%2CLegalEntityId%2CPrimaryWorkRelationFlag%2CPrimaryWorkTermsFlag%2C
CreationDate%2CLastUpdateDate%3Bassignments.assignmentDFF%3AseHrbp%2CseHrbp_Display%3BpersonDFF
%3AconnectivityType%2C%2CconnectivityType_Display&onlyData=true

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.