MySQL added new column and it cannot be captured in existing 'MySQL - Get a Row'

#1

Hi,
I am using a MySQL connection in a flow, ‘get a row’ (i.e. finding bot user details like return path, Telegram userid and user name, previously saved also using FlowXO).
FlowXO works great and gets all existing the records in such row, which I can use later in filters.

Now, after this flow is working, someone decided to update the MySQL table adding a new column: ‘age’ (let’s say that the age was suddenly important, but not included in the specifications I received). I said myself: no problem, ‘get a row’ will get this new column automatically and I will be able to use ‘age’ as a filter.

I was wrong. The existing ‘get a row’ will never get this new column.
It seems that I need a new ‘get a row’ to be created in my flow, deleting the existing one.
Problem: If I delete it, all later existing filters using the MySQL records in my flow will stop working (red labels appear).

Any idea to avoid this problem? How to update ‘get a row’ with the new structure from MySQL?
(by the way, it happens the same with Google Sheets new columns)
Thank you,

(John Jackson) #2

Unfortunately, we are missing a ‘refresh fields’ feature that would fetch the latest set of columns/fields from MySQL/Google Sheets and other services.

I know this is frustrating :weary:

Hopefully we’ll be able to divert our attention to fixing this in the near future but I’m afraid the only way around this for now is to recreate the action and then fix the filters on the rest of the flow.

#3

:cry:
if we could at least create the new action, and rename it the same… and all the filters on the rest of the flow could work.
In the meanwhile, I learnt: asking for a hundred free columns set at MySQL (just in case :grin:) to be used if necessary.