You can ask generic question related to Oracle Integration Cloud in below comment section. We will try to answer it.



  1. Hi Kabir,

    I am working for Integrating with /hcmRestApi/resources/{workersUniqID}/child/emails for creating a worker email. So first I was passing the personId to get the worker details and I was trying to get the only value for workersUniqueID from href, but I was not able get the workersUniqueID from href in OIC. Can you please help which function can I use to get the value for wokerUniqueID, and also can you please share the blog if you have it.

    I was using the below expression for getting the workersUniqueID from href.

    expression: substring-after($GetWorkerAll/nssrcmpr:executeResponse/nsmpr9:response-wrapper/nsmpr9:links/nsmpr9:href, '/workers/')

    Can you please find the below response payload and I need to get the highlighted value only in OIC response will map to variable to get the workesUniqueID.

    "PersonId": 1234566789,
    "PersonNumber": "ABC02",
    "CorrespondenceLanguage": null,
    "BloodType": null,
    "DateOfBirth": "1990-01-01",
    "DateOfDeath": null,
    "CountryOfBirth": null,
    "RegionOfBirth": null,
    "TownOfBirth": null,
    "ApplicantNumber": null,
    "CreatedBy": "",
    "CreationDate": "2021-03-19T14:22:41.477+00:00",
    "LastUpdatedBy": "TEST",
    "LastUpdateDate": "2021-03-24T15:30:56.243+00:00",
    "links": [
    "rel": "self",
    "href": "https://:/hcmRestApi/resources/",
    "name": "workers",
    "kind": "item",
    "properties": {
    "changeIndicator": " 0002000TEST012345"


    1. "links": [ ---- > It's repeating element, so you have to use 'for each' first and then use the 'substring-after' function as given in below screenshot :

      URL to access the screenshot 👉

  2. Hi kabir,

    I have tried one basic scenario read the xml and write the file in csv format in target location.

    For that i was used Schedule Orchestration by using FTP i am reading the Files and then created one stage file for writing the CSV format and then from stage file to i am sending the file to FTP location thorugh FTP connection write operation. but in stage write file i am getting error like "Error in fetching payload" Could you please suggest on this.

    1. with this much info, its difficult to provide solution

  3. Could you upload one post for read the File XML and write the same file in CSV format


If you have any doubts, Please let me know.