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"
         ]
      }
   ]
}