MySQL not outputting actual data

Questions
1

I am running the MySQL but it just outputs “success” and not the actual result of the query. What am I doing wrong?

Please see image below

Screenshot 2023-07-27 at 19.53.50
Screenshot 2023-07-27 at 19.53.501149×670 42.4 KB

Thanks

3

When i dont include a “variable” then it works fine, see below

Screenshot 2023-07-27 at 23.28.35
Screenshot 2023-07-27 at 23.28.35368×284 17.4 KB

4

Hi @JakeS :wave: Welcome to the community :tada:

Do you have an example workflow you could share that has test data that wouldn’t require any outside credentials for testing? Essentially we’d need some test data that replicates this case. If you could provide test data in JSON format, that works too!

Can you also fill out the following:

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
5

@EmeraldHerald I fixed the issue, basically the query was returning 0 results but it wasn’t clear in the UI as it just said Success. Would be good to see how many results are returned, that would have helped avoid confusion on what the message meant