Using orderByColumns
This allows you to specify the sorting order in which rows appear in the response data and the Primavera Data Service will respect the order of columns you provide. Primavera Data Service supports ascending order only.
Example Simple Query Using orderByColumns
Request
{ "name":"Get budget cell view data", "pageSize":"10000", "tables":[ { "tableName":"UNIFIER_BUDGETCELL_VIEW", "columns":[ "ITEM", "US_VALUE", "FIELDTYPENAME", "FIELDTYPEID", "X", "BFIELDNAME", "CODE", "VALUE", "Y", "FIELDTOTALMODE", "FIELDDISPLAYMODE", "BITEMID", "BFIELDID", "BUDGETID", "ITEMTYPEID", "FIELDFORMAT" ], "orderByColumns":[ "BUDGETID", "ITEMTYPEID", "FIELDTYPEID" ] } ] }