REST API Selecting Columns

You can select specific columns by adding only= to the parameter line. The names of the fields for the particular endpoint must be known and these can be determined by looking at the columns returned for a particular record or page of records.

Each column you want to see in your output is separated with a + (plus sign)

Examples:

• https://127.0.0.1/api/v1/patrons?only=first_name+last_name+company - show first, last and company from the patron table
• https://127.0.0.1/api/v1/events?only=id+year+title+total_sold+sales_notes - show id, year, title, total_sold (to all performances) and sales notes from the event