Skip to main content
Main menu
AMS Cloud Status
Product Info
Community
Contact Us
Mailing List / RSS Feed
Privacy Policy
Search form
Search
Installing Theatre Manager
Upgrading Theatre Manager
Quick Reference Guides
Self-Guided Demo Tutorial
Theatre Manager Online Help
Form Letters and EBlasts
Facility Management
Reports
Reveal Dashboards
REST API Overview
Requirements for REST API access
Logging in to the REST API
REST API Top Level Endpoints
REST API accessing images
REST API Output Formats
REST API Sorting data
REST API Querying for Specific Results
REST API Selecting Columns
REST API Adding Relationships to Other Tables
REST API - showing relationships
REST API summarizations, aggregations and groupings
REST API full syntax
REST API Some Fun Queries:
Accessing Calendars From Web Site
Web Page Documentation
Frequently Asked Questions
Theatre Manager: Responding to COVID 19
Newsletters
AMS Cloud Status
Product Info
Community
Contact Us
Mailing List / RSS Feed
Privacy Policy
You are here
Home
›
REST API Overview
›
REST API Adding Relationships to Other Tables
REST API - showing relationships
If you just wish to show the other tales that are related to a specific table, you can show an
endpoint
(like orders or carts or patrons) and add /related to the url. eg:
https://127.0.0.1/api/v1/orders/related
Other Examples:
https://127.0.0.1/api/v1/orders/related
Relationships for orders
https://127.0.0.1/api/v1/patrons/related
Relationships for patrons
https://127.0.0.1/api/v1/carts/related
Relationships for all cart related items
https://127.0.0.1/api/v1/orders/related?group=type+refers_to&agg=count&sort=-type
Count of other tables that refer to orders by adding aggregate,
sort
and grouping functions
Diataxis:
How To
‹ REST API Adding Relationships to Other Tables
up
REST API summarizations, aggregations and groupings ›
Printer-friendly version