I am trying to load data using a rest connector to an end point. I get the error message: Connector reply error: Unexpected lexem 'From' at (62,5). Expected '<end of file>'. Check SELECT STATEMENT syntax with documentation. I have not seen this before and could not find much information regarding this message in the community or help documentation. A sample version of my code is below. If more information is required, please let me know! TIA!
I have another rest connection that grabs my access token (then used for vAccessToken) which is working. I think the issue stems from the layers in the API, maybe more specifically ProcResult?
LIB CONNECT TO 'REST_generic_get ';
"My field name 1",
"My field name 2"
FROM JSON (wrap on) "root"
FROM JSON (wrap on) "ProcResult"
FROM JSON (wrap on) "Table"
WITH CONNECTION (
HTTPHEADER "Authorization" "Bearer $(vAccessToken)",
QUERY "fromDate" "08/01/2010",
QUERY "toDate" "08/02/2010",