Google Sheets API Data Structure

[James Kerwin]

Hi All,

I managed to get the Google Sheets API Perl module working.

I'm currently investigating a data structure that it gives me to see what
values I can get from it. Through random experimentation I've managed to
find that it had "title" and "id".

I wrote this to get the data structure containing the worksheets:

my @ws = $spreadsheet->worksheets;


Now if I do:

print $ws[1]->id;

print $ws[1]->title;


I get the value in the id and the title for the specific item in the array.
I want to know what other information is in there.

If I do this:

for my $href (@ws) {

    print "{ ";

    for my $role (keys %{ $href }) {

        print "$role=$href->{$role} ";

    }

    print "}\n";

}

I get:

{ atom=XML::Atom::Entry=HASH(0x1b81928)
container=Net::Google::Spreadsheets::Spreadsheet=HASH(0x1bbdb80) }

{ atom=XML::Atom::Entry=HASH(0x1bbbe98)
container=Net::Google::Spreadsheets::Spreadsheet=HASH(0x1bbdb80) }

{ container=Net::Google::Spreadsheets::Spreadsheet=HASH(0x1bbdb80)
atom=XML::Atom::Entry=HASH(0x1b86ca0) }

{ container=Net::Google::Spreadsheets::Spreadsheet=HASH(0x1bbdb80)
atom=XML::Atom::Entry=HASH(0x1b86988) }

{ container=Net::Google::Spreadsheets::Spreadsheet=HASH(0x1bbdb80)
atom=XML::Atom::Entry=HASH(0x1b8c958) }

If I use Dumper it just seems to output SO MUCH information that I can't
see the wood for the trees. Maybe I'm just tired after a dramatic day in
Perl land.

Can anyone help me untangle this? My spreadsheet has five worksheets and
there are five lines in my output so my assumption is that each line
represents a sheet.

Any advice/help/guidance would be greatly appreciated.

Thanks,
James