AnsweredAssumed Answered

How to choose latest invoice attachment send to SFTP?

Question asked by marcin.wawrzyn on Mar 2, 2018
Latest reply on Mar 4, 2018 by leif_jacobsen

Hi everyone.

 

Im new to Boomi so apologize in advance  . I have a problem with process design. Im retrieving invoice attachments from Salesforce which looks like below and then sending them to SFTP. Created process was working fine, in the given sample two attachments would be sent to SFTP. Things got changed and now I need to send just the latest attachment (by CreatedDate). Any ideas how to do it ? Thanks in advance!

 

<Apttus_Billing__Invoice__c>

  <Id>a5I9E0000000G8s1</Id>

  <Name>INV-00001</Name>

  <CreatedDate>2018-03-01T06:10:14.000Z</CreatedDate>

  <Apttus_Billing__Status__c>Approved</Apttus_Billing__Status__c>

  <Sent_to_Customer__c>No</Sent_to_Customer__c>

  <Attachments>

    <Attachment>

      <Id>00P9E000003NCE1</Id>

      <CreatedDate>2018-03-01T06:10:46.000Z</CreatedDate>

    </Attachment>

    <Attachment>

      <Id>00P9E000003NCF1</Id>

      <CreatedDate>2018-03-01T06:20:01.000Z</CreatedDate>

    </Attachment>

  </Attachments>

  <Apttus_Billing__BillToAccountId__r>

    <Physical_Invoice__c>true</Physical_Invoice__c>

  </Apttus_Billing__BillToAccountId__r>

</Apttus_Billing__Invoice__c>

Outcomes