Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
Net::Google::SpreadsheUser:Contributed PerNet::Google::Spreadsheets::Record(3)

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>

perl v5.32.1			  2012-04-Net::Google::Spreadsheets::Record(3)

NAME | SYNOPSIS | METHODS | ATTRIBUTES | SEE ALSO | AUTHOR

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=Net::Google::Spreadsheets::Record&sektion=3&manpath=FreeBSD+13.0-RELEASE+and+Ports>

home | help