topic Re: Salesforce Row count in Talend Studio

Salesforce Row count

Parikhharshal — Sat, 16 Nov 2024 07:39:25 GMT

Hi Talend Experts

I need your help please.

I am trying to get row count from TSalesforceInput component (where I have simple query like SELECT Id from TableA) and trying to capture using NB_LINE. The code for NB_Line is written in JAVA3 component

System.out.println(((Integer)globalMap.get("tSalesforceInput_2_NB_LINE")));

but instead of showing me total counts...... it prints Null ....Null...... My flow is simply like below:

What do I do to get row counts so that I can compare with target counts too?

Re: Salesforce Row count

TRF — Fri, 14 Sep 2018 06:19:38 GMT

The behaviour is normal as tJavaRow is executed for each row of the flow while NB_LINE is an "after" variable (populated when corresponding component terminate).
Add a tJava connected to your tSalesforceInput by an onSubjobOK trigger and move your println in this component.

Re: Salesforce Row count

Parikhharshal — Fri, 14 Sep 2018 06:25:22 GMT

Hi TRF

Thanks a lot for your reply. I cannot seem to create onSubJobOK or ComponentOK from Salesforce component to Tjava. May it is not possible?

Thanks
Harshal.

Re: Salesforce Row count

TRF — Fri, 14 Sep 2018 06:27:58 GMT

Sure it is.
Verify the component is a tJava, not a tJavaRow.

Re: Salesforce Row count

Parikhharshal — Fri, 14 Sep 2018 06:32:42 GMT

Aah...Bugger off....I was using Tjavarow component.

This brings me to another ques. What's difference between Tajavarow and Tjava?

Re: Salesforce Row count

TRF — Fri, 14 Sep 2018 06:34:59 GMT

Thank's to mark your case as Solved.
See this link for differences between tJava components https://community.talend.com/t5/Design-and-Development/What-is-the-difference-between-tJava-tJavaRow-and-tJavaFlex/ta-p/21505

Re: Salesforce Row count

Parikhharshal — Fri, 14 Sep 2018 06:36:19 GMT

As soon as I changed it to Tjava it gives me an error at salesforce component for some reason.

org.talend.components cannot be resolved to a type. Any idea?

Re: Salesforce Row count

TRF — Fri, 14 Sep 2018 06:38:42 GMT

Share the new design

Re: Salesforce Row count

Parikhharshal — Fri, 14 Sep 2018 06:39:42 GMT

Re: Salesforce Row count

TRF — Fri, 14 Sep 2018 06:43:12 GMT

Share also tJava code and remove tLogRow (or connect it to tSalesforceInput)

Re: Salesforce Row count

Parikhharshal — Fri, 14 Sep 2018 06:44:57 GMT

System.out.println(((Integer)globalMap.get("tSalesforceInput_2_NB_LINE"))); -> tJava code. I do not need to put back into Tsalesforceinput.

Re: Salesforce Row count

TRF — Fri, 14 Sep 2018 06:52:37 GMT

At the design level, this job is clean.
Can't figure out the reason of the error you get.
I suggest you to restart with à new job
You may also click on the Code tab to find the compilation error in the Java generated code but it seems strange.

Re: Salesforce Row count

TRF — Fri, 14 Sep 2018 08:44:23 GMT

Your job should look like this one:

It compiles and works fine.