Error trying to parse null as integer in DV JSONTOXML function
Issue
- Trying to connect to a JSON web service, get an Exception :
WARN [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue107) TEIID30020 Processing exception for request YlXJzLZ6YatD.16 'TEIID10072 Invalid integer format in String: '. Originally TransformationException StringToIntegerTransform.java:43.
Environment
- Red Hat JBoss Data Virtualization (DV) 6.3
- View Transformation for Web Request:
BEGIN
DECLARE STRING VARIABLES.qp = QUERYSTRING('https://myservice', 'BEST' AS mode);
SELECT A.* FROM (EXEC wsPDB.invokeHttp(action => 'POST', request => (('{"uwi":["' || wsPDBquery.getuwi.uwi) || '"],"mode":"ALL"}'), endpoint => VARIABLES.qp, stream => 'TRUE', headers => JSONOBJECT('application/json' AS "Content-Type", CAST(teiid_session_get('token') AS string) AS "x-access-token")))
AS f, XMLTABLE('/response/response' PASSING JSONTOXML('response', f.result) COLUMNS sta_id INTEGER PATH 'sta_id', INTEGER PATH 'sta_test_nb', ) AS A;
END
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Close
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.