Hi,
I am trying to integrate Smartsheet and QuickBase. To start, I am working on the "When any sheet is updated" trigger. When trying to call values from Smartsheet that have been updated, I get the following error messages when I use these two tactics:
1. first(skip(triggerBody()?['cells'],24))?['value']
Error Message: "Unable to process template language expressions in action 'HTTP' inputs at line '1' and column '7752': 'The template language function 'skip' expects its first parameter 'collection' to be an array or a string. The provided value is of type 'Null'."
2. triggerOutputs()?['body/cells'][24]['value']
Error Message: "Unable to process template language expressions in action 'HTTP' inputs at line '1' and column '7752': 'The template language expression 'triggerOutputs()?['body/cells'][24]['value']' cannot be evaluated because property '24' cannot be selected."
These expressions have worked for me for the "When a new row is added" trigger, but I keep getting errors for when the sheet is modified. In addition, I have tried multiple variations, including, writing out the column name instead of just 24, switching ['body/cells'] to just ['cells'], taking out ['value'], and taking out ['body/cells'].
I appreciate any guidance!

Report
All responses (
Answers (