I have a 500,000 row update every night via ETL using a PHP script. All records in all files that I work with they have a "Territory" field.
The territories are 100 thru 199.
In Teams module I have created a Team for each Territory (100-199)
In the Teams module, I have set each team "id" to the territory. So id="122", not a generated GUI.
In the Team Set module, I have set each team set "id" to the territory. So id="122", not a generated GUI.
In the "team_team_sets" relationship I have a relationship for each Territory, "team<>team_set", where id's are "122<>122".
Here is example of update "Account Module" from the nightly ERP csv file. We use a REST call to the Accounts API endpoint while processing each csv record.
When I call the Accounts API endpoint, I want to set the team to "122" and the team_set to "122" and have it automatically set the Account record to Team "122" and Team Set "122", but something is not going right and I am missing something.
Is there another relationship join table that I need to update, or can it be this easy?