3320586 - Error while performing an UPSERT on JobRequisition through Integration Center: templateId required - Recruiting Management

Error when running UPSERT through Integration Center in the Job Requisition entity:

"JobRequisition: UPSERT failed for the row with key: . Reason: templateId required, . The row will not be processed for subsequent entities."

SAP SuccessFactors Recruiting Management

Possible Cause 1: This happens when the CSV file contains the column isDraft and the value associated with the column is wrongly configured in the CSV file. E.g.: the value is TRUE, or FALSE, or True, or False.

Possible Cause 2: The import includes deleted job requisitions. Those rows are being interpreted as Insert operations, and Insert requires a templateId.

For Possible Cause 1 - Incorrect isDraft value

The value for isDraft is case sensitive. As explained on the KBA 2771951 - How to update Job Requisition fields using Integration Center - Recruiting Management, the value for isDraft must be "true" or "false", all in lower case letters.

This often happens when using Excel, so it's advised to use another software to validate the values or to confirm that the formatting of the entry is retained in the spreadsheet prior to uploading it to the integration.

For Possible Cause 2 - Deleted job requisitions included

Remove deleted requisitions from the import source.

Identify deleted requisitions using the "Is Deleted (deleted)" field from the JobRequisition entity. For detailed instructions, refer to the KBA 3235902 - How to export the list of all deleted job requisitions? - Recruiting Management.

KBA 2771951 - How to update Job Requisition fields using Integration Center - Recruiting Management

KBA 3235902 - How to export the list of all deleted job requisitions? - Recruiting Management

job, requisition, template, templateId, ID, upsert, update, api, odata, integration, center, centre, error, is draft, capitals, lower case , KBA , LOD-SF-RCM-INT , Integration Center & Intelligent Services , LOD-SF-RCM-API , Webservices & APIs , LOD-SF-RCM-JOB , Job Postings & Requisitions , Problem