Noobie help

Questions
1

Hi everyone,

n8n noob here, but I’ve come from a background in Make.
As an output, I want to output to a Snowflake database a list of keywords and rankings scraped from a ranking software we use called Accuranker.
Accuranker stores it’s data as a keywords which each have an id, within a domain, which also has an ID.
To get the keywords with our account, we need to first get a list of domain ids to use within the 2nd api call where we get the keywords associated with that domain.

Stages to get there

  1. Do an API call to get 5 domains (which are ids)
  2. Split out (using splitout) each of the domain ids from this list
  3. use each of these ‘domain ids’ to do the 2nd API call to collect 10 keywords from within the 2nd api call.
  4. store each keyword within a database (at the moment, a Google Sheet)

I’m however stuck at the 2nd ID.
I can see that processing the first gives me a few ids (as a single item, I’ve limited this to 5 domains for now), and the split out gives me 5 items, but on the 2nd HTTP request, when I pass that url back in I can only see 5 keywords.

Any ideas?

2

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:
3

not sure what you need but there is this cool loop node so you can process outputs one by one. so it is easier to debug and see what is going on . you will see input/output for each loop on nodes.

so use loop after split and do 5 loops

5

hello @Edmunds_Priede

I suppose the 2nd request node return keywords as s single item (the same way it does in the first request). Try to set the second Split Out node

6

Hi both,
So, this has evolved as I’ve been playing.

I’ve managed to get it working by first splitting out the accounts, then running the API for each account, 1 at a time, getting the keywords, splitting them out, filtering for any null value keywords, formatting the date, then setting field values.
The part I’m missing though is the last step, storing the data in Snowflake.

I did have it so that it stored each keyword in the database one at a time.
But that seemed to take for ever, so I’ve had a better idea of combining all the keywords together, and storing in a single large insert query.

  1. is this possible?
  2. how do I go about making this query?