NAME

WWW::SmartSheet

VERSION

version 0.01

get_sheets

get_columns

Given the number of the sheet, returns an array of the column definitions each column is a hash: title type (TEXT_NUMBER, PICKLIST, ... ) index id primary ?? options (for PICKLIST)

Probably it should be the name of the sheet.

share_sheet

sheet_id
email => 'foo@examples.com',
access_level => one of the following strings: VIEWER EDITOR EDITOR_SHARE ADMIN

create_sheet

  $w->create_sheet(
    name    => 'Name of the sheet',
	columns =>  [

        { title => "Baked Good", type => 'TEXT_NUMBER', primary => 1 },
    	{ title => "Baker",      type => 'CONTACT_LIST' },
        { title => 'Price Per Item', type => 'TEXT_NUMBER' },
        { title => "Gluten Free?", "type":"CHECKBOX", "symbol":"FLAG"},
        { title => 'Status', type => 'PICKLIST', options => ['Started', 'Finished' , 'Delivered'] }
   ]);

add_column

$w->add_column($sheet_id, { title => 'Delivered', type => 'DATE', index => 5})

insert_rows

$w->insert_rows($sheet_id,
    {
        toTop => JSON::true,
        rows => [ {
            cells => [
                {"columnId":column_info[0]['id'], "value":"Brownies"},
                {"columnId":column_info[1]['id'], "value":"julieanne@smartsheet.com","strict": False},
                {"columnId":column_info[2]['id'], "value":"$1", "strict":False},
                {"columnId":column_info[3]['id'], "value":True},
                {"columnId":column_info[4]['id'], "value":"Finished"},
                {"columnId":column_info[5]['id'], "value": "None", "strict":False}]
                                               },

OTHER

The code of this client is free software. Access to the services of Smartsheet requires registration and payment.

API Documentation

AUTHOR

Gabor Szabo <szabgab@cpan.org>

COPYRIGHT AND LICENSE

This software is copyright (c) 2013 by Gabor Szabo.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.