GET ./reports/scholarships

Tags: simple-query, pagination

Report to determine which students should receive scholarships. Returns students and their average of the grades for the selected intervals.

GET parameters

Name	Value Type	Validation	Details
ascID	int	Required	School year ID.
sanID	int	Optional	Semester ID.
cicluID	int	Optional	School cycle ID.
astID	int	Optional	Study year ID.
clID	int	Optional	Class ID.
dateStart	rfc_date	Optional	Start date for grades selection.
dateEnd	rfc_date	Optional	End date for grades selection.

Excel

To export the report in excel format use GET ./reports/scholarships/export_xls It allows the same parameters as the main endpoint but it ignores _limit, _offset and _order parameters.

Output example

{
  "meta": {
    "countTotal": "257",
    "countData": "25",
    "countOffset": "0"
  },
  "data": [
    {
      "gradesNo": "3",
      "gradesAvg": "10",
      "student": {
        "uaID": "152458",
        "uaTip": "1",
        "uaFirstName": "narcis",
        "uaLastName": "abobei",
        "uaSex": "1",
        "prefAvatar": null,
        "roles": [
          {
            "roleID": "13",
            "roleName": "Elevi"
          }
        ],
        "clasa": {
          "clID": "470",
          "clNume": "XI C",
          "ascIsActiv": "1",
          "ascNume": "2023/2024"
        }
      }
    },
    {
      "gradesNo": "1",
      "gradesAvg": "10",
      "student": {
        "uaID": "159793",
        "uaTip": "1",
        "uaFirstName": "Irina Daniela",
        "uaLastName": "Amarița",
        "uaSex": "2",
        "prefAvatar": null,
        "roles": [
          {
            "roleID": "13",
            "roleName": "Elevi"
          }
        ],
        "clasa": {
          "clID": "455",
          "clNume": "X D",
          "ascIsActiv": "1",
          "ascNume": "2023/2024"
        }
      }
    }
  ]
}