Calling Apps Script API function from Golang with Parameters?

Question

I want to call Apps Script function from Golang.

I can send the Parameter from Golang but cannot make it work in runMyFunction. If I add return myParameter; - I can see the parameter I am passing but using it inside SQL to BigQuery is not working. I am getting undefined

var sql = ' SELECT column1, column2 ' +
  ' FROM  dataset.mytable WHERE SUBSTR ( column1) = "'
+ myParameter + '" ;'

My Apps Script Function:

function runMyFunction(myParameter) {
...
return myParameter;
}

In Golang, calling `runMyFunction`

type Message struct {
    myParameter string
}
m := Message{"1234"}
a := make([]interface{}, 1)
a[0] = m
req := script.ExecutionRequest{Function: "runMyFunction",
    Parameters: a,
    DevMode:    true}

// Make the API request.
resp, err := srv.Scripts.Run(scriptID, &req).Do()

thstart · Accepted Answer · 2018-08-17 06:51:35Z

1

Actually this is the right solution:

a := []interface{}{"1234"}
req := script.ExecutionRequest{Function: "runMyFunction",
Parameters: a,
DevMode:    true}

answered Aug 17, 2018 at 6:51

thstart

4274 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Calling Apps Script API function from Golang with Parameters?

My Apps Script Function:

In Golang, calling `runMyFunction`

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

My Apps Script Function:

In Golang, calling runMyFunction

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related

In Golang, calling `runMyFunction`