如何通过Google表格API进行基本写作？ [英] How can I make basic writing via Google Sheets API?

问题描述

在我使用Swift学习Google表格API的过程中，我想在电子表格中编写单个范围。

On my way of learning Google Sheets API with Swift I wanted to write a single range to a spreadsheet.

展望快速入门iOS指南和基本写作示例我附带此代码：

func constructAndSendAQuery() {
    let baseUrl = "https://sheets.googleapis.com/v4/spreadsheets"
    let spreadsheetId = "1FhbBdEvpcyHsdfgsdft65eDGHre2fLVki5ZolMmZaRs"
    let range = "Sales!A31:C31"
    let url = baseUrl + "/" + spreadsheetId + "/values/" + range
    let params = ["valueInputOption": "RAW"]
    let fullUrl = GTLUtilities.URLWithString(url, queryParameters: params)

    let body = GTLObject()
    body.JSON = ["majorDimension":"ROWS",
                 "values": ["One", "Two", "Three"]]

    service.fetchObjectByInsertingObject(body, 
                                         forURL: fullUrl,
                                         delegate: self, 
                                         didFinishSelector: #selector(ViewController.processTheResponse(_:finishedWithObject:error:)))
}

不知道我做错了什么，但收到错误消息：在此服务器上找不到请求的URL。

Don't know what I did wrong but I got the error message: "The requested URL wasn't found on this server".

推荐答案

正如@ sam-berlin所提到的，我应该使用 fetchObjectByUpdatingObject 代替 fetchObjectByInsertUpdating 。

As @sam-berlin mentioned I should have used fetchObjectByUpdatingObject instead of fetchObjectByInsertUpdating.

但还有一个小错误/拼写错误。在构造JSON时，我丢失了一对方括号并得到了关于无效值的错误。

But there was one more little mistake/typo. In constructing JSON I lost a pair of square brackets and got an error about invalid value.

工作代码如下所示：

func constructAndSendARequest() {

    let baseUrl = "https://sheets.googleapis.com/v4/spreadsheets"
    let spreadsheetId = "1FhbBdEvpsfgzb3Akn1opmru0iresdfglbki5ZMmZaRs"
    let range = "Sales!A3:D3"
    let url = baseUrl + "/" + spreadsheetId + "/values/" + range
    let params = ["valueInputOption": "RAW"]
    let fullUrl = GTLUtilities.URLWithString(url, queryParameters: params)


    let body = GTLObject()
    body.JSON = ["range": range,
                 "majorDimension": "ROWS",
                 "values": [["One", "Two", "Three"]]]

    service.fetchObjectByUpdatingObject(body, forURL: fullUrl, delegate: self, didFinishSelector: #selector(ViewController.processTheResponse(_:finishedWithObject:error:)))   
}

也可以使用 service.fetchObjectByUpdatingObject（body，forURL：fullUrl，completionHandler：nil）而不处理响应。

It's also possible to use service.fetchObjectByUpdatingObject(body, forURL: fullUrl, completionHandler: nil) and not process the response.

这篇关于如何通过Google表格API进行基本写作？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！