I know there was a post out here for something like this already (maybe even submitted or commented by me), but a cursory search yielded nothing.
The problem:
When a change is made to a Salesforce picklist value, 9 times out of 10 the admin changes the LABEL and not the API Name.
The impact:
The sync job doesn’t automatically fail because the API Name in Gainsight still matches the Dropdown Value in Gainsight. However, when I change the Dropdown Value in Gainsight (so that it’s the “right” value from the business perspective) I can no longer sync that field via Connectors because it will fail on a mismatch between the modified GS Dropdown value and the SF API Name.
This forces me to have to create a custom rule with case statements (because the SFDC Value shows as text but GS Value shows as ID) and run it every 2 hours just to be able to sync changes to the picklist.
This is a terribly inefficient model. There’s got to be a way to address it on the product side, and I’m not talking about crazy workaround solutions such as API or Rules/DD case statements, or even trying to coach IT that changing the label but not the API name isn’t a best practice (that’s literally the only way to change field names in GS, w/o changing the API so….). If a change like this happens in Salesforce, we should be able to map it in the SF Connector and walk away.
Make our jobs easier not harder please.