uwa

Universal Web Api

Sample file is attached

Endpoint: /api/v1/ApplyCommit

select query with parameter

{
  "SF_NAME": "sqldb1-sql1",
  "SF_RETN": "GET",
  "PARAM_LIST": [
                    {
                      "TEXT": "@@PROJ_ID",
                      "VALUE": "1"
                    }
                ]
}

select query without parameter

{
  "SF_NAME": "sqldb1-sql3",
  "SF_RETN": "GET",
  "PARAM_LIST": []
}

insert query with parameter

{
  "SF_NAME": "sqldb1-sql2",
  "SF_RETN": "POST",
  "PARAM_LIST": [
                   {
                      "TEXT": "@@ID",
                      "VALUE": "1"
                   },
                   {
                      "TEXT": "@@ROLE_NAME",
                      "VALUE": "Admin User"
                   }
                ]
}