Let's say I pass in a variable for the first and second variable, I would expect output to be [["2019-11-01","CAT AMER"],["2019-11-01","EMEA CST"], etc.]
The value under data will be dynamic based on the report called and I want to build a callable recipe to support calling any report and pull out the columns specified in a string variable passed in then write to a Google sheet.
That is the full use case.
I am trying leverage a variable in a pluck for a use case where the items plucked will be a parameter passed into a callable recipe. I can't seem to figure out how to get a variable to work in formula mode with the pluck statement. I have created an example recipe to show what I am trying to do: https://www.workato.com/recipes/1037360-pluck-with-variable?st=6c4a57#recipe
The data being passed in the variable will always be enclosed in "", This will be easier in ruby.
Is there a way to make it work without using one?
Send us a ticket, we will try our best to assist you with your problem