courses routes proposal

[natebrennand]

current routes:

dumps records for each section of a course http://data.adicu.com/courses finds all sections for each course and combines for one record http://data.adicu.com/courses/v2/sections contains all info for a course as well as all sections http://data.adicu.com/courses/v2/courses

proposed routes:

apply filters on columns, includes all data including description and sections list http://data.adicu.com/courses/ find options for columns http://data.adicu.com/courses/options/< ATTR NAME > find an individual core (helps with #32) would return all course info w/o section list `http://data.adicu.com/courses/call/< number >

thoughts? CC @brishin @rbtying @danrschlosser @anshulkgupta

[brishin]

Could you explain what find options means?

Does that mean that I can filter /courses with query parameters?

[natebrennand]

For example, on the housing endpoints I can get all the options for a certain attribute. There are certain uses for this as well as it makes building queries easier when you can figure out what all the possible options actually are.

/housing/buildings/options/building
{
    attribute: "building",
    results: [
        "47 Claremont",
        "548 West 113th",
        "600 West 113th",
        "Broadway",
        "Brownstones",
        "Carman",
        "East Campus",
        "Furnald",
        "Harmony",
        "Hartley",
        "Hogan",
        "John Jay",
        "McBain",
        "River",
        "Ruggles",
        "Schapiro",
        "Wallach",
        "Watt",
        "Wien",
        "Woodbridge"
    ],
    status: 200
}

[rbtying]

so "options" <-> "SELECT DISTINCT"?

On 07/03/2014 09:09 AM, Nate wrote:

For example, on the housing endpoints I can get all the options for a certain attribute. There are certain uses for this as well as it makes building queries easier when you can figure out what all the possible options actually are.

/housing/buildings/options/building { attribute: "building", results: [ "47 Claremont", "548 West 113th", "600 West 113th", "Broadway", "Brownstones", "Carman", "East Campus", "Furnald", "Harmony", "Hartley", "Hogan", "John Jay", "McBain", "River", "Ruggles", "Schapiro", "Wallach", "Watt", "Wien", "Woodbridge" ], status: 200 }

— Reply to this email directly or view it on GitHub https://github.com/adicu/data.adicu.com/issues/106#issuecomment-47950259.

Robert Ying

B.S. Candidate in Computer Science Undergraduate Researcher, Columbia University Robotics Group Engineering Student Council Academic Affairs Representative Teaching Assistant, COMS W3157 Residential Advisor, John Jay 6 Phone: (408) 982-7485 (cell) Email: rbtying@aeturnalus.com

[natebrennand]

yes, but it only returns values from the specified column