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.
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.