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
Do an API call to get 5 domains (which are ids)
Split out (using splitout) each of the domain ids from this list
use each of these ‘domain ids’ to do the 2nd API call to collect 10 keywords from within the 2nd api call.
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.
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.
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.