Polling multiple tables from successfactor

[Former Member]

Hi Experts,

I am working on a project where we have to integrate with Successfactors. And I have a scenario where I have to poll data from 3 tables and then write it to a file. My question is can I poll multiple tables using SFSF adapter ? If yes,  please share any documentation I can refer. If not, then how can I achieve this functionality ?

Regards,

Karan

[lukemarson · Accepted solution]

It depends on what data you are looking to extract. As per , what data do you want?

You can't access SuccessFactors tables, but you can us either the SFAPI to OData API to extract data.

[Former Member · Accepted solution]

I want to poll data from personalInfo, EmpJob and EmpCompensation entities using SFSF sender Polling channel. Please advise if that can be achieved through polling. Can I write SFQL queries using joins ?

[Muniyappan · Accepted solution]

check if you can retrieve using odata.

please refer

try to construct the url if you can get the data.

https://<data center>.successfactors.com/odata/v2/EntitySetName

joins will be possible i guess. that is called "“expanding”. see the below statement from api guide.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e0dc0e49-8e3a-3110-4f9e-a307b1ffd...

Of course, there are many more things to consider, including filtering, paging, sorting, joining to other entities (known as “expanding” in OData), etc. Examples of these details are described below.

[lukemarson · Accepted solution]

You must use the OData API and you can do this using navigation properties. Refer to the EC OData API handbook at http://service.sap.com.

You can start at the perPerson entity and use the navigation properties.

[Former Member]

Hi All,

We need to write Odata queries to retrive data from multiple entities of recruitment module in SF integration through PI 7.3 SP13 dual stack.

Need to check where we need to write the query to include multiple API calls.

Is this we can achieve through some config in Channel.

Is there any documentation/blogs on it.

Regards

Deepak

[Muniyappan]

check page no 15.. similarly if you have the query, you can use it for your scenario in sfsf adapter.

https://websmp109.sap-ag.de/~sapidb/012002523100004147712015E

[Former Member]

Hi Muni,

The link shared by you,helped me to understand the format of Odata query that we can use if we have to poll data for one entity from Successfactor.

But,We need to do query on more than one entity similar to Join operation( in terms of progamming language) through SFSF adapter via odata protocol.

Can we acheive this requirement through a single SFSF communication channel or do we have some other way to fulfill this type of requirement.

Also,if Join operation is possible then how to get source XSD for this to be used in mapping as source structure.

Regards

Deepak

[Muniyappan]

As per API guide, it is possible to fetch data from multiple entity, which is nothing but a single query. So I assume this can be done in single channel.

I have not done this practically, I would suggest you to give an try and let us know.

coming to xsd part, I believe for each entity there will be xsd created. Check with any SF consultant they can help you.

otherwise, you can run the interface once in PI, this will give you xml, from than you can generate the xsd.

[Former Member]

Hello,

SFSF Adapter doesn't have this feature.

reg, avi

[Former Member]

Hi,

Is there any other way I can achieve this functionality ?

[Muniyappan]

can you tell us what data you want to poll from 3 tables?

some scenario sender adapter polling is possible.

you can use query string for an entity set

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e0dc0e49-8e3a-3110-4f9e-a307b1ffd...

direct table polling will not be possible. better check with sap by raising oss msg.

[Former Member]

Sorry for the confusion. By tables I meant to say "Entities". I want to poll data from personalInfo, EmpJob and EmpCompensation entities using SFSF sender Polling channel. Please advise if that can be achieved through polling.