All Commands
All Google
Commands
GOOGLE_SCRIPT
This command execute a Google Script and passes parameters.
You need to add the following function to handle the request and modify it to execute whatever script you need:
function doPost(e) {
var foo = e.parameter.foo;
var bar = e.parameter.bar;
return ContentService.createTextOutput("foo = " + foo + " & bar = " + bar);
}
Create a script on google scripts - https://script.google.com
“File” > “Save”
“File” > “Manage Versions”
“Publish” > “Deploy as web app…”
“Update” - you will then be shown a URL which contains the script ID needed for the UDB commandSelect the latest version,
Execute the app as “Me”
“Anyone, even anonymous” for access
If you want to use an updated script from UDB, re-save, create a new version, then publish the new version.
This command can have an {END_GOOGLE_SCRIPT} command.
In this case, the last parameter can be excluded from the arguments and the area between the {GOOGLE_SCRIPT()} and {END_GOOGLE_SCRIPT} will be used instead.
| Number | Name | Default | Type | Description |
|---|---|---|---|---|
| 1 | script_id | String | The ID of the Google Script. You can get this from the URL when editing the script. | |
| 2 | target | String | The destination Variable Name for the response. If this is left blank then the response will be returned directly to the page. |
|
| 3 | param_name | String | If this is set then an {END_GOOGLE_SCRIPT} command is needed and everything between the opening command and the closing command will be passed to the Script as this parameter. | |
| - | various | String | A JSON list of parameters and values to pass to the script. {"param1":"value1","param2":"value2"} |