גאבור סבו - Gábor Szabó > WWW-SmartSheet-0.01 > WWW::SmartSheet

Download:
WWW-SmartSheet-0.01.tar.gz

Dependencies

Annotate this POD

Website

View/Report Bugs
Module Version: 0.01   Source  

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.

syntax highlighting: