Created on 03-29-2020 09:50 PM - last edited on 03-29-2020 10:59 PM by VidyaSargur
I am facing an issue - in PutSQL
I am sending a date value from XML-JSON->oracle table.
EvaluateJSOn ->RouteAttributes->AttributeJson->ConvertJsontoSQL -> UpdateAttrubites->PutSQL is my flow.
But it is failing always with
Created 03-30-2020 03:32 AM
I resolved the issue(${sql.args.1.value:toDate("yyyy-MM-dd"):toNumber()}).. But I dont understand why we need toNumber() here. Any body have answer to this ?
Created 03-30-2020 03:32 AM
I resolved the issue(${sql.args.1.value:toDate("yyyy-MM-dd"):toNumber()}).. But I dont understand why we need toNumber() here. Any body have answer to this ?
Created 03-30-2020 05:59 AM
@MPraveen Hello friend!
I dont your sql schema but the error is wanting the real time version of the data (without the /).
Glad you were able to solve it. Accept your own answer and get a solution credit!!
Created 03-30-2020 07:51 PM
Thanks Steven