SELECT *
FROM XMLTABLE('$doc/campaignListData/campaign'
PASSING
XMLPARSE(DOCUMENT SYSTOOLS.HTTPGETCLOB
('http://192.168.200.79:8080/webservices/emarsys/list_email_campaigns/' concat systools.urlencode('D', 'UTF-8') concat '/' concat systools.urlencode('2018-01-01', 'UTF-8') concat '/' concat systools.urlencode('2018-03-01', 'UTF-8'),
'
'))
AS "doc"
COLUMNS
name VARCHAR(50) PATH 'name',
status VARCHAR(1) PATH 'status',
contactlist VARCHAR(100) PATH 'contactlist',
subject VARCHAR(100) ccsid 1208 PATH 'subject',
fromemail VARCHAR(100) PATH 'fromemail',
fromname VARCHAR(100) PATH 'fromname'
) AS WebServiceResult
Bookmarks