http_get
returns a varchar containing the body of the request uri
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
SQLState |
Error Code |
Error Text |
Description |
|
HT001
|
Not valid host name or host IP address
|
|
|
HT002
|
Target host is unreachable
|
|
Examples
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://www.openlinksw.com/some_link.html',
header, 'POST', '', 'a=1&b=2');
...
page := http_get ('http://www.openlinksw.com/',
NULL, 'GET', '', '', 'proxy.server.com:8080');