recently-created-customers.js

var SquareConnect = require('square-connect');
SquareConnect.ApiClient.instance.authentications['oauth2'].accessToken = 'sq0atp-XXXX';

var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database('./database.db');


var apiInstance = new SquareConnect.CustomersApi();

var today = new Date();
var yesterday = new Date();
yesterday.setDate(today.getDate() - 1);

body = {
    'limit': 1000,
    'query': {
        'filter': {
            'created_at': {
                'start_at': yesterday.toISOString(),
                'end_at': today.toISOString(),
            },
        },
    },
};

apiInstance.searchCustomers(body).then(function(data) {
    if (data.customers) {
        data.customers.forEach(function(element) {
            db.run('INSERT into Customers (id , created_at , updated_at , synced_at ,given_name , family_name , email_address , creation_source ) VALUES( $id,  $created_at,  $updated_at, $synced_at, $given_name, $family_name , $email_address , $creation_source )', {
                $id: element.id, $created_at: element.created_at, $updated_at: element.updated_at, $synced_at: today.toISOString(), $given_name: element.given_name, $family_name: element.family_name, $email_address: element.email_address, $creation_source: 'Square: ' + element.creation_source,
            });
        });
    }
}, function(error) {
    console.error(error);
});