Trying to make the API integration a little simpler for node.js

ENV File

AppSheet Setup

| Environment Variables | Example Value | | --- | --- | | APPSHEET_APP_ID= | | | APPSHEET_KEY= | | | APPSHEET_SEND_MAIL= | true/false | | SMTP_HOST= | | | SMTP_USER= | | | SMTP_PASS= | | | SMTP_PORT= | | | SMTP_SUBJ= | | | SMTP_DISP= | | | SMTP_RECP= | |

AppSheet API Documentation

API: The Essentials

Functions

Check if the module has loaded.

appsheet.api.test()

Add to Appsheet Table.

AppSheet API Add Documentation

appsheet.api.add(tableName, rows)

Retrieve from Appsheet Table.

AppSheet API Find Documentation

Structure

appsheet.api.find(tableName, selector, rows).then(res =console.log(res)).catch(e =console.log(e))

Example Find Function

function findAppSheetData() {
 const tableName = "MyTable"
 const stringValue = "Luciano"
 const columnName = "FirstName"
 const selector = "FILTER(tableName, CONTAINS(stringValue, columnName))"
>
 appsheet.api.find(tableName, selector).then(res ={
   console.log(res)
 })
}

Request Properties.

Invoking the API

api.properties.set(key, value)
api.properties.set('Location', "-27.5, 153.0")
api.properties.set('UserSettings', { Name: 'Ben Carless'})

Adding class to support multiple instances

const { appsheetClass } = require('appsheet')

var appkey = ""
var appid = ""

module.exports = {
  app: new appsheetClass(appid, appkey)
}