I have several questionnaires which I need to combine into a sort of
"master" results spreadsheet. I have been able to create a new spreadsheet
and add all the headers into it using cells-feed API. The problem comes when
I go to insert the records into the new sheet using the list-feed API.
I am creating the List entries like this:
ListEntry listEntry=new ListEntry();
listEntry.getCustomElements().setValueLocal(key,
value));
listFeed.getEntries().add(listEntry);
spreadsheetService.insert(listFeedUrl, listEntry);
Here is generated XML:
<?xml version='1.0' encoding='utf-8'?>
<entry xmlns='http://www.w3.org/2005/Atom'
xmlns:gsx='http://schemas.google.com/spreadsheets/2006/extended'
xmlns:gs='http://schemas.google.com/spreadsheets/2006'
xmlns:batch='http://schemas.google.com/gdata/batch'>
<category scheme='http://schemas.google.com/spreadsheets/2006'
term='http://schemas.google.com/spreadsheets/2006#list' />
<gsx:4. do you do like ServiceExceptions?>Apparently</gsx:4. do you do
like ServiceExceptions?>
</entry>
Attribute name "do" associated with an element type
"gsx:4." must be followed by the ' = ' character.
I tried URLEncoding the entries key/value, and also quoting, but I got
basically the same error. (And it probably wouldn't work even if I didn't)
Is there a workaround for this? or do I need to use the cell-feed API (which
I would really, really like to avoid);
Thanks