use 'http://yql.stachura.ch/horde/test.xml' as horde; select * from horde WHERE urlhorde="http://horde.yourdomain.com/" AND method="horde.listApps" AND username="username" AND password="password"; auf der Konsole testen...
- urlhorde="http://horde.yourdomain.com/" trailing slash is importand !
- method="horde.listApps"
horde api method:
- horde3 http://www.yourdomain.com/rpc.php?wsdl
- horde4 take a look at api.php source code
- username="horde user name"
- password="horde password"
Execute Abschnitt der YQL Tabelle
API CALL
<?php
$rpc_endpoint = "http://horde.finishers.ch/rpc.php";
// XML-RPC method to call
$rpc_method = "horde.listApps";
// Process the request
$rpc_options = array(
"user" => "username",
"pass" => "password"
);
// Process the request, sending
// user/pass in the "options" parameter.
$result = Horde_RPC::request(
"xmlrpc",
$rpc_endpoint,
$rpc_method,
array(),
$rpc_options
);
// Dump the results
var_dump($result);
?>XML
<methodCall> <methodName>horde.listApps</methodName> <params/> </methodCall>
80 % der Ergebnisse werden in 20 % der Gesamtzeit eines Projekts erreicht.
Pareto 80/20 Rule