Reorder OData columns in or from a query

(0) Share

Report

Posted on by J-G

130

When constructing an OData query, is it possible to change the order the data is aligned and presented in? I'm trying to get some data from multiple objects using the expand command, with the end result being a CSV file. However, the file format I have to abide by doesn't align with the way the objects need to be accessed. I need some data from one object, data from another object, and then different data from that first object. Is there any way to do a query like $select {object 1 data}, $expand {object 2 data}, $select {object 1 data}, or will I have to do some post-query formatting to get it to align properly?

As additional reference, here's an example of the way the CSV columns map to their locations in the objects I'm referencing.

data from object 1, data from object 1, data from object 2, data from object 1, data from object 3, etc.

All responses (2)

Answers (1)

J-G 130 on at

Like (0)

Report

Re: Reorder OData columns in or from a query

Thank you for the help! Do you know the accepted method for arranging data that way? Is there an option in the 'Create CSV Table' action for example that lets you determine the column order, or is it just based on the order of data labels in the input?
Verified answer

cchannon 4,702 Super User 2025 Season 1 on at

Like (1)

Report

Re: Reorder OData columns in or from a query

No, there is no OData query parameter that will let you dictate the order of columns. You're going to have to process the data manually after retrieving results.