How do I retrieve data from the Orion API ?

N.Wichayuth

When I Compile/Run the data I got data like this

             {"results":[{"NodeID":140089}]}

But I want the data expressed like this.

             140089

**$text is the data I input.

Can someone help me? thank you

This is the code from PHP.

<?php

$url = "https://localhost:17778/SolarWinds/InformationService/v3/Json/Query";
$data[0] = array('query' => "SELECT NodeID FROM Orion.Nodes WHERE IP_Address = '$text'");
$jdata[0] = json_encode($data[0]);
$resultNode = CallAPI($url, $jdata[0]);

echo $resultNode;


function CallAPI($url, $data = false) {
   $ch = curl_init();
    // Authentication:
  curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_BASIC);
  curl_setopt($ch, CURLOPT_USERPWD, "user:pass");
  curl_setopt($ch, CURLOPT_URL, $url);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  curl_setopt($ch, CURLOPT_SSLVERSION, 1);
  curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  curl_setopt($ch, CURLOPT_VERBOSE, true);
  curl_setopt($ch, CURLOPT_HTTP_CONTENT_DECODING, false);
  curl_setopt($ch, CURLOPT_POSTFIELDS, $data);
  curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/json; charset=utf-8', 'Content-length: '));
  $result = curl_exec($ch);
  $response = curl_getinfo($ch, CURLINFO_HTTP_CODE);
  $error = curl_error($ch);
  $info = curl_getinfo($ch);
  curl_close($ch);
    if ($result == false) {
  echo "Response: " . $response . "
";
  echo "Error: " . $error . "
";

  echo "Info: " . print_r($info);
  die();
  }
  return $result;
}

?>

adam.beedell

This is a PHP question not a data question really, you've got the stuff out. Stackexchange or something would be a better place to ask.

That said there'll be a JSON handling function you want to use here on $info to split it into an addressable array

If you're just pulling a node ID you could probably parse the data by splitting the string between 'NodeID":' and the following '}'. But definitely the JSON handler call is the correct way to go.