How to keep properties order from DataShape in Service result.

[JK_10565232]

I have a problem with the fact that I cannot maintain the order of Data Shape properties in the service.
For example
Date Shape:

ID
PartName
PartNumber
ChildEqID
SomeName

When I check what the list of properties returned by the service as an infotable in All Data looks like, I see this:

ChildEQID
ID
PartName
PartNumber
SomeName

How to keep the service result in exactly the same order as in DataShape

I need this order to generate an excel report

[Velkumar · Accepted solution]

Hi @JK_10565232 

Use this arrow in DataShape FieldDefinition to set the order of fields. In the backend, it will set an ordinal number for fields

Here I moved hasChildren field to position 1 

/VR

[JK_10565232]

HI Velkumar,

Could you create service with infotable like Output. Please set you data shape for this infotable. Please create test mashup where you will try to call this service and check properties order for this output infotable. 

I had Data Shape like this:

on Mashup side it looks like this:

the question is how can I keep the same order on mashup side?

[Velkumar]

Hi @JK_10565232 

In Mashup DesignTime, field names will be sorted alphabetically. We don't have control over that.

It just makes mapping easier during design time it doesn't impact Mashup Runtime sorting.

/VR