topic Re: Salesforce Source Endpoint in Qlik Replicate

Salesforce Source Endpoint

brentadonis — Wed, 03 Apr 2024 14:38:03 GMT

Is there a way to replicate a Salesforce object like FeedTrackedChanges ?

It’s an object that a user is not able to query directly using SOQL, you have to query to parent table first like in my screenshot

Because of this (I think), the FeedTrackedChanges table is not visible to me as a table I’m unable to select it in #Replicate.I’m wondering if it’s the case that these types simply aren’t supported and if so is there a work around?

Re: Salesforce Source Endpoint

john_wang — Thu, 04 Apr 2024 02:31:12 GMT

Hello @brentadonis ,

Thanks for reaching out to Qlik Community!

You are right. The FeedTrackedChanges table is special object in Salesforce, it represents an individual field change or set of field changes of a parent record feed, although this object is query-able however we cannot query this object directly. That lead the table is not visible in Qlik Replicate (in both task design stage and runtime stage).

The below options are not applicable to salesforce source endpoint:

Fullload Passthru Filter
The source_lookup Data Enrichment function is not supported

I'm not sure if stored procedures and/or custom object can solve the Child-to-parent or Parent-to-child query. Looks to me there is not a good approach yet. Anyway, if you like you might raise Feature Request in Qlik Ideation.

Hope this helps.

John.

Re: Salesforce Source Endpoint

brentadonis — Thu, 04 Apr 2024 12:57:41 GMT

Thank you John!

I will explore your suggestions.