cyga / www_fdw

fdw extension for postgres
http://wiki.postgresql.org/wiki/WWW_FDW
123 stars 21 forks source link

cannot parse json respone when query from foreign table in www_fdw postgresql #33

Open frbsfri opened 7 years ago

frbsfri commented 7 years ago

I am using www_fdw to query from twitter search API, here is the process that I followed:

CREATE extension www_fdw;
CREATE server www_fdw_server_twitter FOREIGN DATA Wrapper www_fdw OPTIONS
     (uri 'https://api.twitter.com/1.1/search/tweets.json',cainfo 'C:/SSLCerts/ca
    bundle.crt'); 
       CREATE USER MAPPING FOR current_user SERVER www_fdw_server_twitter;
        CREATE FOREIGN TABLE www_fdw_twitter (
        /* parameters used in request */
        q text,
        page text,
        rpp text,
        result_type text,
        /* fields in response */
        created_at text,
        from_user text,
        from_user_id text,
        from_user_id_str text,
        geo text,
        id text,
        id_str text,
        is_language_code text,
        profile_image_url text,
        source text,
        text text,
        to_user text,
        to_user_id text
        ) SERVER www_fdw_server_twitter;

When I want to query from my foreign table with following query:

select id,substr(text,1,30)||'...' from www_fdw_twitter where q='postgres'; I get this error:

ERROR: Can't find result in parsed server's json response

I am using postgreSQL 9.5 in window64.