CLOB to string

[mlopezal]

I've got a freebase page which return a text (http://api.freebase.com/api/trans/raw/guid/9202a8c04000641f800000000029c281).

I've created a source view based on a webservice datasource (REST or NON SOAP) wich reference http://api.freebase.com/api/trans

I've created a model view which generate dinamically the url based on the source model.

How can I get the text returned by this url like as string ¿?. I've used this sentence (SELECT z.result FROM (EXEC FreebaseTrans.invokeHttp(action => 'GET', endpoint => VARIABLES.INPUT_ENDPOINT)) AS z);

but I don't know how to convert result attribute (blob) to a string

Thanks,

Mónica

[rareddy]

Look in the Teiid Reference Guide for all the Function library. I am thinking the below will work.

https://docs.jboss.org/author/display/TEIID/Type+Conversion+Functions

https://docs.jboss.org/author/display/TEIID/String+Functions

SELECT CONVERT(TO_CHARS(z.result, 'UTF-8'), string) FROM (EXEC FreebaseTrans.invokeHttp(action => 'GET', endpoint => VARIABLES.INPUT_ENDPOINT)) AS z

Ramesh..

[mlopezal]

Thanks again !