Dynamically Search Smartsheet Columns for Keyword

[Skinnamirink]

Hello all!

I am having difficulty finding any information on if this is even possible, so I wanted to reach out to see if anyone here has encountered a similar problem or knows of a solution.

I'd like to write an automation that dynamically looks into a Smartsheet and pulls information from cells where there is a designated keyword in the Smartsheet column title.  For instance--if I am trying to pull into a list cells that fall under all columns titled including the word "Note", is that possible?  If a Smartsheet user were to go in and add an additional column that was titled with that keyword, is there a way that the automation could dynamically find that without me re-writing the recipe to point it at that specific column?

I am working to automate a process out of Smartsheet via Workato, but there is a chance that users could go in after the recipe is live and add columns that we want to capture--but I'd love to do that without re-writing the recipe constantly. Is there any way to accomplish this?

Thank you for any and all help! 

[1dheeraj2]

Hi @Skinnamirink ,

I worked on something similar. What I did was first fetch columns from A:AZ (or whichever range you prefer based on future use) using a custom API call. I then passed the response to a Python connector and put all the logic into the Python connector to handle column name matching, etc. Python will give you the output, and based on what you plan to do with that column values, you can change your Python output dynamically as well.

Let us know which method worked for you.