How to use 'IN' keyword in tSalesforceInput

udotheman — Sat, 16 Nov 2024 03:06:56 GMT

Hi guys,

I have the following scenario:

fFileInputDelimiter -> tHashOutput

fFileInputDelimiter

id,external_key,name
123,foo123,bar
456,foo456,rab
789,foo789,abc

All of these information I would like to have for later use in the tHashOutput. (Works)

Know I want to have a tSalesforceInput with a query like:

Select id from Account where external_key__c IN (<2nd column of the tFileInputDelmiter>)

So this is a list of Ids and I have no idea how to put them into a list, globalVar or similar in order to use them in my tSalesforceInput.

The query must have the following format:

Select id from Account where external_key__c IN ('foo123','foo456','foo789')

What is the best way to accomplish this?

Best Regards,

udo

Re: How to use 'IN' keyword in tSalesforceInput

TRF — Tue, 03 Mar 2020 11:33:50 GMT

Connect your tFileInputDelimited to a tJavaFlex like this one:

Now you can use the global variable (here nammed OBSIds) to build the IN clause:

"SELECT blablabla 
FROM yourObject
WHERE blablabla IN (" + (String)globalMap.get("OBSIds") + ")"