Dynamic Payload in Assign Message

[praviningawale]

I have an Assign message as which has payload. This AM then calls target endpoint.

Payload is set in AM, where data is retrieved using a query. The where clause in the query is dynamic and changes as per the queryparam we pass to the API endpoint.

For example, if I pass queryparam as 'emplid' then the where clause in the query in the payload should be 'WHERE EMPLID = '{request.queryparam.emplid}''

if I pass queryparam as 'FIRST_NAME' then the where clause in the query in the payload should be 'WHERE FIRST_NAME= '{request.queryparam.firstname}''

So the where clause must be dynamic based on queryparam.

For now, if I have ten queryparams then, I have to write ten different AM and each AM has to called based in some condition.

Is there a way where I can make it more generic and dynamic. Below is my AM

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<AssignMessage continueOnError="false" enabled="true" name="AM-GetEmplID">
    <DisplayName>AM-GetEmplID</DisplayName>
    <Properties/>
    <Set>
        <Headers>
            <Header name="Authorization">Bearer {WDAccess_token}</Header>
        </Headers>
        <Payload contentType="application/json">
                {
    "query" : "SELECT ASOFDATE, EMPLID, EMPL_RCD, NAME_PREFIX, FIRST_NAME, LAST_NAME cds_WD_MMC_ActiveEE_TBL WHERE EMPLID = '{request.queryparam.emplid}'"
    }
        </Payload>
    </Set>
    <IgnoreUnresolvedVariables>true</IgnoreUnresolvedVariables>
    <AssignTo type="request" createNew="false" transport="http"/>
</AssignMessage>