Using orderByColumns

This allows you to specify the sorting (ASC or DESC) order in which rows appear in the response data and the Primavera Data Service will respect the order of columns provided by user.

Example 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 DESC",
            "ITEMTYPEID DESC",
            "FIELDTYPEID DESC"
         ]
      }
   ]
}