I'm trying to update a cell in a google sheet spreadsheet..... superRange
in this case is A328:A and i'm getting the message
2018-05-10 11:53:16.434032-0700 LAADyeApp[3252:1832239] Error: Invalid
JSON payload received. Unknown name "a328:_a" at 'data.values[0]': Cannot
find field.
NSArray *data = [NSArray arrayWithObjects: @{ superRange: @"test" } ,
nil];
GTLRSheets_ValueRange *value;
NSMutableDictionary *datum = [[NSMutableDictionary
alloc]initWithDictionary: @{ @"values": data }];
value = [GTLRSheets_ValueRange objectWithJSON:datum];
GTLRSheetsQuery_SpreadsheetsValuesUpdate *query2 =
[GTLRSheetsQuery_SpreadsheetsValuesUpdate queryWithObject:value
spreadsheetId:spreadsheetId range:superRange];
[self.service executeQuery:query2
delegate:self
didFinishSelector:@selector(displayResultWithTicket:finishedWithObject:error:)];
heres some debug data
2018-05-10 11:53:15.318726-0700 LAADyeApp[3252:1832239] Testing range:
A328:A
2018-05-10 11:53:15.318863-0700 LAADyeApp[3252:1832239] Getting sheet
data...
2018-05-10 11:53:15.335954-0700 LAADyeApp[3252:1832239] OK: (
{
"A328:A" = test;
}
)
2018-05-10 11:53:16.434032-0700 LAADyeApp[3252:1832239] Error: Invalid
JSON payload received. Unknown name "a328:_a" at 'data.values[0]': Cannot
find field.
EDIT:::
I figured out how to format my question!
How can I properly create / initiate a GTLRSheets_ValueRange ? Can someone
show me the proper structure for JSON iOS ?
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
