I have a bot that iterates over a table <shifts> 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
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 =>
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
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 =>
Output data
{ "Row ID": null, "show": null, "show_position": null, "in_time": null, "out_time": null, "date": null, "timestamp": null, "uuid": null, "xxx": null }
LinkedIn
Twitter
