cancel
Showing results for 
Search instead for 
Did you mean: 

PO REST adapter loses ODATA attributes when converting JSON response to XML

Wapper
Newcomer
0 Kudos

Hello,

We are trying to implement a simple data query from SAP PO to a Sharepoint server via Microsoft Graph API.

It seems nowadays MS Graph API only supports json, so we need to convert json response to xml in the REST receiver channel. Json response contains ODATA elements in the beginning of the json body, we need these elements to be able to read the next page (element @odata.nextLink):

Wapper_0-1715872998491.png

However, after conversion to XML (with wrapper element) these ODATA elements are lost:

Wapper_1-1715873314239.png

We have tried all possible combinations of settings in the REST channel, including JSON to XML name mapping, but ODATA elements just will not be there. The only way is not to add the wrapper element in XML conversion, in this case a very strange structure will be returned, with ODATA elements but without the business data:

Wapper_2-1715873875180.png

Is there any way to make conversion is such a way that both ODATA and business payload are preserved? Many thanks in advance.

Accepted Solutions (0)

Answers (0)