salesforce composite upsert sink Salesforce composite upsert Sink

Provided by: "Apache Software Foundation"

Support Level for this Kamelet is: "Stable"

Upsert Composite List of sObjects in Salesforce.

The body received must contain List of JSON SObjects to insert/update inside the records attribute, for example:

{"records" : ["attributes" : {"type" : "KameletSinkSObjectc"},"ExtIdc" : "1","Namec": "Ziauddin", "Cityc": "Bhopal"], ["attributes" : {"type" : "KameletSinkSObjectc"},"ExtIdc" : "2","Namec": "Shaikh", "Cityc": "Bhopal"] }

Configuration Options

The following table summarizes the configuration options available for the salesforce-composite-upsert-sink Kamelet:

Property Name Description Type Default Example

clientId

Consumer Key

Required The Salesforce application consumer key.

string

clientSecret

Consumer Secret

Required The Salesforce application consumer secret.

string

password

Password

Required The Salesforce user password.

string

sObjectIdName

Object Id Name

Required The Field Name of the External ID of the Salesforce object. Required if using a key-value pair.

string

sObjectName

Object Name

Required The type of the Salesforce object. Required if using a key-value pair.

string

Contact

userName

Username

Required The Salesforce username.

string

loginUrl

Login URL

The Salesforce instance login URL.

string

https://login.salesforce.com

Dependencies

At runtime, the salesforce-composite-upsert-sink Kamelet relies upon the presence of the following dependencies:

  • camel:core

  • camel:jsonpath

  • camel:jackson

  • camel:salesforce

  • camel:kamelet

Camel JBang usage

Prerequisites

  • You’ve installed JBang.

  • You have executed the following command:

jbang app install camel@apache/camel

Supposing you have a file named route.yaml with this content:

- route:
    from:
      uri: "kamelet:timer-source"
      parameters:
        period: 10000
        message: 'test'
      steps:
        - to:
            uri: "kamelet:log-sink"

You can now run it directly through the following command

camel run route.yaml

Camel K Environment Usage

This section describes how you can use the salesforce-composite-upsert-sink.

Knative sink

You can use the salesforce-composite-upsert-sink Kamelet as a Knative sink by binding it to a Knative object.

salesforce-composite-upsert-sink-binding.yaml
apiVersion: camel.apache.org/v1
kind: KameletBinding
metadata:
  name: salesforce-composite-upsert-sink-binding
spec:
  source:
    ref:
      kind: Channel
      apiVersion: messaging.knative.dev/v1
      name: mychannel
  sink:
    ref:
      kind: Kamelet
      apiVersion: camel.apache.org/v1
      name: salesforce-composite-upsert-sink
    properties:
      clientId: The Consumer Key
      clientSecret: The Consumer Secret
      password: The Password
      sObjectIdName: The Object Id Name
      sObjectName: Contact
      userName: The Username

Prerequisite

You have Camel K installed on the cluster.

Procedure for using the cluster CLI

  1. Save the salesforce-composite-upsert-sink-binding.yaml file to your local drive, and then edit it as needed for your configuration.

  2. Run the sink by using the following command:

    kubectl apply -f salesforce-composite-upsert-sink-binding.yaml

Procedure for using the Kamel CLI

Configure and run the sink by using the following command:

kamel bind channel:mychannel -p "sink.clientId=The Consumer Key" -p "sink.clientSecret=The Consumer Secret" -p "sink.password=The Password" -p "sink.sObjectIdName=The Object Id Name" -p "sink.sObjectName=Contact" -p "sink.userName=The Username" salesforce-composite-upsert-sink

This command creates the KameletBinding in the current namespace on the cluster.

Kafka sink

You can use the salesforce-composite-upsert-sink Kamelet as a Kafka sink by binding it to a Kafka topic.

salesforce-composite-upsert-sink-binding.yaml
apiVersion: camel.apache.org/v1
kind: KameletBinding
metadata:
  name: salesforce-composite-upsert-sink-binding
spec:
  source:
    ref:
      kind: KafkaTopic
      apiVersion: kafka.strimzi.io/v1beta1
      name: my-topic
  sink:
    ref:
      kind: Kamelet
      apiVersion: camel.apache.org/v1
      name: salesforce-composite-upsert-sink
    properties:
      clientId: The Consumer Key
      clientSecret: The Consumer Secret
      password: The Password
      sObjectIdName: The Object Id Name
      sObjectName: Contact
      userName: The Username

Prerequisites

  • You’ve installed Strimzi.

  • You’ve created a topic named my-topic in the current namespace.

  • You have Camel K installed on the cluster.

Procedure for using the cluster CLI

  1. Save the salesforce-composite-upsert-sink-binding.yaml file to your local drive, and then edit it as needed for your configuration.

  2. Run the sink by using the following command:

    kubectl apply -f salesforce-composite-upsert-sink-binding.yaml

Procedure for using the Kamel CLI

Configure and run the sink by using the following command:

kamel bind kafka.strimzi.io/v1beta1:KafkaTopic:my-topic -p "sink.clientId=The Consumer Key" -p "sink.clientSecret=The Consumer Secret" -p "sink.password=The Password" -p "sink.sObjectIdName=The Object Id Name" -p "sink.sObjectName=Contact" -p "sink.userName=The Username" salesforce-composite-upsert-sink

This command creates the KameletBinding in the current namespace on the cluster.