I am trying to retrieve DE fields via SOAP API but the response containing the fields is out of order not even in alphabetical. I need them to be in the exact order as what is in the UI. I need this to create the same exact DE in another instance.

Any ideas?

2 Answers 2


If you retrieve the 'ordinal' property of the fields, this will tell you the order they are stored/were created, and appear in the UI. You can sort on that via code before creating the new DE/fields.

  • Thank you so much. This makes sense now. Jul 23, 2019 at 6:00

Data Extension rows returned via SOAP call are always returned in the order in which they were added. You cannot apply any other sort(s), such as alphabetical, to your SOAP requests to retrieve them in any other order.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.