Q&A BY TAG 'XML'
XML Data Source : Character reference "" is an invalid XML character.
answered
24-04-2019 18:09:45 -0400
Hi, I'm using v7.0 20181011. Attemting to create a base view from an XML data source, I'm getting the error "Unable to obtain the data structure: com.denodo.util.exceptions.InternalErrorException: Character reference " " is an invalid XML character....
Answers:
1
How to get result in array or registered ?
answered
02-04-2019 10:31:13 -0400
SELECT xpath ( cast ('xml', '<?xml version="1.0" encoding="ISO-8859-1"?> <a> <b>Hello</b> <b>World</b> </a>' ) , '/a/b/text()', false) as xpath_results FROM Dual(); The result is xpath_results HelloWorld ...
Answers:
2
How to schedule a job to fetch data from an external source (tool) using XML API?
answered
19-02-2019 07:22:45 -0500
Can you please step down the process on how to schedule an XML API to fetch data from an external source(tool)?
Answers:
1
Automic scheduler automation XML XML Data Source Denodo Scheduler 7.0 API
How to do error handling on accessing data sources that we do not control + Different REST Web Service formats don't seem to return the same information?
answered
10-01-2019 10:31:48 -0500
Hello! There are two problems, that my team was wondering if there were answers to. The first problem: There are several data sources that we have no control over, and therefore can't tell if those services are live or not. My team was wondering how w...
Answers:
2
denodo platform XML Denodo Testing Tool REST Webservice json HTML Error Handling
In my Derived view there is one field message. it's return value in XML. How do I get some field from there?
answered
08-11-2018 06:32:44 -0500
In my message field I got ><ns2:ResponseDateTime>2018-09-20T14:10:26.607-04:00</ns2:ResponseDateTime>><ServiceName>test</ServiceName><ServiceRequestDateTime>2018-09-20T14:10:26.508-04:00</ServiceRequestDateTime>...
Answers:
3
XML Data in BLOB into Columns
answered
01-10-2018 11:00:24 -0400
A base view created from Oracle has a column of BLOB Data Type. This column has XML stored. How can I extract data out from XML. How Can I convert the XML data from BLOB field into Adject columns in the Derived View?
Answers:
3
Issue type casting BLOB to XML Data Columns
answered
01-10-2018 10:45:55 -0400
Hi , I am trying to extract the XML data from Blob column in oracle database. I was refreing the below solution to convert blob to XML data. but still I am getting the error. ‘cast($1 as $0) -> Cast to xml not supported in Oracle’. XML Data in B...
Answers:
1
xpath function is not working as expected in Denodo
answered
26-09-2018 19:20:25 -0400
SELECT xpath ( cast ('xml' , '<Entries> <ChargebackClaim DebitMemoRefNum="61186134101">123 </ChargebackClaim> </Entries>' ) , '/Entries/ChargebackClaim/@DebitMemoRefNum/text()', true) as xpath_results FROM Dual(); I am getting...
Answers:
2
source file info
answered
07-08-2018 15:14:16 -0400
Hi, I found some interesting predefined stored procedures here, but as far as I've seen, they don't deliver output I'm looking for: https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_sto...
Answers:
3
Unable to import XML file .
answered
30-11-2017 07:29:36 -0500
We have multiple data present in multiple files (xml,csv,json,excel) in multiple linux servers . When we tried to connect using available option under connections -> Data route ->configurations (FTP/SFTP/FTPS) using URL ftp://server_ip:port/dir/f...
Answers:
1