Does Google App Script PropertiesService support serialized data or arrays? -
i'm trying pass serialized data, or array, through propertiesservice
, in order build dynamic table in docs. i'm thinking of like:
var properties = propertiesservice.getdocumentproperties(); var orderlist = properties.getproperty("orders"); // iterate through orderlist add rows table columns description, amount , price.
is possible, or should fall work indexes , string-manipulation key names like:
var rowcount = properties.getproperty("row_count") // for-loop till rowcount var itemdesc = property.getproperty("item_" + + "_description") var itemprice = property.getproperty("item_" + + "_price")
both methods work. there quotas may limit either approach.
if serialize array , save orders property have make sure stays under 9kb limit per value.
if make property each line item need stay under 500k read/writes per day. number going changing in near flexible quota system.
https://developers.google.com/apps-script/guides/services/quotas
https://developers.google.com/apps-script/guides/services/quotas#flexible_quotas_early_access
Comments
Post a Comment