Sample JSON Mappings

Simple mapping:

 [
  {
    "parent": "Admin__c"
  },
  {
    "parent": "Account_Function__c"
  }
]

Lookup mapping:

[
  {
    "parent": "CompRateTable__c",
    "lookups": [
      {
        "lookupMappedField": "AccountFunction__c",
        "lookupObject": "Account_Function__c",
        "keys": [
          "Name"
        ]
      }
    ]
  }
]

Masterdetail mapping:

[
  {
    "parent": "Approval_Exception__c"
  },
  {
    "parent": "Approval_Process__c",
    "unmappedFields": [],
    "children": [
      {
        "parentMappedField": "Approval_Process__c",
        "childObject": "Approval_Step__c",
        "sequence": 1,
        "children": [
          {
            "parentMappedField": "Approval_Step__c",
            "childObject": "Approval_Term_Condition__c",
            "sequence": 2,
            "lookups": [
              {
                "lookupMappedField": "Approval_Process__c",
                "lookupObject": "Approval_Process__c",
                "keys": [
                  "Name",
                  "Active__c"
                ]
              }
            ]
          },
          {
            "parentMappedField": "Approval_Step__c",
            "childObject": "Approval_Exception_Condition__c",
            "sequence": 2,
            "lookups": [
              {
                "lookupMappedField": "Approval_Process__c",
                "lookupObject": "Approval_Process__c",
                "keys": [
                  "Name",
                  "Active__c"
                ]
              },
              {
                "lookupMappedField": "Exception__c",
                "lookupObject": "Approval_Exception__c",
                "keys": [
                  "Exception__c",
                  "Active__c"
                ]
              }
            ]
          }
        ]
      }
    ]
  }
]

Hierarchical mapping:

[
  {
    "parent": "Approval_Process__c",
    "externalIdField": "ExternalKey__c",
    "refresh": true,
    "lookups": [
      {
        "lookupMappedField": "Entry_Criteria__c",
        "lookupObject": "Approval_Process__c",
        "keys": [
          "Entry_Criteria_Active__c",
          "Entry_Criteria_BoolOper__c",
          "Entry_Criteria_Field__c",
          "Entry_Criteria_Field_Value__c",
          "ExternalKey__c"
        ],
        "externalIdField": "ExternalKey__c"
      },
      {
        "lookupMappedField": "Step_Filter__c",
        "lookupObject": "Approval_Process__c",
        "keys": [
          "Step_Filter_BoolOper__c",
          "Step_Filter_Comparison_Type__c",
          "Step_Filter_Field__c",
          "Step_Filter_Field_Object__c",
          "ExternalKey__c"
        ],
        "externalIdField": "ExternalKey__c"
      },
      {
        "lookupMappedField": "Step_Group__c",
        "lookupObject": "Approval_Process__c",
        "keys": [
          "Step_Group_Active__c",
          "Step_Group_Name__c",
          "Step_Group_Rejection_Action__c",
          "Step_Group_Seq_Number__c",
          "ExternalKey__c"
        ],
        "externalIdField": "ExternalKey__c"
      },
      {
        "lookupMappedField": "Step_Group_Action__c",
        "lookupObject": "Approval_Process__c",
        "keys": [
          "Step_Group_Action_Field_Name__c",
          "Step_Group_Action_Field_Name_Source__c",
          "Step_Group_Action_Field_Update_Type__c",
          "Step_Group_Action_Field_Value__c",
          "ExternalKey__c"
        ],
        "externalIdField": "ExternalKey__c"
      },
      {
        "lookupMappedField": "Step__c",
        "lookupObject": "Approval_Process__c",
        "keys": [
          "Step_Active__c",
          "Step_Approver_Type__c",
          "Step_Assignee__c",
          "Step_Assignee_Id__c",
          "ExternalKey__c"
        ],
        "externalIdField": "ExternalKey__c"
      },
      {
        "lookupMappedField": "Final_Approval_Action__c",
        "lookupObject": "Approval_Process__c",
        "keys": [
          "Final_Action_Field_Name__c",
          "Final_Action_Field_Name_Source__c",
          "Final_Action_Field_Update_Type__c",
          "Final_Action_Field_Value__c",
          "ExternalKey__c"
        ],
        "externalIdField": "ExternalKey__c"
      },
      {
        "lookupMappedField": "Group_Action__c",
        "lookupObject": "Approval_Process__c",
        "keys": [
          "ExternalKey__c"
        ],
        "externalIdField": "ExternalKey__c"
      },
      {
        "lookupMappedField": "Initial_Submission_Action__c",
        "lookupObject": "Approval_Process__c",
        "keys": [
          "Initial_Submission_Action_Type__c",
          "Initial_Submission_Field_Name__c",
          "Initial_Submission_Field_Name_Source__c",
          "Initial_Submission_Field_Value__c",
          "ExternalKey__c"
        ],
        "externalIdField": "ExternalKey__c"
      }
    ]
  }
]

Masterdetail Mapping with where clause and unmappedFields:

[
  {
    "parent": "Pricebook2",
    "where": " IsStandard = false ",
    "unmappedFields": ["IsStandard"],
    "children": [
      {
        "parentMappedField": "Pricebook2Id",
        "childObject": "PricebookEntry",
        "where": " Pricebook2.IsActive=true And Pricebook2Id != null And Product2Id != null ",
        "sequence": 1,
		    "unmappedFields": ["ProductCode", "Name"],
        "lookups": [
          {
            "lookupMappedField": "Product2Id",
            "lookupObject": "Product2",
            "where": "ExternalKey__c != null",
            "keys": [
              "ExternalKey__c"
            ]
          }
        ]
      }
    ]
  }
]

Simple Pricebook Mapping:

[
  {
    "parent": "Pricebook2",
    "where": "IsStandard != true"
  }
]

Simple PricebookEntry Mapping:

[
  {
    "parent": "PricebookEntry",
    "where": "Pricebook2.IsStandard != true"
  }
]

Account mapping with Opportunities and Assets:

[
  {
    "parent": "Account",
    "externalIdField": "ExternalKey__c",
    "where": " ExternalKey__c != null",
    "refresh": true,
    "unmappedFields": [
      "PhotoUrl",
      "IsPartner",
      "IsCustomerPortal",
      "IsPersonAccount"
    ],
    "children": [
      {
        "parentMappedField": "AccountId",
        "childObject": "Opportunity",
        "externalIdField": "ExternalKey__c",
        "where": " ExternalKey__c != null",
        "unmappedFields": [
          "IsClosed",
          "IsWon",
          "ForecastCategory",
          "HasOpportunityLineItem",
          "FiscalQuarter",
          "FiscalYear",
          "Fiscal",
          "HasOpenActivity",
          "HasOverdueTask"
        ],
        "sequence": 1
      },
      {
        "parentMappedField": "AccountId",
        "childObject": "Asset",
        "externalIdField": "ExternalKey__c",
        "where": " ExternalKey__c != null",
        "sequence": 2
      }
    ],
    "lookups": [
      {
        "lookupMappedField": "ParentId",
        "lookupObject": "Account",
        "where": " ExternalKey__c != null",
        "keys": [
          "Name",
          "ExternalKey__c"
        ]
      }
    ]
  }
]