Node 1 - Express and Knex

Last reviewed on March 5, 2018

GET /api/artists

This endpoint should return all artists. Map the results returned from the SQLite database so that the response looks like the following:

  { id: "1", name: "AC/DC" },
  { id: "2", name: "Accept" },
  // ...

You find the following links helpful:

GET /api/artists?filter=a

Modify GET /api/artists so that it accepts a query string parameter called filter. If this query string param is present in the request, only return the artists where the name contains that value. This should be case insensitive. If the query string param isn’t present in the request, return all artists.

You find the following links helpful:


Push up your code including the SQLite database to a GitHub repository named (itp405-express). You should already have connected your GitHub repository to Heroku for automatic deployments in class. Verify that your app has been deployed and it works on Heroku. Send an email to me and the TA with the repository URL and the URL to the live site on Heroku.