Web service data source not returning any results when streaming output

Applies to: Denodo 8.0 , Denodo 7.0 , Denodo 6.0
Last modified on: 03 Jun 2020
Tags: Error handling Web Services

Download document

You can translate the document:

Content

When creating a base view on top of an operation of a web service data source, the base view can be created using the option “Do not stream output” or “Stream output at specified level”. In some cases when the stream output option is used, the queries executed on the base view will not return any result.

This problem occurs when the message returned by the web service contains 'multirefs' elements. Multirefs are references to other elements in XML files. The streaming option for web services does not support the use of 'multirefs' elements.

To solve this scenario the web service will have to be modified to avoid using 'multirefs' elements or the option 'Do not stream output' selected to create the base view. When using this option, in order to obtain the fields from a particular level of the web service output, a Flatten view can be created on top of the base view to obtain the desired output schema.

References

Virtual DataPort Administration Guide: Creating Base Views from a SOAP Web Service.

Virtual DataPort Administration Guide: Creating Flatten Views.

Advanced VQL Guide: Web Services Wrappers.

Questions

Ask a question
You must sign in to ask a question. If you do not have an account, you can register here

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training