Shong,
After enabling some more verbose logging, I noticed why it is not working. When I use tFixFlowInput --> tRESTClient --> tLogRow, I am able to post. The post is working because the payload has a bracket as the leading and trailing characters. Below is what prints out from the log. I confirmed that my data is appearing in my DB.
Payload:
However, when I use tFileInputJSON --> tXMLMap --> tRESTClient --> tLogRow OR tWriteJSONField --> tRESTClient --> tLogRow, the payload ends up without the brackets like below and I get an error 400 (bad data).
Payload: {"number":39980,"partNumber":"020116-ESY1","partRev":"B","orgCode":21,"orgName":"Scomo","qtyValues":"1500,1000,700","dueDate":"11-05-2016","completedDate":"","deliveryDate":"12-07-2020","expedite":true,"sourceRequired":false,"longTermAgreement":true}.
I can't seem to get it to include the brackets. They do exist in my source data file but they get stripped out for some reason. I need to use FileInput or tWriteJSON for my project so how do you put leading/trailing brackets into the payload?