Populate items from mirrored board via API

Hi there,

we want to create and maintain a registry of portfolios that we’re using (see image below). These need to be linked to the correct accounts. My question is whether we’re able to fill in the linked column via api and if there’s an example query, preferably in python.

Provided, we have the necessary IDs to know which portfolio belongs to which account already

Hi. Does it have to be a connected board type? VLOOKUP app - an alternative to connect board might help here