Merge data into child array then upsert

📜 This job is an official example from OpenFn.

Metadata

• Name: Merge data into child array then upsert
• Adaptor: @openfn/language-salesforce
• Adaptor Version: latest
• Created date unknown
• Updated date unknown
• Score: 100 (an indicator of how useful this job may be)

Key Functions

dataPath, dataValue, each, field, fields, merge, relationship, upsert

Expression

each(
  merge(
    dataPath('form.ID_cards_given_to_vendor[*]'),
    fields(
      field('Vendor_Id', dataValue('form.ID_vendor')),
      field('form_finished_time', dataValue('form.meta.timeEnd'))
    )
  ),
  upsert(
    'Small_Packet__c',
    'sp_id__c',
    fields(
      field('sp_id__c', dataValue('ID_cards_given_to_vendor')),
      relationship('Vendor__r', 'Badge_Code__c', dataValue('Vendor_Id')),
      field(
        'Small_Packet_Distribution_Date__c',
        dataValue('form_finished_time')
      )
    )
  )
);