Norming Asset Management API

REST interface to the AMASST table in Sage 300 / Norming Fixed Assets

v1.0 10 Endpoints Connected

—

Total Assets

—

Active

—

Disposed

—

Total Book Value (BWP)

—

Net Book Value (BWP)

—

Accum. Depreciation (BWP)

Database Configuration

SQL Server Instance / Host

Port

Database Name

Use Windows Integrated Security

SQL Username

Password

Asset Table Name

Timeout (s)

Trust Server Certificate (recommended for dev)

Connection String Preview

Fill in the fields above…

API Endpoints

Open Swagger ↗

Asset Data

GET

/api/assets List all assets · pagination + filters

↗

GET

/api/assets/{assetNo} Get single asset by ASTNO

↗

Write Operations

POST

/api/assets Create a new asset record

PUT

/api/assets/{assetNo} Full replacement update · single asset

PUT

/api/assets Bulk full update · up to 500 records

PATCH

/api/assets/{assetNo} Partial update · only fields provided

PATCH

/api/assets Bulk partial update · multiple assets

Lifecycle Actions

POST

/api/assets/{assetNo}/dispose Dispose / retire an asset (STATUS→9)

POST

/api/assets/{assetNo}/transfer Transfer to new location / cost centre

Audit

GET

/api/assets/{assetNo}/history Audit trail for a single asset

↗

GET

/api/assets/stats Aggregate statistics

↗

Assets by Category

Assets by Location

Quick API Tester

Depreciation Methods in Use