Insert Records into Salesforce Object

On this Page

Scenario

I want to insert records into the Salesforce object through SnapLogic. 

Requirements

Snaps Used

For this scenario, the following Snaps are used:

  • File Read
  • JSON Parser
  • Mapper
  • Salesforce Create
  • (Optional) JSON Formatter
  • (Optional) File Writer

Other Requirements

  • A Salesforce account configured in SnapLogic Manager. See Accounts for more information on configuring an account.


Configuration

This simplified pipeline reads a file from the SnapLogic Database, creates a base-64 encoded ASCII string of the file and attaches it using the Salesforce Create Snap.

  1. Add a File Reader Snap to read the file you want to attach. In this case, the file we are using is a JSON file with the following format:

    [
      {
        "nodes": {},
        "org": "org_name",
        "SnapPacks": [...],
        "Subscriptions": null,
        "SF_ID": ""
      },
    ...
    ]

    where SF_ID corresponds to the Salesforce ID associated with a customer.

  2. A JSON Parser is added to parse the JSON for use within SnapLogic.
  3. Add a Mapper Snap to base-64 encode the file and supply required fields to Salesforce. Configure the following Expression/Target path pairs:
    • Expression: (with expression toggle on) Base64.encode(JSON.stringify($))
      Target path: $Body
      This encodes the file.
    • Expression: (with expression toggle on) $SF_ID
      Target path: $ParentID
      This identifies the Salesforce ID where to attach the file.
    • Expression: (with expression toggle on)  $org + "_Integrations"
      Target path: $Name
      The provides the name to the file. An expression was used to generate the name based on the $org value supplied.
    • Expression: (with expression toggle off) application/json
      Target path: $ContentType
  4. Add a Salesforce Create.
    • Verify that the correct Service version is configured.
    • Set the Object type to Attachment.
    • Set Salesforce API to REST API.
    • Set the error view to route error data to error view.

The pipeline could end here. In this example, we added a JSON Formatter and File Writer to both the output and error views to capture what is written out and save it to a file for troubleshooting purposes.