Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

get certain text from a response

edited Jan 2, 2022 2:40PM in Integration 10 comments

following url response generate the encrypted personunquid (below in bold in href)

/hcmRestApi/resources/11.13.18.05/workers/?q=PersonId=100000003309035

I tried with XSLT function substring-after(href,"workers/") but getting error

Error

{An error occurs while processing the XPath expression; the expression is ......................}

Response

{

    "items": [

        {

            "PersonId": 100000021519603,

            "PersonNumber": "66431",

            "CorrespondenceLanguage": null,

            "BloodType": null,

            "DateOfBirth": "1988-08-04",

            "DateOfDeath": null,

            "CountryOfBirth": "SA",

            "RegionOfBirth": null,

            "TownOfBirth": null,

            "ApplicantNumber": null,

            "CreatedBy": "FUSION_APPS_HCM_ESS_LOADER_APPID",

            "CreationDate": "2020-07-14T09:57:23.720+00:00",

            "LastUpdatedBy": "FUSION_APPS_HCM_ESS_APPID",

            "LastUpdateDate": "2020-09-29T14:23:59.067+00:00",

            "links": [

                {

                    "rel": "self",

                    "href": "https://ecjddev-test.fa.em2.oraclecloud.com:443/hcmRestApi/resources/11.13.18.05/workers/00020000000EACED0005770800005AF311C29CF30000004AACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000017E1815F80078

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!