You can translate the question and the replies:

Transforming blobs into readable text

I'm trying to pass BLOB field from our database to the REST surface, but it doesn't show in the web interface. In VDP I can see the fields denoted as [BINARY DATA] - 7306 bytes, but in the web interface I don't see the fields at all. I was hoping to be able to convert the BLOBs back to text via denode in order to search through the data. Is this even remotely possible?
BLOB CLOB
user
26-01-2016 11:04:24 -0500
code

1 Answer

Hi! You can check the subsection "HTML representation" under the "Restful Web Service" section of the Virtual DataPort Administration Guide. As you can read there if you are using the HTML output you will be able to access a blob field only if the view has a primary key, and in this case it will do so through a link that will show the value of the field depending on the content type. If the view does not have a primary key then, as you say, it is not possible to request a blob value and the fields will be hidden. You can try to set a primary key for the view that you are accessing through REST or, if this is not possible, try the XML or JSON representations. For more information about these representation check the same section of the Administration Guide. Hope this helps!
Denodo Team
26-01-2016 11:54:52 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here