[
https://issues.jboss.org/browse/TEIIDDES-2284?page=com.atlassian.jira.plu...
]
Ted Jones commented on TEIIDDES-2284:
-------------------------------------
The correct transformation is: BEGIN
DECLARE STRING VARIABLES.qp =
QUERYSTRING('http://www.google.com/complete/search';, ViewModel_1.test1.q AS q,
ViewModel_1.test1."output" AS "output");
SELECT A.data AS data FROM (EXEC SourceModel_1.invokeHttp('GET', null,
VARIABLES.qp, 'TRUE')) AS f, XMLTABLE('/toplevel/CompleteSuggestion'
PASSING XMLPARSE(DOCUMENT f.result) COLUMNS data string PATH 'suggestion/@data')
AS A;
END
Preview works when a CP is assigned to the source model.
Preview Error for REST Web Service Source
-----------------------------------------
Key: TEIIDDES-2284
URL:
https://issues.jboss.org/browse/TEIIDDES-2284
Project: Teiid Designer
Issue Type: Bug
Components: Data Preview
Affects Versions: 8.6
Reporter: Ted Jones
Assignee: Ted Jones
Priority: Blocker
Fix For: 8.6.1, 9.0
When previewing a procedure that invokes a REST web service source, I get the following
error:
select * from ( exec
"ViewModel"."google"('toolbar','reciever') ) AS X_X
org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote
org.teiid.core.TeiidProcessingException: TEIID30152 Failed to evaluate XQuery expression;
Please check the query and correct errors in syntax or usage.
However, if I add the view procedure to a VDB and deploy, I am able to execute without
error.
GOOGLE SEARCH URL:
http://www.google.com/complete/search
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)