Stay organized with collections Save and categorize content based on your preferences.
ScriptProperties
Deprecated. This class is deprecated and should not be used in new scripts.
Script Properties are key-value pairs stored by a script in a persistent store. Script Properties are scoped per script, regardless of which user runs the script.
Deprecated. This function is deprecated and should not be used in new scripts.
Get all of the available keys.
Return
String[]
getProperties()
Deprecated. This function is deprecated and should not be used in new scripts.
Get all of the available properties at once.
This gives a copy, not a live view, so changing the properties on the returned object won't update them in storage and vice versa.
ScriptProperties.setProperties({"cow":"moo","sheep":"baa","chicken":"cluck"});// Logs "A cow goes: moo"Logger.log("A cow goes: %s",ScriptProperties.getProperty("cow"));// This makes a copy. Any changes that happen here will not// be written back to properties.varanimalSounds=ScriptProperties.getProperties();// Logs:// A chicken goes cluck!// A cow goes moo!// A sheep goes baa!for(varkindinanimalSounds){Logger.log("A %s goes %s!",kind,animalSounds[kind]);}
Return
Object — a copy of the properties containing key-value pairs
getProperty(key)
Deprecated. This function is deprecated and should not be used in new scripts.
Returns the value associated with the provided key, or null if there is no such value.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-02 UTC."],[[["\u003cp\u003eScriptProperties is deprecated and should not be used in new scripts, serving as a persistent key-value store scoped per script.\u003c/p\u003e\n"],["\u003cp\u003eIt provides methods for setting, getting, and deleting properties, but these are all deprecated.\u003c/p\u003e\n"],["\u003cp\u003eDespite offering functionalities like bulk operations and property retrieval, developers should refrain from using them in new projects.\u003c/p\u003e\n"],["\u003cp\u003eThe class is primarily for legacy scripts and should be replaced with more modern alternatives for data persistence.\u003c/p\u003e\n"]]],[],null,["ScriptProperties\n\n\n**Deprecated.** This class is deprecated and should not be used in new scripts.\n\nScript Properties are key-value pairs stored by a script in a persistent store. Script Properties\nare scoped per script, regardless of which user runs the script. \n\nDeprecated methods\n\n| Method | Return type | Brief description |\n|------------------------------------------------------------------------------|-----------------------|----------------------------------------------------------------------------------------|\n| [deleteAllProperties()](#deleteAllProperties()) | [ScriptProperties](#) | Deletes all properties. |\n| [deleteProperty(key)](#deleteProperty(String)) | [ScriptProperties](#) | Deletes the property with the given key. |\n| [getKeys()](#getKeys()) | `String[]` | Get all of the available keys. |\n| [getProperties()](#getProperties()) | `Object` | Get all of the available properties at once. |\n| [getProperty(key)](#getProperty(String)) | `String` | Returns the value associated with the provided key, or null if there is no such value. |\n| [setProperties(properties)](#setProperties(Object)) | [ScriptProperties](#) | Bulk-sets all the properties drawn from the given object. |\n| [setProperties(properties, deleteAllOthers)](#setProperties(Object,Boolean)) | [ScriptProperties](#) | Bulk-sets all the properties drawn from the given object. |\n| [setProperty(key, value)](#setProperty(String,String)) | [ScriptProperties](#) | Persists the specified in value with the provided key. |\n\nDeprecated methods \n\n`delete``All``Properties()` \n\n**Deprecated.** This function is deprecated and should not be used in new scripts.\n\nDeletes all properties.\n\n```javascript\nScriptProperties.deleteAllProperties();\n```\n\nReturn\n\n\n[ScriptProperties](#) --- this object, for chaining\n\nSee also\n\n- [deleteProperty(key)](#deleteProperty(String))\n\n*** ** * ** ***\n\n`delete``Property(key)` \n\n**Deprecated.** This function is deprecated and should not be used in new scripts.\n\nDeletes the property with the given key.\n\n```javascript\nScriptProperties.deleteProperty('special');\n```\n\nParameters\n\n| Name | Type | Description |\n|-------|----------|----------------------------|\n| `key` | `String` | key for property to delete |\n\nReturn\n\n\n[ScriptProperties](#) --- this object, for chaining\n\nSee also\n\n- [deleteAllProperties()](#deleteAllProperties())\n\n*** ** * ** ***\n\n`get``Keys()` \n\n**Deprecated.** This function is deprecated and should not be used in new scripts.\n\nGet all of the available keys.\n\nReturn\n\n\n`String[]`\n\n*** ** * ** ***\n\n`get``Properties()` \n\n**Deprecated.** This function is deprecated and should not be used in new scripts.\n\nGet all of the available properties at once.\n\nThis gives a copy, not a live view, so changing the properties on the returned object won't\nupdate them in storage and vice versa.\n\n```javascript\nScriptProperties.setProperties({\n \"cow\" : \"moo\",\n \"sheep\" : \"baa\",\n \"chicken\" : \"cluck\"\n});\n\n// Logs \"A cow goes: moo\"\nLogger.log(\"A cow goes: %s\", ScriptProperties.getProperty(\"cow\"));\n\n// This makes a copy. Any changes that happen here will not\n// be written back to properties.\nvar animalSounds = ScriptProperties.getProperties();\n\n// Logs:\n// A chicken goes cluck!\n// A cow goes moo!\n// A sheep goes baa!\nfor(var kind in animalSounds) {\n Logger.log(\"A %s goes %s!\", kind, animalSounds[kind]);\n}\n```\n\nReturn\n\n\n`Object` --- a copy of the properties containing key-value pairs\n\n*** ** * ** ***\n\n`get``Property(key)` \n\n**Deprecated.** This function is deprecated and should not be used in new scripts.\n\nReturns the value associated with the provided key, or null if there is no such value.\n\n```javascript\nconst specialValue = ScriptProperties.getProperty('special');\n```\n\nParameters\n\n| Name | Type | Description |\n|-------|----------|-------------------------------|\n| `key` | `String` | key for the value to retrieve |\n\nReturn\n\n\n`String` --- the value associated with the key\n\nSee also\n\n- [setProperty(key, value)](#setProperty(String,String))\n\n*** ** * ** ***\n\n`set``Properties(properties)` \n\n**Deprecated.** This function is deprecated and should not be used in new scripts.\n\nBulk-sets all the properties drawn from the given object.\n\n```javascript\nScriptProperties.setProperties({special: 'sauce', 'meaning': 42});\n```\n\nParameters\n\n| Name | Type | Description |\n|--------------|----------|---------------------------------------------|\n| `properties` | `Object` | an object containing the properties to set. |\n\nReturn\n\n\n[ScriptProperties](#) --- this object, for chaining\n\nSee also\n\n- [setProperty(key, value)](#setProperty(String,String))\n\n*** ** * ** ***\n\n`set``Properties(properties, deleteAllOthers)` \n\n**Deprecated.** This function is deprecated and should not be used in new scripts.\n\nBulk-sets all the properties drawn from the given object.\n\n```javascript\n// This deletes all other properties\nScriptProperties.setProperties({special: 'sauce', 'meaning': 42}, true);\n```\n\nParameters\n\n| Name | Type | Description |\n|-----------------------|-----------|---------------------------------------------|\n| `properties` | `Object` | an object containing the properties to set. |\n| `delete``All``Others` | `Boolean` | whether to delete all existing properties. |\n\nReturn\n\n\n[ScriptProperties](#) --- this object, for chaining\n\nSee also\n\n- [setProperty(key, value)](#setProperty(String,String))\n\n*** ** * ** ***\n\n`set``Property(key, value)` \n\n**Deprecated.** This function is deprecated and should not be used in new scripts.\n\nPersists the specified in value with the provided key. Any existing value associated with this\nkey will be overwritten.\n\n```javascript\nScriptProperties.setProperty('special', 'sauce');\n```\n\nParameters\n\n| Name | Type | Description |\n|---------|----------|---------------------------------|\n| `key` | `String` | key for property |\n| `value` | `String` | value to associate with the key |\n\nReturn\n\n\n[ScriptProperties](#) --- this object, for chaining\n\nSee also\n\n- [getProperty(key)](#getProperty(String))"]]