Skip to main content
svisveswaraiya_2859881-Visitor
1-Visitor
January 8, 2019
Solved

datashape changing dynamic

Hi,

Whenever a datashape is created from a sql query it becomes static. If I make any changes in the query like adding a new column or removing I have to again create a new datashape. But is it possible that the datashape becomes dynamic and adjusts according to the query whenever it is changed?

 

Thanks,

Shalini V.

    CarlesCollAnswer
    1-Visitor
    January 8, 2019

    The output of a service as defined can only have one DataShape (only System Services can have "Dynamic DataShapes" to be shown on Mashups - for instance QueryImplementingThings or GetProperties services), but you can always output any amount of columns (dynamic) out of a services ignoring the defined DataShape.

    View in thread

    4 replies

    CarlesColl1-VisitorAnswer
    1-Visitor
    January 8, 2019

    The output of a service as defined can only have one DataShape (only System Services can have "Dynamic DataShapes" to be shown on Mashups - for instance QueryImplementingThings or GetProperties services), but you can always output any amount of columns (dynamic) out of a services ignoring the defined DataShape.

    Translate
    svisveswaraiya_2859881-VisitorAuthor
    1-Visitor
    January 8, 2019

    Hi @CarlesColl,

    Thanks for your quick response. 

    Do you mean I can output any number of columns and create datashape from the respective output?

    Translate
    CarlesColl1-Visitor
    1-Visitor
    January 8, 2019

    You can output any number of columns yes, you don't need to create a specific DataShape if it's dynamic.

    Translate
    Terms & ConditionsAccessibility statement