PAC Control REST API Code Samples for SNAP PAC

• A C# sample that reads a point and returns the response JSON as a string
• Insert Tag Values into an Access® database
  • An interactive Microsoft® Access database that builds commands to read data from an Opto 22 SNAP PAC controller. Written and video instructions provided.
• Insert Tag Values into an Excel® spreadsheet
  • Sample Excel spreadsheets you can use to read from and write to an Opto 22 SNAP PAC controller. Written and video instructions provided.
• OptoTutorial: Using the SNAP PAC REST API with Excel
  • Step-by-step instructions to create an Excel worksheet that:
    • Reads and writes to input and output points
    • Parses JSON text strings
    • Checks for input and returns errors
    • Collects data on an automated interval and displays it in an Excel chart
• Use OPENJSON to Insert Tag Values into a SQL Server® 2016 table
  • Calls an endpoint on a SNAP PAC controller, and then inserts the data into a temp table
  • Requires Microsoft® SQL Server 2016

For more samples, visit:

• OptoForums Code Samples and Tips
• OptoForums Node-RED