Re: Google Sheets API Data Structure

2019-08-16 Thread Илья Рассадин
Hi! Have you looked on https://metacpan.org/pod/Net::Google::Spreadsheets::V4? It's newer, so probably It can give you a bit more data from modern Google API On 16/08/2019 14:18, James Kerwin wrote: Thanks Dave and Mike, I am using Net::Google::Spreadsheets and all the associated modules a

Re: Google Sheets API Data Structure

2019-08-16 Thread James Kerwin
Thanks Dave and Mike, I am using Net::Google::Spreadsheets and all the associated modules and yeah there I slept on this and then managed to see what could be seen this morning: print Dumper($ws[0]{atom}); print Dumper($ws[0]{container}); I should have been a bit clearer on what I was hoping to

Re: Google Sheets API Data Structure

2019-08-16 Thread David Precious
On Thu, 15 Aug 2019 16:18:57 +0100 James Kerwin wrote: > 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

Re: Google Sheets API Data Structure

2019-08-16 Thread 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

Google Sheets API Data Structure

2019-08-15 Thread 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 contain