<?php
$u=<username>
$p=<password>
$sysID=<sysID>
$rs=urlencode(
"https://www.onuma.com/rest/".$u."/".$p."/");
$level = "studios/".$sysID."/";
$uri=$rs.$level;
//instantiate the cURL object
$cobj=curl_init($uri);
// the CURLOPT_RETURNTRANSFER parameter specifies that we
// want the data to transmit even if errors are encountered
curl_setopt($cobj,CURLOPT_RETURNTRANSFER,1);
// we then execute the transfer and pass the resulting data into a variable called $siteData
$siteData=curl_exec($cobj);
curl_close($cobj);
// we can now parse the XML data with SimpleXML
$siteXml = new SimpleXMLElement($siteData);
// to get the values in all rows in specific 'columns'
// in the array created by SimpleXML
foreach ($siteXml->RESULTSET[0]->ROW as $site){
// prints all site IDs and names
echo $site->COL[0]->DATA." - ".echo $site->COL[3]->DATA."<br />";
}
?>