12-Amethyst

Solved

How to keep properties order from DataShape in Service result.

Forum|Forum|2 years ago
September 13, 2023
1 reply
1454 views

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

Coding

Best answer by Velkumar

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

V

Velkumar

Answer

19-Tanzanite

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

J

JK_10565232

Author

12-Amethyst

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?

V

Velkumar

19-Tanzanite

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

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded