Nobuo Danjou > Net-Google-Spreadsheets-0.1501 > Net::Google::Spreadsheets::Record

Download:
Net-Google-Spreadsheets-0.1501.tar.gz

Dependencies

Annotate this POD

CPAN RT

New  1
Open  0
View/Report Bugs
Source  

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>

syntax highlighting: