Add mapping validation

[codingjoe]

Hi,

currently when you import a new mapping, there is not way to know if it will actually work or not. The mapping will always be accepted and eventually your connection state will switch to error.

That behavior makes deployments ever so more risky. Therefore I would suggest to add a new command, something like connect:validate FILE to send a file via API and wait for a response if the mapping could be successfully applied based on the connected Salesforce instance.

I am aware that there are certain limitations that can not easily be overcome, due to the Salesforce API. But the Heroku Connect interface has a fairly good understanding of the Object and fields structure of the salesforce instance. It is also aware of certain constrains and even displays warnings.

I would assume that this information could be made accessible via the API. But I would suggest to keep it simple. Any kind of validation is better then none. This would be our priority list:

1. Objects and Fields exist
2. Required fields are in the mapping
3. Required indexes are added
4. Polling is not available

I hope that helps a bit, we would certainly appreciate such a feature. We could build the plugin part, but you guys need to provide the API.

Best -Joe

[sigmavirus24]

Thanks for this @codingjoe. I'm going to pass this along to the appropriate folks to be considered. 🎉