topic Re: Issue - Dynamic schema in tSalesforceOutput in Talend Studio

Issue - Dynamic schema in tSalesforceOutput

Ritz05 — Fri, 15 Nov 2024 21:37:22 GMT

Hi Team,

I am trying to use Dynamic type in schema for component tSalesforceOutput to process data in next component but getting External ID field issue. Although I have already included that primary column which is marked in salesforce object.

Is it not allowed to use

Dynamic type in schema for component tSalesforceOutput?

Thanks,

Rita

Re: Issue - Dynamic schema in tSalesforceOutput

Anonymous — Thu, 06 Jul 2023 04:13:08 GMT

Hello,

Could you please clarify in which Talend version/edition you are?

We did a sample test at our end and can see dynamic schema working as expected in 7.3.1.

Would you mind posting your sample job design/work flow screenshots on community which will be helpful for us to address your issue?

Best regards

Sabrina

Re: Issue - Dynamic schema in tSalesforceOutput

Ritz05 — Thu, 06 Jul 2023 05:38:34 GMT

Hi Sabrina,

Thanks for reply for the issue. I am using Talend cloud Data Febric 8 studio version.Below are the simple flow to load data in salesforce using dynamic schema.

snowflake input:

(String)globalMap.get("SRC_CONFIG_SQL2") : Below query

SELECT "Study_external_ID__c" as Study_external_ID__c, “B”, as B,”C” as C FROM VW_test where " B "='RDEV11761818';

Salesforce Output:

ere contxct variable Primkey holds key column "Study_external_ID__c" for salesforce object "campaign". But getting below error:

Thanks,

Rita

Re: Issue - Dynamic schema in tSalesforceOutput

Ritz05 — Thu, 06 Jul 2023 05:39:14 GMT

Hi Sabrina,

Thanks for reply for the issue. I am using Talend cloud Data Febric 8 studio version.Below are the simple flow to load data in salesforce using dynamic schema.

snowflake input:

(String)globalMap.get("SRC_CONFIG_SQL2") : Below query

SELECT "Study_external_ID__c" as Study_external_ID__c, “B”, as B,”C” as C FROM VW_test where " B "='RDEV11761818';

Salesforce Output:

ere contxct variable Primkey holds key column "Study_external_ID__c" for salesforce object "campaign". But getting below error:

Thanks,

Rita

Re: Issue - Dynamic schema in tSalesforceOutput

Anonymous — Fri, 07 Jul 2023 03:45:46 GMT

Hello,

It looks like a salesforce upsert problem. Is your data loaded successfully without using dynamic schema?

Please make sure that the schema for the salesforce object included fields that are mapped for the upsert operation. If not, you could delete the unused fields using the tMap component to make the upsert working.

Best regards

Sabrina