I have data in a SQL view as such:
My goal is just to pull the whole role row and store the data in a token.
Here is my custom query that I am testing:
SELECT * FROM [CFR].[contacts].[members] WHERE [Last Name]='Bamberger'
When I see what info is in the tokens, the part I redacted above doesn't show up below in "id". Why would the workflow only pull part of the data? The only thing I can think of is that there is a space on the column name, but the column of Bamberger is "Last Name", so that doesn't seem like that could be it.