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

datashape changing dynamic

  • January 8, 2019
  • 1 reply
  • 2618 views

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.

    Best answer by CarlesColl

    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.

    1 reply

    C
    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.

    S
    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?

    C
    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.

    Terms & ConditionsCookie settingsAccessibility statement