mySQL credentials expression does not loop through all values

[MutedJam]

Hi @aljaz86, iirc credentials are only loaded once, even if you have multiple items. So to change your credentials used for each item you would need to split the data into batches of 1 and then loop through them, similar to what I have described over here:

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] …

Hope this helps! Let me know if you run into any trouble with this.