Unable to Connect to OData Services in Success Factors Onboarding Integration

[Former Member]

Hi Team,

This is Amarsrinivas Eli - PI Consultant. Am Implementing Onboarding Candidate Info scenario. In order to implement Onboarding Scenario my SAP PI System SP Level should be min 14 but my curret SP level is 5. Hence we are in process of upgrading the system.

Meanwhile I have followed the below blog and installed the NWDS features in Eclipse and trying to import the Onboarding candidateInfo - OData Entities. But am facing below error.

I created a dummy IFlow in Eclipse and trying to connect to OData but we are facing below error. But when we are using SFAPI - am able to connect to do no what else am missing?

Failed to Connect to OData system, reason [javax.xml.stream.XMLStreamException: ParseError at [row,col]:[1,512022] Message: Invalid byte 2 of 2-byte UTF-8 sequence.]

Kindly help us in connecting to OData Services?

Can we handle this scenario in EClipse as a POC without upgradig so that once upgrade is done I can save my time and quickly replicate in PI.

Regards

Amarsrinivas Eli

[Former Member]

Hi Amar,

First of all, the below document is for Hana Cloud Integration, not PI.For PI, only NWDS is supported for creating a direct Iflow.

HCI Iflow and PI IFlow is not the same!!

May I know what is the Odata entity you are trying to call ? Can you please post the picture of the Iflow which you have designed and the backend system you are connecting to ?

Thanks,

Harish

[Former Member]

It can also be due to invalid characters, so please check else paste the request xml as well.

[Former Member]

HI Harish,

I am trying in same HCI - ECLIPSE Client feature not in PI Server.

Please find the below screen shots. In PI SFSF Adpater there wont be operation modeller.

In HCI only this option is there. I tried to import the OnboardingCandidateInfo - Entity using OData services.

Am able to see the same in https://salesdemo4.successfactors.com/odata/v2 Or Similarly my SFSF Application https://XXXXXXXXXX.successfactors.com/odata/v2  - in internet explorer.

I want to import the fields from that entity and create SFQL - query so that I can configure my actual SFSF Adapter in PI.

Regards

Amarsrinivas Eli

[Former Member]

Hi

Good News!! Am able to solve the below issue by changing the URL.

I am able to connect to OData Services using another Link - https://XXXXXXXXXXXXXXXXX.successfactors.eu/odata/v2/OnboardingCandidateInfo

Now I created a SFQL. Please find the below. But how to test this SFQL and retrieve the candidate records in ECLIPSE or any 3^rdparty tool without using PI -  Otherwise any Webservice can we keep this query?

Because my PI Server upgrade is not yet happened. Its in discussion.

• Operation: Query(GET)
• ResourcePath :

OnboardingCandidateInfo?$select=userId,readyToHire,managerId,kmsUserId,internalHire,hrManagerId,hired,hireDate,fromExternalATS,candidateId,applicantId&$filter=readyToHire
eq YES or readyToHire eq Yes or readyToHire eq Y&$orderby=applicantId

• Path to edmx : edmx/XXXXXXXXXX_successfactors_eu_odata_v2_OnboardingCandidateInfo.xml

Regards

Amarsrinivas Eli

[Former Member]

Hi Amar,

Good,that it is resolved !

For testing purposes you can use the SFSF test tools page(below) and select option 4 once you login to your instance with the company id and user/pwd.

There are also other tools like Postman(chrome plugin) and several other plugins both in mozilla and chrome.

API Tools

BR,

Harish