Symptom
- CompoundEmployee API when queried through Boomi by using the parameter “resultOptions=renderPreviousTags” returns the previous values of the field
- To capture both the previous and the current value in a mapping profile and send the data to target profile is having issues and you are getting an error “Source profile mismatch”
Environment
Boomi
Reproducing the Issue
- Make a connector operation in Boomi using Successfactors connector
- Use the parameter “resultOptions=renderPreviousTags” while querying the data
- When this queried data is passed into the mapping step which will have the CE API response profile generated from the Boomi import, this profile step will cause the process to end up into an error
Cause
This is because we do not have the respective previous tags generated in the response profile from the Boomi import option
Resolution
Please use the following parameter in a query outside the client tool (Boomi/any other) to generate the XSD and save it locally
<param>
<name>resultOptions</name>
<value>renderPreviousTags,xsd</value>
</param>
Sample Query
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Header />
<SOAP-ENV:Body>
<query xmlns="urn:sfobject.sfapi.successfactors.com">
<queryString>SELECT employment_information,job_information,person FROM CompoundEmployee WHERE (last_modified_on > to_datetime('2015-11-21T08:24:00Z') AND person_id_external = 'admin')</queryString>
<param>
<name>resultOptions</name>
<value>renderPreviousTags,xsd</value>
</param>
<param>
<name>queryMode</name>
<value>delta</value>
</param>
</query>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
Sample XSD file is attached to this KBA
In Boomi follow the below procedure:
- Use a mapping step
- In the mapping step, instead of choosing/browsing the source profile please import the XSD file saved locally
- To import the XSD file, click on choose --> Select XML --> Click on “Create new profile”
- You will be prompted to import a profile --> Choose import a profile --> Choose --> XML Schema --> Browse to the location where the local XSD is saved and now import the same
- You will be prompted with two options --> Choose Compound Employee --> Next --> Finish
- Save and close the source profile
Very Important Note:
- The namespace of the profile should be set to NONE --> This needs to be done by choosing the Root element "CompundEmployee" in the mapping profile and under "Namespace" select the drop down and choose "None" (by default you will have urn:sfobject.sfapi.successfactors.com)
- The flag “Remove namespace” option should be disabled in the connector operation.
Sample Process
Keywords
-
Previous tags in compound employee
- compoundemployee
- resultoptions=renderprevioustags
- Source profile mismatch
- mapping error in boomi
- compoundemployee errors in mapping
- schema not matching for compoundemployee
- how to import previous tags into boomi?
Product
Attachments
Previous_tag_xsd.zip |