salmon.php

<?php

add_action( 'rest_api_init', function () {
  register_rest_route( 'salmon/v1', '/salmonnames', array(
    'methods' => 'GET',
    'callback' => 'get_salmon_names',
  ) );
} );



function get_salmon_names( $data ) {
  global $wpdb;
  $results = $wpdb->get_results( 'SELECT * FROM table', OBJECT );


  $names = array();

  foreach($results as $result) {
    $names[] = $result->name;
  }

  return $names;
}