Google Apps脚本PropertiesService-被不可靠的执行日志记录和&编辑器调试

问题描述：

我发现 PropertiesService 不可靠，但是可能我只是不熟悉Google Apps脚本或Stackdriver，并在这里犯了错误或假定有可能导致问题的原因.

I find PropertiesService to be unreliable, but probably I'm just not familiar with Google Apps Script or Stackdriver and made a mistake or assumed something here that may caused the problem.

这是脚本:

sp = PropertiesService.getScriptProperties()
sp.setProperties({
  'somekey': 'value'
})
props = sp.getProperties()

console.log(props.toString())

这是我写这个SO问题之前的日志:

And here's the logs before I wrote this SO question:

Type     Start Time                 Duration  Status     Stackdriver Log
Trigger  Oct 9, 2020, 11:19:07 PM   0.541 s   Completed  Debug [object Object]
Editor   Oct 9, 2020, 11:11:43 PM   0 s       Unknown    Debug [object Object]
Editor   Oct 9, 2020, 11:08:09 PM   0 s       Unknown    Debug [object Object], ScriptProperties
Editor   Oct 9, 2020, 11:05:16 PM   0 s       Unknown    Debug [object Object], ScriptProperties

标记为 Editor 类型的是从应用脚本Web IDE进行的手动调试，我每15分钟设置一次 onTrigger ，然后再添加这些 PropertiesServices 线.每当我在每次执行中检查 Execution 日志页面时，都需要几分钟的时间来获取日志结果，而现在，在未来半个多小时的时间里，我会重新检查，而那些 Unknown状态日志标记为 Completed ，且所有记录均在0.5s之内.

The one marked as Editor type is manual debug runs from apps script web IDE, I set onTrigger every 15mins before I added those PropertiesServices lines. Whenever I check the Execution log page in each execution, it takes minutes to get the log result, and just now, more than half an hour in the future, I re-checked and those Unknown status logs are marked Completed and all under 0.5s.

这只是一个小故障吗?如果这不正常或我做出了错误/错误的假设，我应该怎么做才能确保我不会遇到这种不可预测的结果?

Is this just a glitch? If it's not normal or I made a mistake/wrong assumption, what am I supposed to do to ensure I don't experience this kind of unpredictable results?

为什么我不能从 props 键值对中获得字符串?

Why don't I get strings from the props key value pair?

答

为了获得相对更好和可靠的日志记录，请直接使用Stackdriver(即View> Stackdriver日志记录)，而不要从执行"菜单中使用.仪表板中的页面.为此，您需要将Google云项目从默认设置切换为标准，方法是在参考资料>中设置自定义项目编号云平台项目>更改项目.
- For relatively better and reliable logging, Use Stackdriver directly(i.e., View> Stackdriver logging) rather than from the "executions" page in the dashboard. To do this, you need to switch Google cloud project from default to standard by setting a custom project number in Resources > Cloud Platform project > Change project.
  
  记录对象时，必须始终对对象进行 JSON.stringify ，然后再将其提供给 console . props.toString()将仅返回 [object Object] ，因为它是内部结构.
  
  When logging objects, You must always JSON.stringify the object before feeding it to console. props.toString() will only return [object Object] as that is it's internal structure.
```
/*<ignore>*/console.config({maximize:true,timeStamps:false,autoScroll:false});/*</ignore>*/
const props = {a:1};
console.log(props.toString());//[object Object]
console.log(JSON.stringify(props));//{"a":1}
```
```
    <script src="https://gh-canon.github.io/stack-snippet-console/console.min.js"></script>
```

Google Apps脚本PropertiesService-被不可靠的执行日志记录和&编辑器调试

相关推荐