Skip to Content
avatar image
Former Member

Success factors Odata response in internal table

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers