PowerServer 2022 R3 Help
Parameterizing static values in SQLs

Find the static value in the Select request body. You shall get it in the "parameters" node.

Select a value in the list of parameters, right click and select "Replace with Parameter" -> "Create new parameter".

Enter the parameter name.

Repeat step 2 to 3 until all values are parameterized

In the example script below, the Select request has been parameterized with the parameters <customerID> and <NotName>:

web_custom_request("SelectWithParm", 
        "URL=http://172.16.9.79:5099/api/ServerApi/SelectWithParm", 
        "Method=POST", 
        "Resource=0", 
        "RecContentType=application/json", 
        "Referer=", 
        "Snapshot=t77.inf", 
        "Mode=HTTP", 
        "EncType=application/json;charset=UTF-8", 
        "Body={\"header\":[\"2.0\",11,\"psapi4loadrunner_cloud\",\"Psapi4loadrunner_cloud\",\"<gs_SessionID>"
        "\",\"<gs_TransactionID>\",\"sqlca\"],\"content\":{\"modulename\":\"\",\"sqlid\":\"sqlHandle_01_DAB1222B\",\"parameters\":[[\"name\",2,<customerID>],[\"name\",8,\"<NotName>\"]]}}", 
        LAST);