Query api multiple times from results on input table

Evening All.

I have an input table linked to a Get API call.
The api url requirements is that you call each particular element you want to see individually.

for example
https://myapi.com/assignments/ID-GOES-HERE

My input has a table with 5 rows

one of the columns is “ReferenceNumber” and contains the value of the ID’s
In this case there are 5.

Now when i add the json.referencenumber to the end of the api url as needed i can see the result showing the the correct value of the item in the first row of the table.
image

However when i execute the node it only queries the api for the data assigned to the referencenumber of the first row on the input table.
Is there a way to have it continue to query the api for each row on the input table so that the out put contains the results of the 5 queries?

image

I have no other query parameters set.
Header and body are also disabled.
I have no options enabled either.

Information on your n8n setup

  • n8n version: 1.15.2
  • Running n8n via (Docker,on prem):
    -Database - Default

Thanks

It looks like your topic is missing some important information. Could you provide the following if applicable.

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

Just a small bump.

Cheers

Found it

Setting on the node to execute only once!!

2 Likes

Hi @Petero :wave: We always aim to answer questions as quickly as we can, and we try to go in order of the posting on the forums :bowing_man: So glad you found that setting and posted what fixed it for you!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.