Friday, April 10, 2020

How to update/reset User profile password in bulk mode using Rest API webservice in Oracle HCM Cloud environment


I am using Postman and Rest API webservice to update/reset the User Profile password.

Step 1 : Run the below SQL to get the USER_GUID for the Users :
             SELECT USERNAME, USER_GUID
             FROM PER_USERS
             WHERE USERNAME IN
             (<pass Username details with comma seperated values within double quotes>)

Step 2 : Open Postman

Step 3 : Select the Action as "POST" from the Action dropdown.

Step 4 : pass the URL as below :
             https://<pass your oracle cloud url>/hcmRestApi/scim/Bulk

Step 5 : In the Authorization tab, select "Basic Authorization" and pass the Username
             and Password details.

Step 6 : In the Header tab, add the below parameter :
              Content-Type = application/json

Step 7 : Now in the Body tab pass the details as below format as Request Payload:
 
        {
    "Operations":
     [
   {
    "method":"PATCH",
    "path":"/Users/<Enter GUID for your first User>",
    "bulkId":"clientBulkId1",
    "data":{
      "schemas":[
        "urn:scim:schemas:core:2.0:User"
           ],
      "password": "<Enter the password value here>"
     }
   },
   {
    "method":"PATCH",
    "path":"/Users/<Enter GUID for your second User>",
    "bulkId":"clientBulkId1",
    "data":{
      "schemas":[
        "urn:scim:schemas:core:2.0:User"
           ],
      "password": "<Enter the password value here>"
     }
   }
   ,{
    <pass json value set structure accordingly for other Users>
   }
      ]
 }

Step 8 : Check the status of the Response. If the status is 200 Ok then the update is successful.

No comments:

Post a Comment

How to get rid of "Exception during RestAction" error from Employee Self Service functionality while submitting Absence

 After RedWood is being applied, while navigating to Add Absence functionality under Me tab, if it is throwing an Rest error, then follow th...