You must sign in to ask a question. If you do not have an account, you can register here

How to get result in array or registered ?
answered 26-06-2019 02:06:07 -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: 3


XML Data Source : Character reference "&#xB" 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

XML XML Data Source

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

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&gt...

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

XML XML Data Source derive

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

Excel XML Delimited Files

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

Excel XML CSV XML Data Source JSON

File Generation
answered 22-11-2017 08:09:14 -0500

I need to publish a Flat and XML file to Unix server. I have already created views as required. Is it possible to create a job to publish data in an given external location ?

Answers: 1

XML Delimited Files