I am syncing multiple tenants in Pipedrive into a single set of tables in my SQL database.
I am not sure that the primary keys are unique across tenants.
As such, I would like to append a hard-coded field to the target database table to know which company tenant it was from.
E.g., in Actitivity, hard-code a "TenantID = 1" and put that into the SQL DB with each record synced.
Is there anyway to do that?