The following get request fails at Salesforce query connector, what is causing this;
GET request: http://host/customer?startDate=20221222133500
Salesforce query connector :
SELECT .......... FROM customer__c WHERE CreatedDate>=:startDate
Parameter transformation in SF query connector:
{ "startDate" : attributes.queryParams.startDate as LocalDateTime {format: "yyyyMMddHHmmss"} as String {format: "yyyy-MM-dd'T'HH:mm"}
}
Error message from salesforce query:
CreatedDate>=2022-12-22T13:35:00.00
^
ERROR at Row:1:Column:196
line 1:196 no viable alternative at character '<EOF>'
I tried following expression;
"startDateTime" : (attributes.queryParams.startDateTime as Date{format : "yyyy-MM-dd"}++"T00:00:00.000+0000") as String {format: "yyyy-MM-dd'T'HH:mm:ss.SSSZ"}
Which generates correct startDateTime format and show up in debugger as follows:
startDateTime=2023-01-05T00:00:00.000+0000
which works fine and also doesn't show any error in salesforce parameter expression.
