ExtractVariables policy usage

Google Cloud Apigee
1

Target Endpoint:

https://wd2-impl-services1.workday.com/ccx/service/customreport2/XXX9/999999/CR_INT999_MMCWorkerDemographicDetails_AllColleagues?

If I pass below URL directly in IE it works

https://wd2-impl-services1.workday.com/ccx/service/customreport2/XXX9/999999/CR_INT999_MMCWorkerDemographicDetails_AllColleagues?Organizations_by_Type!Organization_Reference_ID=BU_MCO&Employee_ID=123456

However when i create Extract variable policy as below it gives invalid URL error

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

EV-Employee_ID

/org/{Organizations_by_Type!Organization_Reference_ID=BU_MCO}

Employee_ID-{Employee_ID}

request

Apigee URL giving error is as below

https://praviningawale-eval-test.apigee.net/v1/workerdetails/org/Organizations_by_Type!Organization_Reference_ID=BU_MCO?Employee_ID=123456

2

You need to first extract the “Organizations_by_Type!Organization_Reference_ID=BU_MCO?Employee_ID=123456” part from the api url using extract variable policy

https://praviningawale-eval-test.apigee.net/v1/workerdetails/org/Organizations_by_Type!Organization_Reference_ID=BU_MCO?Employee_ID=123456

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

EV-Employee_ID

/org/{Organizations_by_Type}

request

In a javascript or assign message set the target.url

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<AssignMessage async="false" continueOnError="false" enabled="true" name="Assign-Message-1">
    <DisplayName>Assign Message-1</DisplayName>
    <Properties/>
    
    <AssignVariable>
        <Name>target.url</Name>
        <Template>https://wd2-impl-services1.workday.com/ccx/service/customreport2/XXX9/999999/CR_INT999_MMCWorkerDemographicDetails_AllColleagues?{Organizations_by_Type}</Template>
    </AssignVariable>
    <IgnoreUnresolvedVariables>true</IgnoreUnresolvedVariables>
    <AssignTo createNew="false" transport="http" type="request"/>
</AssignMessage><br>

https://wd2-impl-services1.workday.com/ccx/service/customreport2/XXX9/999999/CR_INT999_MMCWorkerDemographicDetails_AllColleagues

The variable I have taken is Organizations_by_Type, you can use any other name.

3 
Below is the steps which I have configured, but this is not working. Am I missing something ?

----------------------------
Assign Message-1
----------------------------
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<AssignMessage async="false" continueOnError="false" enabled="true" name="Assign-Message-1">
    <DisplayName>Assign Message-1</DisplayName>
    <Properties/>
    <AssignVariable>
        <Name>target.url</Name>
        <Template>https://wd2-impl-services1.workday.com/ccx/service/customreport2/XXX9/999999/CR_INT546_MMCWorkerDemographicDetails_AllColleagues?{Organizations_by_Type}</Template>
    </AssignVariable>
    <IgnoreUnresolvedVariables>true</IgnoreUnresolvedVariables>
    <AssignTo createNew="false" transport="http" type="request"/>
</AssignMessage>

--------------------------------
Extract Variable Policy
--------------------------------
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ExtractVariables async="false" continueOnError="false" enabled="true" name="EV-MV-Employee_ID">
    <DisplayName>EV-Employee_ID</DisplayName>
    <URIPath>
        <Pattern>/org/{Organizations_by_Type}</Pattern>
    </URIPath>
    <QueryParam name="Employee_ID">
        <Pattern>Employee_ID-{Employee_ID}</Pattern>
    </QueryParam>
    <Source clearPayload="false">request</Source>
</ExtractVariables>

-------------------------
Target End Point
-------------------------

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<TargetEndpoint name="default">
    <PreFlow name="PreFlow">
        <Request/>
        <Response/>
    </PreFlow>
    <Flows/>
    <PostFlow name="PostFlow">
        <Request/>
        <Response/>
    </PostFlow>
    <HTTPTargetConnection>
        <URL>https://wd2-impl-services1.workday.com/ccx/service/customreport2/XXX9/999999/CR_INT546_MMCWorkerDemographicDetails_AllColleagues</URL>
    </HTTPTargetConnection>
</TargetEndpoint>
4

As per the requirement, it works. With change in requirement, little modification will work.