server.js

const express = require('express');
const bodyParser = require('body-parser');
const app = express();
const PORT = process.env.PORT || 5000;

app.use(bodyParser.json());
app.use(express.static('www'));

app.get('/property', (req, res) => {
    let sql = "SELECT * FROM salesforce.Property__c WHERE Status__c='Available'";
    return db.query(sql);
});

app.get('/property/:id', (req, res) => {
    let sql = "SELECT * FROM salesforce.Property__c WHERE id=$1 AND Status__c='Available'";
    return db.query(sql, [req.params.id]);
});

app.get('/broker', (req, res) => {
    let sql = "SELECT * FROM salesforce.Broker__c";
    return db.query(sql);
});

app.get('/broker/:id', (req, res) => {
    let sql = "SELECT * FROM salesforce.Broker__c WHERE id=$1";
    return db.query(sql, [req.params.id]);
});

app.listen(PORT, () => console.log(`Server listening on ${ PORT }`));