Loop over a list of credentials using an expression

[Loan_J]

What I need

I have a list of credentials that each can access to a different database using the Odoo node. I’m using an expression to select them in the credentials section of the node.

These are the values passed in an expression for the credentials

The expression works, but even if there are X items in the list, the node only uses the first.

The result of the workflow execution. In my list, I had 2 items, but the node only used the first item.

The issue

I can’t manage to loop over those credentials. I tried using an HTTP request, but it just sends the first item of the list when passing them as an expression in credentials.

NOTE

Please do not hesitate to ask for more details/screenshots if my request isn’t clear enough.

Linked topic(s)

• I found this topic from a year ago. The new feature allowing for the use of an expression in the credentials section is exactly what the OP was asking for, and they do have similar needs to me. The issue is that regardless the number of items in the list, it will only use the first.
• “The Variable Selector displays only the first item, but internally n8n will process all the items.” In the case of expressions for credentials, it doesn’t.

[MutedJam]

Hi @Loan_J, this thread has an example on how to handle this situation:

Using expression in the impersonate field of the Google Service Account credential fails

Hi @Maximilien, welcome to the community! Credentials are only loaded once, no matter how many items you’re passing on to the node. So if you want to use different credentials for each item, my suggestion would be to split up your data in batches (with a size of 1 item per batch) using the Split In Batches node. A generic workflow demonstrating the idea would be this one: The credentials contain an expression of {{$json["address"]}}, reading the address field: [image] …

Let me know if you run into any trouble with this approach!

[Loan_J]

Trying that in a few, I’ll come back there if it still doesn’t suit my needs.

[Loan_J]

After trying a solution based on the topic you’ve linked, it still doesn’t seem to work as intended.

[Loan_J]

Bumping the question.

[MutedJam]

Hey @Loan_J, I just tried re-running the example workflow provide earlier in the thread and it still seems to work as expected for me. Can you confirm which error exactly you are seeing?

[Loan_J]

Hey, actually, I just tried again with the same way and it seemed to work.
Thank you!