POST RESTRequest Error (TALEND ESB)

[DTARCHOUN1648771289]

Im actually trying to send Data with the POST request (using POSTMANfor testing with the body) but the data is saved with NULL values and the id always = 0 (ID in MySQL DataBase with Auto-Increment option) Help pls, ty there is all pictures:

[gjeremy1617088143]

Hi, have you checked auto commit in the advanced settings of your tDBOutput ?

Send me love and kudos

[DTARCHOUN1648771289]

this is it

[gjeremy1617088143]

Sorry it was only when you have a tBDConnection, could you try to test in a testjob if you can write in your db with a tDBoutput with the same parameter.

eg tFixedFlowInput --> main link -->tDBOutput.

[gjeremy1617088143]

could you put a tLogRow to you addorderlink to see what you have in input ?

also i think your schema in trestrequest is wrong you have to set the schema of the response like

string or body of type document and then parse it with tExtactJsonfield

https://help.talend.com/r/en-US/7.2/esb-rest/trestrequest-trestclient-tlogrow-using-rest-service-to-accept-http-post-requests-and-send-responses-standard-component-esb-this