Metabase node returns just the first row of the question

Questions
1

Hello everyone!
I want to use n8n to extract data from a metabase question.
I used Metabase node
resource=question
operation=result data
question id= “metabase question id”
format=jason

it works properly, but returns just the first row of the question results. how can I get the full result?

2

Hey @Davod_Ebrahimi,

Welcome to the community :raised_hands:

Can you complete the template so we can see more about your environment and the workflow that you are using?

3

sorry I thought I have pasted everything:

my workflow:

Output:

[

{

"month":9,

"CR Ratio":0.40831400218089986

}

]

my expected output should have 9 rows (month from 1 to 9), but I just see the last row

  • n8n version: 0.212.0
  • Database you’re using: SQLite
  • Running n8n with the execution process: own
  • Running n8n via Docker
4

Hey @Davod_Ebrahimi,

I have to ask, are you sure there is more one result that would come out of Metabase? How many results are you expecting?

5

as I said, there are 9 rows.
I tested it on many questions in two different metabase servers. every time I see just one row

6

Ah yeah I missed that bit, I am not sure what is going on there typically we would just return what Metabase gives us.

I will see if I can find a test Metabase instance to play with next week and see if I can reproduce it.

1 Like
7

Thank you, I wait :slight_smile:

1 Like
8

Hello, I am experiencing the same problem, it just returns the first row of the question.

1 Like
9

I have created an internal ticket for this which we will be tracking as node-246 no updates on this yet as I have not had a chance to dig out a metabase instance to test.

1 Like
10

Hello, is there any news about this problem?

11

Not yet it is in our internal tracker waiting for someone to pick it up when they have a chance.

1 Like
13

Do we have any news on this subject? I have the same error, the metabase node only returns the first result.

1 Like
14

Hey @John_Kennedy,

I have access to a Metabase instance just need to set aside some time to test it. Will try and get to it in the morning.

15

image
image1883×654 42.4 KB

testing here the possible error occurs only when the format is json.
This print should have 10 results, but only show the first result

16

It is not limited to json. CSV format has the same problem

17

Afternoon,

I have managed to reproduce this so I will get this fixed tomorrow.

18

Hi There,

So quick update on this one, I have popped in the PR below which has resolved this locally. If anyone wants to test it let me know and I can create a docker image for it

image
image1295×835 118 KB

3 Likes
19

I would like to test it, can you create a docker image?

20

Give it about 30 minutes and n8nio/n8n:PR-5665-node-246 should be ready to go.

1 Like
21

Hi @Jon,
That looks to be working just fine with me!
Thanks for your work!

2 Likes