SELECT JSON_ARRAYAGG
( DISTINCT JSON_OBJECT
( 'myFirstVariable' , `myTable`.`myFirstVariable`
, 'mySecondVariable , `myTable`.`mySecondVariable`
) 'JSON_ARRAYAGG'
)
FROM ........
;
BODY—x-www-form-urlencoded does NOT work. just use ordinary params (far left column) instead:
http://192.168.100.225:3030/knex-generic-raw?firstParam=myFirstParam&secondParam=mYSecondParam