MsSQL Sub Module Backend

SELECT

EndPoin:

http://localhost:8001/mssql/api/querytool/read/

Method:

POST

Body:

{
  "sql": "SELECT * FROM d_transaksi..t_schedule",
  "params": [],
  "server": "server1",
  "skip": 0,
  "take": 100
}
or
{
  "sql": "SELECT * FROM d_transaksi..t_schedule WHERE FC_SONO in ('FOP:25080454') AND FC_APPROVE = ?",
  "params": ["N"],
  "server": "server1",
  "skip": 0,
  "take": 50
}

INSERT

EndPoin:

http://localhost:8001/mssql/api/querytool/create/

Method:

POST

Body:

{
  "sql": "INSERT INTO d_transaksi..t_schedule (FC_SONO, FC_APPROVE, FD_DATE) VALUES ('FOP:25080454', 'Y', '2025-10-01')",
  "params": [],
  "server": "server1"
}
or
{
  "sql": "INSERT INTO d_transaksi..t_schedule (FC_SONO, FC_APPROVE, FD_DATE) VALUES (?, ?, ?)",
  "params": ["FOP:25080454", "N", "2025-10-20"],
  "server": "server1"
}

UPDATE

EndPoin:

http://localhost:8001/mssql/api/querytool/update/

Method:

PUT

Body:

{
  "sql": "UPDATE d_transaksi..t_coba SET user_name='update' WHERE user_id = ?",
  "params": [4],
  "server": "server1"
}

Optional, tidak mengembalikan nilai Primary Key

{
  "sql": "UPDATE d_transaksi..t_coba SET user_name='update' WHERE user_id = 4",
  "params": [],
  "server": "server1"
}

DELETE

EndPoin:

http://localhost:8001/mssql/api/querytool/delete/

Method:

DELETE

Body:

{
  "sql": "DELETE FROM d_transaksi..t_coba WHERE user_id = ?",
  "params": [4],
  "server": "server1"
}

Optional, tidak mengembalikan nilai Primary Key

{
  "sql": "DELETE FROM d_transaksi..t_coba WHERE user_id = 4",
  "params": [],
  "server": "server1"
}