OTM DB Servlet API is not showing the response in valid xml format
I have tested the OTM DB Servlet API to retrieve transmission report data, but the response is not coming back in the correct XML format. As a result, we are facing difficulties using it in our integration mapping.
Is there a way for us to obtain the transmission report data in the proper XML or JSON format?
Below in the response you can see there is no namespace for "Transmission " element . so it is creating the problem in our integration.
request:
<?xml version="1.0" encoding="UTF-8"?><sq12xml> <Query> <RootName>Transmission</RootName> <Statement>SELECT I_LOG_SEQNO, I_MESSAGE_CODE, I_MESSAGE_TEXT FROM I_LOG WHERE I_TRANSMISSION_NO = '32004'</Statement> </Query></sq12xml>
Tagged:
0