Skip to Content
Technical Articles
Author's profile photo Deepak MP

How to Perform Upsert Operation using CPI Successfactors Soap Adapter

About the Author:

I work as a Developer in Cloud Platform Integration and work predominantly in building and maintaining CPI adapters. Adapters are used to integrate systems with different platform. I specialize in CPI Successfactors Adapter, which is used to integrate systems with Successfactors.

Why This Article:

One common mistake that user does is to copy the payload template from Soap UI and use it as a payload in Successfactors CPI adapter.

Successfactors CPI adapter takes simple xml as payload and the adapter will take care of creating the Soap Envelope around the payload before sending the data to Successfactors system.

We will explain it step by step with a simple example.

What to expect in this article:

In this article, we will explain how an Upsert operation is performed using Successfactors CPI Adapter.


Scenario: Update records of user with empid 1001

  • Create an Integration Project

We use Content Modifier to pass payload to Successfactors CPI adapter and SFTP adapter to get the response from the Upsert operation from the Successfactors CPI adapter. Adding SFTP adapter is optional, it can be replaced with any other adapter of your choice and you may also choose not to use any adapter if the response from the adapter is not required.

  • Model Upsert Operation in Successfactors CPI Adapter.

In the Successfactors “Processing” tab enter the Successfactors Address and Credential Name and click on “Select”.

Model operation requires you to connect to the Successfactors system. Enter the Successfactors connection details and click on Connect.

In the Entity Selection dialog select the table that needs to be updated. In our scenario we are updating User table.

Select Operation as “Upsert” and select the fields that needs to be updated. externalId and Status are mandatory fields. Click on Finish.


  • Add the payload to the Content Modifier.

The sample payload is given below.

<?xml version="1.0" encoding="UTF-8"?>
	<department>Talent Management</department>
	<jobCode>Human Resources Manager (HR-MGR)</jobCode>
	<location>San Mateo (US_SFO)</location>

Add the payload for the selected fields as shown. The payload should be a simple xml.

Save the changes and deploy the iflow.


In this article we explained how Upsert operation can be performed using CPI Successfactors Soap Adapter. You can now go ahead and try out few scenario.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Terrence Chamburuka
      Terrence Chamburuka

      Thank you for the stuff can you help with using Upsert of the ODATA API

      Author's profile photo JOSE FRANCISCO ARANDA AGUIRRE

      Hello, thanks for you post, I have a question, performing an perEmail upsert of many users I get an error if any row failing:

      <data contentType="null" contentLength="537"><![CDATA[{error text :
      An exception has occurred. These are the details..
      UPSERT operation status; Job Status:{ERROR}, Message:{}
      UPSERT operation FAILED; Total:3, Successful:2, Failed:1, Not Processed:0
      Index:{0}, Edit Status:{UPSERTED}, Error Status:{OK}, Message:{}
      Index:{1}, Edit Status:{NOEDIT}, Error Status:{ERROR}, Message:{Global Person ID is invalid.,
      failed record info: {, email_type=3964, person_id_external=bbsbb, isPrimary=true}}
      Index:{2}, Edit Status:{UPSERTED}, Error Status:{OK}, Message:{}

      Is there any way to continue execution and obtain respond operation on body flow with the ox and error execution on respond operation?. like this (manual edited xml, just to represent what I want):


      <upsertResponse xmlns=""
      <message xmlns:xsi=""
      <message xmlns:xsi=""
      <message xmlns:xsi=""



      Author's profile photo Priffy Consultant
      Priffy Consultant

      ​I have a problem in accessing upsert functionality of SuccessFactors from CPI. I am using Succesfactors odata v2 adapter in CPI but I am unable to find the Upsert Enitity .



      I cannot find the upsert Entity in the SuccessFactors OData v2 in CPI. But I am able to access the same using Postman. Other odata functionalities are accessible from CPI using Oauth2 saml bearer token. Upsert functionality belongs to function-import  operation of SuccessFactors adapter. Is it implemented in SuccessFactors adapter?


      Cannot find the upsert entity in SF adapter


      Postman Client

      In the screenshot, I am able to access the same upsert odata in postman with the same oauth token. I am unable to find the same in CPI. Please provide the solution for this issue.

      Thanks in advance.

      Author's profile photo pranita mhatre
      pranita mhatre

      hi expertise

      is it possible to add where condition on upsert query ? and how

      i want upsert payroll id for particular company code only.

      Author's profile photo Jun Woo Park
      Jun Woo Park


      Author's profile photo Jun Woo Park
      Jun Woo Park

      I tried following this blog and got an error. Problem during invoking SuccessFactors Web service. SOAP faultCode S:Server, faultString SFAPI Domain Error!, errorCode INVALID_REQUEST_MESSAGE, errorMessage: Invalid request message! Error: For Update/Delete operation, the required Id field is missing!. Occurred at row 1!, cause: org.apache.cxf.binding.soap.SoapFault: SFAPI Domain Error!

      As a result of checking the SFAPI dictionary, the requried fields are exteranlId(id ??) and status.

      But this blog doesn't have about this. so I add <id>USR-179</id>

      after add <id>USR-179</id>

      Error Details UPDATE operation status; Job Status:{ERROR}, Message:{} UPDATE operation FAILED; Total:1, Successful:0, Failed:1, Not Processed:0 Index:{0}, Edit Status:{NOEDIT}, Error Status:{ERROR}, Message:{USER_NOT_FOUND Field name:hrid Field value:USR-17 Cannot find user by user id. InternalId = USR-17.. }