SalesForce Reference Fields - Best Practices (1 reply)
Randy, it depends:
- If you are updating/inserting a large number of objects and there are a small number of reference objects (such as packs) we recommend you store the id's either against the source record or within IMan.
You could do a GET request to obtain the values and then store as necessary.
- If there are a small number of objects then you can perform a lookup. Please note the values are not cached, so every lookup will invoke a request to Salesforce.
Thanks
We’re working with a client on a SalesForce integration and I had a quick question on getting started.
Our client is selling Items that come in different sizes, let’s say EACH, PACK, and CASE. They represent the size in Sage via an Optional Field “SIZE”. The SalesForce connector requires that the SalesForce Object ID be passed when attempting to set this field.
Is the best way to handle this mapping simply to create a local mapping table in SQL? Secondly, how do you recommend to populate this table? Is the SalesForce Reader a good/possible solution?