I have a bot that iterates over a table looking for blank values in column <out_time> and then parses my email with a filter query via appscripts and returns a result as a number. It then passes that result as a new value for <out_time> in that row. It is not working as intended as the values in the database are not being updated, though I can see the logs of the appscript function show that the number is found and returned successfully. In the Monitor, there it shows null values for step input/output…though clearly the appscript function is receiving the correct input.
Monitor Print =>
Name
search for null out times
Created TimeStamp
12/28/2023 6:15:05 PM
Data
{ “Row ID”: “1aHeusDQ-D4MM5eWmJztB8”, “show”: “Jgpyc8eX9G01hStC1cAlab”, “show_position”: “XEIN7ns5kR4lTlita3ljbF”, “in_time”: “800”, “out_time”: “”, “date”: “12/28/2023”, “timestamp”: “12/28/2023 17:49:10”, “uuid”: “77f11abc-ff2a-4b42-bc1d-9c4ae0ec3bc2” }
Step 1 =>
1
Name
Input
Created TimeStamp
12/28/2023 6:15:05 PM
Output data
{ “Row ID”: null, “show”: null, “show_position”: null, “in_time”: null, “out_time”: null, “date”: null, “timestamp”: null, “uuid”: null, “xxx”: null }
Step 2 =>
Name
parse email for out time value
Created TimeStamp
12/28/2023 6:15:10 PM
Output data
{ “Row ID”: null, “show”: null, “show_position”: null, “in_time”: null, “out_time”: null, “date”: null, “timestamp”: null, “uuid”: null, “xxx”: null }
{“Success”:true,“ReturnValue”:“{ "stringValue": "" }”,“Task Type”:“AppsScript”,“Task Name”:“Task for parse email for out time value”,“ScriptId”:“18zW5_-MjkY9uNauEMuk4OmPhR7B__IZBrjaYbEgzb7TDMI3xoBj8oXka”,“FunctionName”:“getTimeFromEmailBody”,“FunctionArguments”:“{ "stringValue": "77f11abc-ff2a-4b42-bc1d-9c4ae0ec3bc2" },{ "stringValue": "(PII Removed by Staff)" },{ "stringValue": "OUT" }”}
Step 3 =>
Name
update out time value
Created TimeStamp
12/28/2023 6:15:11 PM
Output data
{ “Row ID”: null, “show”: null, “show_position”: null, “in_time”: null, “out_time”: null, “date”: null, “timestamp”: null, “uuid”: null, “xxx”: null }