Skip to Content
0

Success factors Odata response in internal table

Jul 15, 2017 at 02:09 PM

58

avatar image
Former Member

Hello Team,

Greetings!!!

We are in the process of integration from SAP to SF where in we are moving the position data to SF for Succession Planning. We are using the Odata for the position. The data is updating successfully and since we are using synchronous method we are getting the response. The problem here is we want the response message part to convert it in a internal table. Below is the sample response that we are getting.

<?xml version="1.0" encoding="UTF-8"?> -<ns0:SynchronousResponse xmlns:ns0="http://sap.com/xi/XI/OData"> -<ns0:Result> <ns0:StatusCode>200</ns0:StatusCode> <ns0:StatusText>OK</ns0:StatusText> <ns0:Message><?xml version="1.0" encoding="utf-8"?><feed xmlns="http://www.w3.org/2005/Atom" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices"><entry><content type="application/xml"><m:properties><d:key m:null="true"></d:key><d:status>OK</d:status><d:editStatus>UPSERTED</d:editStatus><d:message m:null="true"></d:message><d:index m:type="Edm.Int32">0</d:index><d:httpCode m:type="Edm.Int32">200</d:httpCode><d:inlineResults m:type="Bag(SFOData.UpsertResult)"></d:inlineResults></m:properties></content></entry><entry><content type="application/xml"><m:properties><d:key m:null="true"></d:key><d:status>OK</d:status><d:editStatus>UPSERTED</d:editStatus><d:message m:null="true"></d:message><d:index m:type="Edm.Int32">1</d:index><d:httpCode m:type="Edm.Int32">200</d:httpCode><d:inlineResults m:type="Bag(SFOData.UpsertResult)"></d:inlineResults></m:properties></content></entry></feed></ns0:Message> </ns0:Result> </ns0:SynchronousResponse>

We are getting the breakup of the data for status code, status text and message.

We need the message data converted to an internal table since there is the main data which gives the actual message of the data that is updated.

The data between the below message needs to be captured in an internal table.

<ns0:Message><?xml version="1.0" encoding="utf-8"?>

</entry></feed></ns0:Message>

I have used the parse FM SMUM_XML_PARSE but is there any other method.

I have also used CALL TRANSFORMATION but its giving me a dump.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers