SFDC to SFDC Integration - Import - External ID not available on Upsert/Insert Operation

  • 62Views
  • Last Post 25 May 2017
  • Topic Is Solved
0
votes
Fred posted this 24 May 2017

I'm trying to upsert a record from salesforce org 1 (source) to salesforce org 2 (target). I have an External ID field on the target object but I am unable to "see" it on the Target Definition page (with Upsert selected). I am also unable to insert a value to it, as I can't see it on source to target mapping section either. I have hit the Refresh button, presumably which pulls in the most recent metadata but that isn't doing the trick either.

Thanks!

Order By: Standard | Newest | Votes
0
votes
Fred posted this 24 May 2017

Fixed - I had to clone the connection, then apply that connection to the existing package, then the External Id field was exposed. Perhaps refresh is not intended for that purpose of refreshing metadata and/or this is just a bug. 

0
votes
Mariia Zaharova posted this 25 May 2017

By default, Skyvia caches metadata of available objects for cloud sources. Please refer to:

https://skyvia.com/resources/docs/index.html?salesforce_connections.htm

After making any schema changes (for example, adding new object or new field), it is necessary to refresh metadata for the used connection. For this, you can open your Salesforce connection and click the Clear link for "Metadata Cache" parameter.

Close