I am using CURL via the terminal to make an API call to my Lucee CFML server running on port 52897 like so:
First, I retrieve all existing data from my table via a GET command, as follows:
$ curl -X GET localhost:52897/api/carriers
{“data”:{“ROWCOUNT”:7,“COLUMNS”:[“CAR_CARRIER_CD”,“CAR_CARRIER_NM”,“CAR_TRANSPORT_MODE”,“CAR_AWB_PREFIX”],“DATA”:{“CAR_CARRIER_CD”:[“3BX”,“AWT”,“CMA”,“CX”,“MAE”,“SQ”,“TG”],“CAR_CARRIER_NM”:[“3B EXPRESS”,“AWT RAIL TRANSPORTATION”,“CMA-CGM”,“CATHAY PACIFIC”,“MAERSK LINE”,“SINGAPORE AIRLINES”,“THAI AIRWAYS”],“CAR_TRANSPORT_MODE”:[“T”,“R”,“S”,“A”,“S”,“A”,“A”],“CAR_AWB_PREFIX”:[“”,“”,“”,“160”,“”,“618”,“217”]}},“error”:false,“messages”:}
Then, I attempt to POST the new record like this, in order to insert a new record in my database:
$ curl -X POST localhost:52897/api/carriers \
-H ‘Content-Type: application/json’ \
-d ‘{“CAR_CARRIER_CD”:“AA”,“CAR_CARRIER_NM”:“TEST”,“CAR_TRANSPORT_MODE”:“S”,“CAR_AWB_PREFIX”:“”}’
However, as shown in the attached screens (before POST, after POST), I cannot insert that new record probably because the JSON format used above on line 3 is incorrect.
The API was successfully tested with TESTBOX, meaning I can GET, POST and DELETE, but I am a bit confused by the default JSON format that comes with the API output by Coldbox.
Based on the sample presented above, could anybody guide me as to what should be the appropriate JSON format in order to successfully insert the record? I need this proper format in order to implement this API between Vue.js on the client and Lucee on the server, on record save.
