CODEWITHSUNDEEP
phpapismartsheet-api
Tun Tun
Tun Tun

Reputation: 41

How to access Smartsheet from PHP API?

It is my first time trying to connect Sheet from Smartsheet using API with PHP.
I cannot seem to connect and give me this error

Notice: Trying to get property of non-object in C:\xampp\htdocs\smartsheet\test.php on line 22

The variable $sheetObj is empty.
And in Authorization: Bearer, what does Bearer means? Is it a token name or it is always Bearer?

My future plan is to write into the row of smartsheet using PHP. Can anyone give me advice what went wrong with my code? 

$baseURL = "https://api.smartsheet.com/1.1";
$sheetsURL = $baseURL . "/sheets/";
$getSheetURL = $baseURL . "/sheet/xxxxxxxxxxx";
$rowsURL = $baseURL . "/sheet/xxxxxxxxxxx/rows";

$accessToken = "xxxxxxxxxxxxxxxxxx"; 

// Create Headers array for cURL
$headers = array(
    "Authorization: Bearer " . $accessToken,
    "Content-Type: application/json"
);  

$curlSession = curl_init($getSheetURL);
curl_setopt($curlSession, CURLOPT_HTTPHEADER, $headers);
curl_setopt($curlSession, CURLOPT_RETURNTRANSFER, TRUE);
$getSheetResponseData = curl_exec($curlSession);

$sheetObj = json_decode($getSheetResponseData);
echo "<h1>Sheet name: ". $sheetObj->name ."</h1>";

Upvotes: 0

Views: 2233

Answers (4)

Sergio Sabido
Sergio Sabido

Reputation: 5

Hello to use the smartsheet API connection to PHP, the API version 2.0 is used, because the older version is obsolete, the code for the connection is as follows:

$baseURL = "https://api.smartsheet.com/2.0/sheets";
// Insertar access token generado en SmartSheet
$accessToken = "YOUR_TOKEN";
// Creación del Headers Array para el Curl
$headers = array(
"Authorization: Bearer $accessToken",
"Content-Type: application/json");

//Conexión de la API de SmartSheet
 $curlSession = curl_init($baseURL);
 curl_setopt($curlSession, CURLOPT_HTTPHEADER, $headers);
 curl_setopt($curlSession, CURLOPT_RETURNTRANSFER, true);

 //Establece la sesión del Curl
 $smartsheetData = curl_exec($curlSession);


 // Asignar respuesta a un objeto PHP
 $createObj = json_decode($smartsheetData);

Upvotes: 0

Brett
Brett

Reputation: 2823

Both stmcallister and Kim provided good information on how to troubleshoot your issue and some likely causes.

There were actually two issues with the code you provided.

  1. As Scott mentioned you must point to the 2.0 version of the API.

    $baseURL = "https://api.smartsheet.com/2.0";

  2. You have a typo in your $getSheetURL. As is documented here the url is /sheets/{sheetId}. So your code should have the following: 

    $getSheetURL = $baseURL. "/sheets/xxxxxxxxxxx";

Here is your code in a working state. Make sure to replace YOUR_TOKEN and also take a look at the output from var_dump (which I added to your code) to see what message it gives you.

<?php
$baseURL = "https://api.smartsheet.com/2.0";
$getSheetURL = $baseURL. "/sheets/4925037959505796";
$accessToken = "YOUR_TOKEN"; 

$headers = array("Authorization: Bearer ". $accessToken);

$curlSession = curl_init($getSheetURL);
curl_setopt($curlSession, CURLOPT_HTTPHEADER, $headers);
curl_setopt($curlSession, CURLOPT_RETURNTRANSFER, TRUE);
$getSheetResponseData = curl_exec($curlSession);

// Remove this line when done debugging
var_dump($getSheetResponseData);

$sheetObj = json_decode($getSheetResponseData);

echo "<h1>Sheet name: ". $sheetObj->name ."</h1>";
?>

Upvotes: 2

Kim Brandl
Kim Brandl

Reputation: 13480

Search here on SO for the (partial) error message "Trying to get property of non-object" and you'll see lots of related posts. Essentially, this error means that your code is treating something as an object that's not actually an object. This would happen, for instance, when you try to access the name property of $sheetObj if the API request had previously failed for some reason and the contents of $sheetObj is therefore not actually an object.

I'm not very familiar with PHP, but I'd suspect (based on the error message, combined with the fact that you say "var_dump($getSheetResponseData) is Bool(false)) that the "Get Sheet" request may not be returning a successful response. To troubleshoot, I'd suggest that you try running the exact same "Get Sheet" request (i.e., with identical URI, including sheet Id) using a tool like Postman (https://www.getpostman.com/) or via the commandline with cURL, and see if you get a successful response. If you can get your request working via Postman or cURL, it should be straightforward to update your code to send the same request, resulting in a successful response. See this section of the Smartsheet API docs for info about API Troubleshooting techniques using Postman or cURL: http://smartsheet-platform.github.io/api-docs/#api-troubleshooting.

Upvotes: 1

stmcallister
stmcallister

Reputation: 1719

Version 1.1 of the Smartsheet API is no longer supported. You'll want to use version 2.

To do this just change $baseURL to this:

$baseURL = "https://api.smartsheet.com/2.0";

Also, each of the objects in the API will be represented by plural endpoints. So, to get a sheet you'll use:

$getSheetURL = $baseURL. "/sheets/xxxxxxxxxxx";

To get the rows you'll use:

$rowsURL = $baseURL. "/sheets/xxxxxxxxxxx/rows";

Bearer is the type of Authorization header that you're passing to the API, and the type that is required by the Smartsheet API.

Upvotes: 0

Related Questions