David,

You, sir, are a GOD! Thank you so much! I had already tried removing the 
dash and making cellar-id be cellarId and that had not worked so I decided 
to try your cells feed suggestion. It took me a couple of hours to get the 
cells feed to work but I managed to create a batch and add the column 
headers and data at the same time. One last problem I had (and subsequently 
fixed) was that it looked like the request had worked because the onSuccess 
was called but there was nothing in the spreadsheet. I looked at the 
response and there was an error message in there about needing If-Match or 
If-Not-Match. I looked at the documentation and read I had to add "If-Match: 
*" (although that was not mentioned in the batch section) so I added it and 
the request worked perfectly. What I find odd is that the onSuccess was 
called and not the onError. Seems like a bug to me. I suppose that is as 
likely to be fixed as Google having decent documentation or perhaps not 
telling me there is a server error when the problem is missing column 
headers! Anyway, I'll step off my soapbox now and say once again, THANK YOU!

Scott

Reply via email to