topic Re: How the Salesforce fields being selected in Qlik replicate? in Qlik Replicate

How the Salesforce fields being selected in Qlik replicate?

Bing_lian — Mon, 27 Jun 2022 06:50:17 GMT

Hi,

I am testing the Qlik replicate integration with Salesforce data.

Both of Qlik Bulk API and SOAP API builds are successful, but both of them are not returnning me all fileds.

For example, it is missing "Name" filed in Account table.

I used the same user to call Rese API and it do return the field. It proves it is not a permission issue.

Could you please get me know how the fileds are being selected when i use Qlik replicated to load salesforce data? So I can understand why some of the fields are missing.

Thank you

Re: How the Salesforce fields being selected in Qlik replicate?

OritA — Mon, 27 Jun 2022 07:07:08 GMT

Hi,

In general, in the Replicate user guide you can find the list of the SalesForce supported data types under the following link:
https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/Salesforce-Incremental/salesforce_incremental_db_data_types_target.htm

Under the SalesForce endpoint advanced tab, does the option 'Use labels for column names' is checked? If so, please make sure you are using the column label and not the column name.

If you still face a problem please open a case with the details so we can further troubleshoot.

Thanks & regards,

Orit

Re: How the Salesforce fields being selected in Qlik replicate?

Bing_lian — Mon, 27 Jun 2022 23:53:07 GMT

Hi,

I tried the option but it is not helping.

I raised a support ticket.

Re: How the Salesforce fields being selected in Qlik replicate?

john_wang — Mon, 04 Jul 2022 04:39:31 GMT

Hello @Bing_lian ,

Per our conversation the final solution of the issue is (support case #00042698)

I approved i can get all required fields after i had admin rights in salesforce. So it seems a salesforce permission issue.

if you get any detailed information please update us. it's helpful for others.

copy @OritA

Regards,

John.

Re: How the Salesforce fields being selected in Qlik replicate?

Bing_lian — Thu, 14 Jul 2022 00:01:23 GMT

Hi @john_wang

I also find click the pull encypted fields will bring the requried data.

Interesting those fields will dispaly when we call API directly.

Thank you