The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

NAME

Net::Google::Spreadsheets::Record - A representation class for Google Spreadsheet record.

SYNOPSIS

use Net::Google::Spreadsheets;

my $service = Net::Google::Spreadsheets->new(
  username => 'mygoogleaccount@example.com',
  password => 'mypassword',
);

# get a record
my $record = $service->spreadsheet(
  {
      title => 'list for new year cards',
  }
)->table(
  {
      title => 'addressbook',
  }
)->record(
  {
      sq => 'id = 1000',
  }
);

# get the content of a row
my $hashref = $record->content;
my $id = $hashref->{id};
my $address = $hashref->{address};

# update a row
$record->content(
  {
      id => 1000,
      address => 'somewhere',
      zip => '100-0001',
      name => 'Nobuo Danjou',
  }
);

# get and set values partially

my $value = $record->param('name');
# returns 'Nobuo Danjou'
# you can also get it via content like this:
my $value_via_content = $record->content->{name};

my $newval = $record->param({address => 'elsewhere'});
# updates address (and keeps other fields) and returns new record value (with all fields)

my $hashref2 = $record->param;
# same as $record->content;

# setting whole new content
$record->content(
  {
      id => 8080,
      address => 'nowhere',
      zip => '999-9999',
      name => 'nowhere man'
  }
);

# delete a record
$record->delete;

METHODS

param

sets and gets content value.

delete

deletes the record.

ATTRIBUTES

content

Rewritable attribute. You can get and set the value.

SEE ALSO

https://developers.google.com/google-apps/spreadsheets/

Net::Google::AuthSub

Net::Google::Spreadsheets

Net::Google::Spreadsheets::Table

Net::Google::Spreadsheets::Row

AUTHOR

Nobuo Danjou <danjou@soffritto.org>