Objective-C

batchGet (Read Multiple Ranges)

See more Google Sheets Examples

Reads multiple ranges from a Google Sheets spreadsheet in one GET request. Objective-C

#import <CkoJsonObject.h>
#import <CkoHttpRequest.h>
#import <CkoHttp.h>
#import <CkoHttpResponse.h>
#import <NSString.h>

BOOL success = NO;

// This example requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.

// This example uses a previously obtained access token having permission for the 
// Google Sheets scope.

// In this example, Get Google Sheets OAuth2 Access Token, the access
// token was saved to a JSON file.  This example fetches the access token from the file..
CkoJsonObject *jsonToken = [[CkoJsonObject alloc] init];
success = [jsonToken LoadFile: @"qa_data/tokens/googleSheets.json"];
if ([jsonToken HasMember: @"access_token"] == NO) {
    NSLog(@"%@",@"No access token found.");
    return;
}

// We'll be sending a GET request with query params to this URL:  https://sheets.googleapis.com/v4/spreadsheets/spreadsheetId/values:batchGet?ranges=Sheet1!A1:A2&ranges=Sheet1!B1:B2
// The domain is "sheets.googleapis.com"
// The path is "/v4/spreadsheets/spreadsheetId/values:batchGet"
CkoHttpRequest *req = [[CkoHttpRequest alloc] init];
req.Path = @"/v4/spreadsheets/spreadsheetId/values:batchGet";
req.HttpVerb = @"GET";
// Add each range to fetch.
[req AddParam: @"ranges" value: @"Sheet1!A1:A2"];
[req AddParam: @"ranges" value: @"Sheet1!B1:B2"];

CkoHttp *http = [[CkoHttp alloc] init];
http.AuthToken = [jsonToken StringOf: @"access_token"];

// 443 is the SSL/TLS port for HTTPS.
CkoHttpResponse *resp = [[CkoHttpResponse alloc] init];
success = [http HttpSReq: @"sheets.googleapis.com" port: [NSNumber numberWithInt: 443] ssl: YES request: req response: resp];
if (success == NO) {
    NSLog(@"%@",http.LastErrorText);
    return;
}

NSLog(@"%@",resp.BodyStr);

CkoJsonObject *json = [[CkoJsonObject alloc] init];
[json Load: resp.BodyStr];

// A sample response is shown below.
// To generate the parsing source code for a JSON response, paste
// the JSON into this online tool: Generate JSON parsing code

// {
//   "spreadsheetId": "1_SO2L-Y6nCayNpNppJLF0r9yHB2UnaCleGCKeE4O0SA",
//   "valueRanges": [
//     {
//       "range": "Sheet1!A1:A2",
//       "majorDimension": "ROWS",
//       "values": [
//         [
//           "Item"
//         ],
//         [
//           "Wheel"
//         ]
//       ]
//     },
//     {
//       "range": "Sheet1!B1:B2",
//       "majorDimension": "ROWS",
//       "values": [
//         [
//           "Cost"
//         ],
//         [
//           "$20.50"
//         ]
//       ]
//     }
//   ]
// }

int i;
int count_i;
int j;
int count_j;
int k;
int count_k;

NSString *spreadsheetId = [json StringOf: @"spreadsheetId"];
i = 0;
count_i = [[json SizeOfArray: @"valueRanges"] intValue];
while (i < count_i) {
    json.I = [NSNumber numberWithInt: i];
    NSString *range = [json StringOf: @"valueRanges[i].range"];
    NSString *majorDimension = [json StringOf: @"valueRanges[i].majorDimension"];
    j = 0;
    count_j = [[json SizeOfArray: @"valueRanges[i].values"] intValue];
    while (j < count_j) {
        json.J = [NSNumber numberWithInt: j];
        k = 0;
        count_k = [[json SizeOfArray: @"valueRanges[i].values[j]"] intValue];
        while (k < count_k) {
            json.K = [NSNumber numberWithInt: k];
            NSString *strVal = [json StringOf: @"valueRanges[i].values[j][k]"];
            k = k + 1;
        }

        j = j + 1;
    }

    i = i + 1;
}