SuccessFactors Upsert

On this page

Snap Type:

Write

Description:

This Snap provides the ability to update or insert data objects from SuccessFactors Data Center server to a selected item.

Prerequisites:

None

Support and limitations:

Ultra pipelines: May works in Ultra Pipelines.

In Ultra Pipelines, set the Batch Size as 1 for the Snap to process one document/record at a time.

Spark mode: Not supported in Spark mode.

Account:

This Snap uses account references created on the Accounts page of SnapLogic Manager to access to the endpoint. See SuccessFactors Account for information on setting up this type of account.

Views:

Input
This Snap has at most one document input view.

Output
This snap has at most one document output view.

Error
This Snap has one optional error view and might produce documents in the view if the input data causes an error in the REST API.

Settings

Label:

Required. The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline.

Entity:

Required. This property enables you to define an entity of the API. This field will be shown dynamically from different users’ accounts from the suggestion dropdown. Users are allowed either to choose an entity from suggestion dropdown or type an entity manually. The entity is shown as [category name] – [entity name] in the dropdown. But it is also allowed to type only [entity name] in this field.

Example: Foundation/Platform (PLT) – User or User

Default value: [None]

Batch size:

Required. This property value is allowed to be from 1 through 10,000. Each input document forms one SuccessFactors record to be upserted. The Snap stores records in memory until the number of records reaches the batch size and sends the request to SuccessFactors in single batch. Increasing the batch size increases the amount of memory used during the data load. Decreasing the batch size increases the number of API calls against SuccessFactors.

 

Example: 200, 1000

Default value: 200

Refresh metadata:

If selected, the Snap will refresh the cache and show refreshed metadata results including new entities/parameters added or old entities/parameters deleted. This is handy in cases where changes are made to the data set outside of SnapLogic, such as a new data set created, existing data set deleted, and so on. In such cases, enabling this property will refresh the cache and display updated content.Please be aware that after the first run and new metadata has been refreshed, please de-select this checkbox.

 

Default value: Not selected

Execute during preview:

This property enables you to execute the Snap during the Save operation so that the output view can produce the preview data.

 

Default value: Not selected

Example

The example assumes that you have configured & authorized a valid SuccessFactors Account (see SuccessFactors Account).

Configuring a SuccessFactors Upsert Snap to create new users and update data for existing users via entity Foundation/Platform (PLT) - User:

 

 

 

Implementing an example pipeline for batching creation of new users or batching updating data of existing users via entity Foundation/Platform (PLT) - User:
The following pipeline shows how you can use SuccessFactors Upsert Snap to create new users and update data for existing users via Foundation/Platform (PLT) - User API entity in the Success Factors data center. Firstly, the input json-formatted data of a new user is generated by the JSON Generator snap. Next, a Mapper snap is applied in between of JSON Generator snap and SuccessFactors Upsert snap to map the data from JSON Generator snap to SuccessFactors Upsert snap as the input for SuccessFactors Upsert snap. The input schema is provided by SuccessFactors Upsert snap. Additionally, a JSON Formatter snap and a File Writer snap are applied to format and record data in a new file.

 

A successful validation or execution of the Snap gives the following output preview showing the query results:

 

Downloads

  File Modified

File SuccessFactors_1.0.0_Upsert_User_TC1_Upsert.slp

Nov 06, 2019 by Rojo Publisher

Snap Pack History

Initial Release (15/11/2019)

  • Introduced in this release

 

 

Have feedback? Email helpdesk@rojoconsultancy.com © Rojo Consultancy