Thrird Party < - > PI < -> Successfactor ( ADHOC REPORT QUERY ) Synchronous Call : Failure

[Former Member]

Hello Experts

Scenario is following :-

Thrird Party < - > PI < -> Successfactor ( ADHOC REPORT QUERY - TASK ID ) Synchronous Call

I am trying to poll data from Successfactor Side using Adhoc Report.

from Successfactor Side I am trying to get Data from following SF SOAP API Operations :-

1. getJobResult -

This Gives blank SOAP Body Response but with actual CSV Data in SOAP attachment.

Due to Blank SOAP This Response message gets failed in Response Message Mapping.

So  Here I dont know How to get this Response CSV Data from SOAP attachment and swap it with blank SOAP BODY payload before it reach to Response Message Mapping???

2. getJobResultEmbedded - This gives response as binary string. But I dont know How to Convert this Binary String into actual CSV Data ??

AnyBody have any experience on handling SF ADHOC Reports using SAP PI ???

I have been looking at SAP Pre Delivered Compenstation Interface - They are using 2nd Method to get data from ADHOC Reports and they did binary data conversions in ABAP COde on SAP ECC SIde( I am not an abaper so I dont know How did they do the conversions) But what I am trying to do here is I am trying to achive same in PI Box instead of ECC.

So It would be great Help, If any one can share any information on this.

even a small info can help .

Please s hare your thoughts

Regards

Prabhat Sharma

[Former Member]

Guys ... Please s hare your comments  on above question.

[HadrienP]

Hi,

any clue on this topic ? I'm interesting to know how we can convert this byte stream into the csv file or something else readable in abap.

thank you

Hadrien