Skip to Content
avatar image
Former Member

SF Integration Issues

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

SF 1048.JPG (39.5 kB)
Query2.JPG (48.6 kB)
SFquery issue1.JPG (79.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Oct 28, 2015 at 12:39 PM

    Hello Sharath,

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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 28, 2015 at 01:48 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 29, 2015 at 12:45 AM

    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).

    Connecting Successfactors APIs Using SOAP UI

    Hands-On – Testing Integration with SuccessFactors SFAPI

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 29, 2015 at 12:08 PM

    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

    Add comment
    10|10000 characters needed characters exceeded