Re: Google Sheets API Data Structure

[Mike]

Please state the exact module name.
Is it this one:
https://metacpan.org/pod/Net::Google::Spreadsheets::V4

My guess is no.


Mike


On 8/15/2019 10:18 AM, James Kerwin wrote:

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