I am working for Integrating with /hcmRestApi/resources/11.13.18.05/workers/{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.
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.
"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 👉 https://drive.google.com/file/d/1jjdqdAu4N68HmjUkTLE3nK-qLehV4AQn/view?usp=sharing
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.
Hi Kabir,
ReplyDeleteI am working for Integrating with /hcmRestApi/resources/11.13.18.05/workers/{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": "example.oracle@example.com",
"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/11.13.18.05/workers/0002000TEST012345",
"name": "workers",
"kind": "item",
"properties": {
"changeIndicator": " 0002000TEST012345"
},
{......}
{.....}
]
"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 :
DeleteURL to access the screenshot 👉 https://drive.google.com/file/d/1jjdqdAu4N68HmjUkTLE3nK-qLehV4AQn/view?usp=sharing
Hi kabir,
ReplyDeleteI 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.
with this much info, its difficult to provide solution
DeleteCould you upload one post for read the File XML and write the same file in CSV format
ReplyDeletewhile sending email notification can we add multiple CC receipient
ReplyDeleteyou can add multiple email ids in TO section of email notification
DeleteHow do I get the workersUniqID using powershell
ReplyDeleteplease check below article link. It might help you.
DeleteArticle Link 👉 https://www.oicbasics.com/2022/03/worker-rest-api-for-oracle-hcm-cloud.html