Combining JSON results and writing to Supabase

Describe the problem/error/question

Hi Everyone,

I’m trying to create a flow that will fetch Opsgenie alarms via REST API and write them to the alarms table in Supabase. When fetching alarms with the Opsgenie REST API, it has a limit of 100 alarms maximum. When I make the query, I get the first 100 alarms, and to fetch the remaining alarms, I need to use the paging structure in the returned JSON to get the next URL and make HTTP queries to other pages and combine the results. The problem is that although I see 285 items as the output run result in Code2, only the 85 items from the first round are processed. It can’t write all alarms to the database. Can you help me figure out where I’m making a mistake?

image

What is the error message (if any)?

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

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

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