Hoping to find anyone that can help me figure out the last little thing keeping me from finishing this Smartsheet custom connector. Since the official connector is not available in our environment, i made one that will create, delete, get, update, and reset a webhook and also getsheet, getrow, addrow, listcolumns, and updaterow for Smartsheet. Everything works perfectly… except addrow.
When i use addrow in a flow, it only adds blank rows to the sheet. When i go to the custom connector test tab and try it, it works properly. I think its right here where my problem is and someone who knows what they are doing might be able to spot it. This screenshot is from the flow logbook showing the raw inputs for the addrow action. If i copy only the highlighted portion and paste it on the custom connector test, it works.
