Solved

Salesforce Custom Address Fields Requirements and Limitations

  • 7 November 2023
  • 1 reply
  • 42 views

Badge

Hi,

We have a client who is interested in using the new Salesforce custom address fields. (https://help.salesforce.com/s/articleView?id=sf.fields_caf_requirements.htm&type=5) .

 

Because it looks like data can only be imported using Bulk Api 2.0 does anyone know if DBAmp can support import into these new fields? 

Thanks!

Eve

icon

Best answer by Dani Moran 10 November 2023, 19:56

View original

1 reply

Userlevel 4
Badge

I know I responded over email, but so that other folks can see in they have the same question: DBAmp can indeed interact with those fields!

It can query them on the linked server, they can be brought down with SF_Mirror/SF_Replicate/SF_Refresh, and they can be pushed up to Salesforce using SF_TableLoader.

I did note that BulkAPI restriction in the docs, but that doesn't seem to be relevant here - I tested uploading and downloading using both SOAP and BulkAPI v1 and it worked fine, and BulkAPI v2 worked fine on downloads as well. Updating via queries worked fine as well, though we generally recommend using the stored procedures for that!

Reply