SQL bridge to REST

[fredcwbr]

Howdy,

Would this emulator allow to create a bridge intercepting PG-SQL SELECT (thats all I need ), and execute a REST post, interpreting the results as a table-like , from an ODBC perspective?

Ex.,
SELECT *
FROM myRESTserviceAPI.service
WHERE field1='111111111'
AND field2='2222222'

this would result in a lookup for the fake schema matching of REST APIs, like ,

RESTapiTABLE_LOOKUP
fake_schema_name	urlRESTAPI	eventualAuthInfo
myRESTserviceAPI	http://www.myrestapisite.wtvr/etc/	someEncoded64AuthForExample
myRESTserviceAPI1	http://www.myrestapisite1.wtvr/etc2/	otherEncoded64AuthForExample
myRESTserviceAPIsoOn	http://www.myrestapisitesoOn.wtvr/more/etct/	etcEncoded64AuthForExample

and would create a http_post like :
headers= .... authinfo ... from lookup table
POST http://www.myrestapisite.wtvr/etc/service
{
field1=......
field1=.....
...... from WHERE CLAUSE.,
}

Would only consider for this matter, WHERE clause as source of name/variable pairs to the API.,
,,
whence the JSONResult would be converted to a table-like

from a JSON [ {"fld1" : "a" , "fld2" : "b", "fldn" : "c"}, { jsonRec1 } , {jsonRec2}, ...... ]
to a

fld1     fld2    fldn
a          b         c   
d          e         f
.....

Hoping to make myself clear,

Thanks in advance

Best regards

from Brasil ,
Frederico C Wilhelms

[oguimbal]

Hi !

Yes, I guess that would be doable using createAdvancedServer() .

Ideally, that would need createSimpleServer() to be implemented more easily, but I dont have time to implement that this year :/