cancel
Showing results for 
Search instead for 
Did you mean: 

SF Integration Issues

Former Member
0 Kudos

Hi All,

My scenario is SF - SAP PO- SFTP.I have all the necessary authorizations for the SF user.

I am trying to select an active user from SF  using the below query -

SELECT person, employment_information, job_information FROM CompoundEmployee where person_id_external = '1048' .

I am getting the below error  . Screen shot for 1st Query (SFqueryissue1)

When i changed the query to SELECT person, employment_information, job_information FROM CompoundEmployee where person_id = '1048'

I am getting No data returned . Screen shot for 2nd Query(Query2).

I am attaching the screen shot of SF for the active user 

Need experts advise on the below issue  .

Regards

Sharath

Accepted Solutions (0)

Answers (4)

Answers (4)

praveen_sutra
Active Contributor
0 Kudos

Hi Sharath,

It might sound silly but please check if the operation mapping is mapped correctly for that particular interface.

thanks and regards,

Praveen t

RaghuVamseedhar
Active Contributor
0 Kudos

Sharath,

Query is correct.

SELECT person, employment_information, job_information FROM CompoundEmployee WHERE person_id_external = '1048'

Please test it using SOAPUI (I recommend, testing SFAPI quires before using them in channel).

Monitor SFAPI on SuccessFactors (Admin tools -> SFAPI Audit logs).

BobvanR
Participant
0 Kudos

Hi Sharath,

If you have SFSF Employee Central then you also have an account on Boomi right? Maybe you can try your selected scenario  SF - SFTP in Boomi first to make sure the error is not in SF or SFTP.

former_member186851
Active Contributor
0 Kudos

Hello Sharath,

First error seems to be something with Interface.Did you configure SWCV?try once removing SWCV.