0

I'm trying to update a cell in a Google Sheets 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.

How can I properly create / initialize a GTLRSheets_ValueRange, and then update it?

tehhowch
  • 9,645
  • 4
  • 24
  • 42
digit
  • 197
  • 9

0 Answers0