Project

smartsheet

0.02
Repository is archived
No release in over 3 years
Low commit activity in last 3 years
This is an SDK to simplify connecting to the Smartsheet API (http://www.smartsheet.com/developers/api-documentation) from Ruby applications.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
 Dependencies

Development

>= 1.17
~> 1.3
~> 0.8.21
~> 5.0
~> 1.3
~> 10.0
~> 3.4
~> 4.7
~> 0.49
~> 0.9.1
~> 0.9

Runtime

~> 1.0
>= 0.13.1, < 2
>= 0.10.0, < 2
~> 1.2
 Project Readme

Smartsheet Ruby SDK Build Status Coverage Status Gem Version

This is an SDK to simplify connecting to the Smartsheet API from Ruby applications.

System Requirements

The SDK supports Ruby versions 2.2 or later.

Installation

Add this line to your application's Gemfile:

gem 'smartsheet', '>= 1.3.0'

And then execute:

$ bundle

Or install it yourself as:

$ gem install smartsheet

Documentation

The Smartsheet API documentation with corresponding SDK example code can be found here.

The generated SDK RubyDoc is available here.

Example Usage

To call the API, you must have an access token, which looks something like this example: JKlMNOpQ12RStUVwxYZAbcde3F5g6hijklM789. You can find the access token in the UI at Account > Personal Settings > API Access.

The following is a brief sample that shows you how to:

  • Initialize the client
  • List all sheets
  • Load one sheet
require 'smartsheet'

# Initialize the client - use your access token here
smartsheet_client = Smartsheet::Client.new(token: 'JKlMNOpQ12RStUVwxYZAbcde3F5g6hijklM789')
# The `smartsheet_client` variable now contains access to all of the APIs

begin
  # List all sheets
  sheets = smartsheet_client.sheets.list

  # Select first sheet
  sheet_id = sheets[:data][0][:id]

  # Load the entire sheet
  puts "Loading sheet id #{sheet_id}"
  sheet = smartsheet_client.sheets.get(sheet_id: sheet_id)
  puts "Loaded #{sheet[:total_row_count]} rows from sheet '#{sheet[:name]}'"

rescue Smartsheet::ApiError => e
  puts "Error Code: #{e.error_code}"
  puts "Message: #{e.message}"
  puts "Ref Id: #{e.ref_id}"
end

See the read-write-sheet example to see a more robust use case in action.

Conventions

Each endpoint may take a number of keyword arguments, including the special keyword argument body for requests that accept a request body. Smartsheet's API Ruby documentation provides the parameters expected for each endpoint.

Each endpoint also provides two optional keyword arguments:

  • params - This option is common for specifying enhancements or additional features for an API call. It specifies the query string for the call's URL.

    This must be a hash of URL query string fields to their values. For example, to make a call with the query string ?include=comments&includeAll=true, an API call would look like the following:

    ...get( ..., params: {include: 'comments', includeAll: true})
  • header_overrides - This option is less frequently used, as it overrides the HTTP headers sent by API calls on an individual basis. Use with caution, as some headers are required to allow the SDK to function properly.

    This must be a hash of headers to override values. For example, to make a call with a modified Assume-User header set to jane.doe@smartsheet.com, an API call would look like the following:

    ...get( ..., header_overrides: {'Assume-User' => 'jane.doe@smartsheet.com'})

Basic Configuration

When creating the client object, pass an object with any of the following properties to tune its behavior.

  • token - Your smartsheet API access token. If you omit this property (or pass an empty string) then the access token will be read from the system environment variable SMARTSHEET_ACCESS_TOKEN.

  • max_retry_time - The maximum time in seconds to retry intermittent errors. (Defaults to 15 seconds.)

  • base_url - By default, the SDK connects to the production API URL. Provide a custom base URL to connect to other environments. For example, to access SmartsheetGov, the base_url will be https://api.smartsheetgov.com/2.0.

    • To access Smartsheetgov, you will need to specify the Smartsheetgov API URI, https://api.smartsheetgov.com/2.0/, as the base_url during creation of the Smartsheet client object. The Smartsheetgov URI is defined as a constant (GOV_API_URL).
    • To access Smartsheet.eu, you will need to specify the Smartsheet.eu API URI, https://api.smartsheet.eu/2.0/, as the base_url during creation of the Smartsheet client object. The Smartsheet.eu URI is defined as a constant (EU_API_URL).

Advanced Configuration Options

Logging Configuration

Smartsheet expects a standard Ruby logger. For example, to enable console logging of warnings and above, make a call such as the following:

logger = Logger.new(STDOUT)
logger.level = Logger::INFO
smartsheet = Smartsheet::Client.new(logger: logger)

Supported log levels are as follows:

Level What is logged
Logger::ERROR Failures only
Logger::WARN Failures and retries
Logger::INFO Each call's URL and response code
Logger::DEBUG Full headers and payloads

By default, payloads are truncated to 1024 characters. To display full payloads, pass the log_full_body named flag to the Smartsheet::Client with the value true:

smartsheet = Smartsheet::Client.new(logger: logger, log_full_body: true)

Retry Configuration

For additional customization, you can specify a backoff_method function. This function is called with two arguments:

  • The first accepts the index of the retry being attempted (0 for the first retry, 1 for the second, etc.)
  • The second accepts the Error Object that caused the retry.

The function must return the number of seconds to wait before making the subsequent retry call, or the symbol :stop if no more retries should be made.

The default implementation performs exponential backoff with jitter.

JSON Input and Output

  • json_output - A flag indicating if data should be returned as a JSON string.

    By default, the Ruby SDK converts the raw JSON API response (with camelCase properties) to a Ruby hash with snake_case properties. If you prefer to receive results as the original JSON string, initialize the client with json_output: true.

    Regardless of this setting, the SDK will accept body parameters as a hash or JSON, and in either camelCase or snake_case.

Assume User

  • assume_user - Allows an admin to act on behalf of, or impersonate, the user to make API calls. The email address should NOT be URI encoded.

User Agent

  • user_agent - A custom app name to add to the user agent header; this helps Smartsheet diagnose any issues you may have while using the SDK.

Development

After checking out the repo, run bin/setup to install dependencies. You can also run bin/console for an interactive prompt that will allow you to experiment.

To install this gem onto your local machine, run bundle exec rake install.

If you are developing with Ruby 2.2.x, you may encounter basic SSL connection errors when making calls with the API. We recommend either updating to Ruby 2.3+, or following the directions in this Faraday issue: lostisland/faraday#392

Running the Tests

All

  1. Run rake test. Note, the mock API tests will fail unless the mock server is running. See Mock API Tests

Unit Tests

  1. Run rake test:units

Mock API Tests

  1. Clone the Smartsheet SDK tests repo and follow the instructions from the README to start the mock server
  2. Run rake test:mock_api

Passthrough Option

If there is an API Feature that is not yet supported by the Ruby SDK, there is a passthrough option that allows you to call arbitrary API endpoints.

To invoke the passthrough, your code can call one of the following three methods:

response = smartsheet.request(method:, url_path:, body:, params:, header_overrides:)

response = smartsheet.request_with_file(method:, url_path:, file:, file_length:, filename:, content_type:, params:, header_overrides:)

response = smartsheet.request_with_file_from_path(method:, url_path:, path:, filename:, content_type:, params:, header_overrides:)

  • method: The method to invoke, one of :get, :post, :put, or :delete
  • url_path: The specific API endpoint you wish to invoke. The client object base URL gets prepended to the caller’s endpoint URL argument.
  • body: An optional hash of data to be passed as a JSON request body
  • file: An opened File object to read as the request body, generally for file attachment endpoints
  • path: The path of a file to be read as the request body, generally for file attachment endpoints
  • file_length: The length of a file body in octets
  • filename: The name of a file body
  • content_type: The MIME type of a file body
  • params: An optional hash of query parameters
  • header_overrides: An optional hash of HTTP header overrides

All calls to passthrough methods return a JSON result, converted to a hash using symbol keys, in the same manner as the rest of the SDK. For example, after a PUT operation, the API's result message could be contained in response[:message]. If you prefer raw JSON instead of a hash, create a client with json_output configured; see client documentation above for more info.

Passthrough Example

The following example shows how to POST data to https://api.smartsheet.com/2.0/sheets using the passthrough method and a hash:

payload = {
  name: 'my new sheet',
  columns: [
    {
      title: 'Favorite',
      type: 'CHECKBOX',
      symbol: 'STAR'
    },
    {
      title: 'Primary Column',
      primary: true,
      type: 'TEXT_NUMBER'
    }
  ]
}

response = smartsheet.request(
  method: :post,
  url_path: 'sheets',
  body: payload
)

Advanced Topics

For details about more advanced features, see Advanced Topics.

Contributing

If you would like to contribute a change to the SDK, please fork a branch and then submit a pull request. More info here.

Version Numbers

Starting from the v2.77.0 release, Smartsheet SDKs will use a new versioning strategy. Since all users are on the Smartsheet API 2.0, the SDK version numbers will start with 2. The 2nd number will be an internal reference number. The 3rd number is for incremental changes.

For example, v2.77.0 means that you are using our 2.0 version of the API, the API is synched internally to a tag of 77, and then if there are numbers after the last decimal, that will indicate a minor change.

Support

If you have any questions or issues with this SDK please post on Stack Overflow using the tag "smartsheet-api" or contact us directly at devrel@smartsheet.com.

Release Notes

Each specific release is available for download via GitHub. Detailed release notes are available in [CHANGELOG.md].

Note: Minor changes that result in a patch version increment in RubyGems (such as updates to the README) will not be tagged as a Release in GitHub.