Dilemma on the best way to work with SF

Help Activities
, ,
6

Hi @liranl

I dont have a xaml but i can give you more details in steps

  1. Read the policy id from excel
  2. String.join(“‘,’“,”Dt.select(function(c) c(“policy no”).tostring).ToArray) and this will give you a string of policy numbers concatenated with single quotes store it in a variable say str which is used in next step
  3. Fire a soql select policyno,ID from table where policyno IN (“‘“ + str + “‘“) include any extra braces or inverted comma needed this will give you all id’s at once. my assumption is you are trying to get from the same object if objects are different then query changes accordingly
  4. Now pass the output datatable to the io_transactiondata and change your trans item to datarow and add both policy no and id to the queue

Rest follow the performer

Cheers