Name

http_get — returns a varchar containing the body of the request uri

Synopsis

varchar http_get ( in target_uri varchar ,
out return_header any ,
in http_method varchar ,
in request_header varchar ,
in request_body varchar ,
in proxy varchar );

Description

http_get returns a varchar containing the body of the requested target_uri or NULL if the body is not received.

Parameters

target_uri

HTTP target in form http://<target_host>:<target_port>/<path> (if <target_port> is not given then 80 will be used by default)

return_header

This output parameter is set to the array of HTTP response header lines from the target server, if the parameter is a constant it will be ignored.

http_method

This parameter will be used to specify the HTTP request method. Possible values are: GET, POST, PUT, OPTIONS or see RFC2616[5.1.1] for details.

request_header

This string will be sent to the target server together with other header fields. If more than one header field should be sent then header fields must be separated with CR/LF pair. (Warning: this string must not be terminated with CR/LF pair!).

request_body

This string will be sent to the target server as the request body. The "Content-Length" header field is set to the length of this string.

proxy

If this parameter is supplied the request will be passed through this HTTP proxy. The format is <proxy_host>:<proxy_port> .

Supports:

http://[user:pass@]host:port - user & pass are optional
socks4://[user:pass@]host:port - user & pass are optional
socks5://[user:pass@]host:port - user & pass are optional
socks5-host://[user:pass@]host:port - user & pass are optional

In the INI file, in section HTTPServer should be set:

HTTPProxyServer       = proxytest:3128
HTTPProxyExceptions   = localhost:8890, 127.0.0.1:8890

Exception could be also 127.0.0.* i.e. there could have also wildcard.

Errors

Table24.40.Errors signalled by

SQLState Error Code Error Text Description
HT001 Not valid host name or host IP address
HT002 Target host is unreachable

Examples

Example24.163.Using http_get()

declare header any;
page := http_get ('http://www.openlinksw.com/');
...
page := http_get ('http://www.openlinksw.com/',
                header, 'GET', 'If-Modified-Since: Fri, 21 Jul 2000 11:19:45 GMT');
...
page := http_get ('http://example.com/some_link.html',
                header, 'POST', '', 'a=1&b=2');
...
page := http_get ('http://www.openlinksw.com/',
                NULL, 'GET', '', '', 'proxy.server.com:8080');