AnsweredAssumed Answered

Setting the team and team_set_id directly from PHP import script

Question asked by Michael Joyner on Feb 7, 2017
Latest reply on Feb 7, 2017 by Michael Joyner

Angel Magana Jeff Bickart

 

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?

Outcomes