API Gateway Overview

The API Gateway allows developers to easily interact with EBMS data from other applications.

Getting Started

The API Gateway allows developers to easily interact with EBMS data from other applications. Quickly read, write, and create EBMS data from applications using a standard API (Application Programming Interface). Valuable CRM, production, scheduling, marketing, reporting, and web tools can interact with back-end EBMS data.

Webhooks is basically the opposite of the API Gateway. The API Gateway allows external systems to read EBMS data. WebHooks allows EBMS to access external systems. This symmetric process uses web calls to communicate with external systems using standard web calls.

In its simplest form an API allows one application to talk to another application. With the rapid increase in mobile devices and interrelated computing devices, it is increasingly common to access back-end data from user applications using API's. The API Gateway and webhooks combination create the connector technology between EBMS data and the standardized OData REST API.

API Gateway

EBMS is an OData provider and source which gives 3rd party developers the ability to read and write EBMS data for other applications using a standardized “face”. Data such as customer account info, inventory catalog, and sales invoices are available. The API Gateway exposes select tables (entities) and fields (properties) so that they can be read, written to, and created using a url or REST API. Within the REST API standardized ODATA is used to query and JSON is used to write. A product like Postman or LINQPad can be used to test specific requests.

API Gateway Insider Series

Setup and Getting Started

Review the API Setup article for setup and getting started instructions.

Entities

Click here for a list of entities.

Code Samples

Review this article for some code samples.

WebHooks

WebHooks is basically the opposite of the API Gateway. WebHooks allows EBMS to access external systems. This symmetric process uses web calls to communicate with external systems using standard protocols.

This is an extension to the OData REST API that enables services on the internet to subscribe to events from EBMS, based user-configured conditions satisfied in new, updated and/or deleted documents and accounts. As a convenience, the EBMS client provides a user interface to view, edit and enable these subscriptions. Web services manage subscriptions primarily through EBMS' REST API and primary documentation should reside there.

Examples of web call events that be triggered through web hooks:

Invoice over $1000 processed for CASH customer
New item created by EBMS
Service Inventory Item deleted
Retail price was changed
New sale for a salesperson
Sale deleted outside business hours

Select File > System Options > Web Hooks tab from the main EBMS menu to configure webhooks.

Webhooks are launched using the following data found within the Web Hooks tab:

The webhooks process is launched whenever a record is saved within the Table Name. This table must be the header of the document. For example in the first example the ARINV table identifies the sales invoice document. Review EBMS Tables and Fields for information on identifying EBMS files and field names.
Select on of the following Action triggers:

Create: this triggers the webhook when a record is created.
Update: This action triggers the webhook when a record is changed.
Delete: This action triggers the code when a record such as a customer is deleted.

Enter a Description that identifies the webhook process.
Enable the Inactive option to disable the webhook without deleting the content. This option allows the user to conveniently pause the process temporarily.
Select the proper HTTP web call protocol:
Add the 3rd party solution's Request Headers.
Select one of the following Condition Expression Type.

CodeBase: Review Database Expressions for more details on this query language.
JavaScript: JavaScript is a common lanquage to customize EBMS. Review Integrations & Customizing EBMS for some customization examples.

Enter the Condition Expression code. Review EBMS Tables and Fields to identify EBMS information file and information codes. Review the webhooks video at the beginning of this section for some condition examples.
Set one of the following URL Expression Types:

Literal: This calls the exact URL as entered into the URL Expression.
{Field} Replacement: This option is similar to Literal but the system replaces the field name with the value for the field name. Review EBMS Tables and Fields to identify EBMS data field names.
CodeBase and JavaScript: Code can be used to create the URL if necessary.

Set the URL Expression based on the URL expression type.
Set the HTTP Payload Type and HTTP Payload Expression. These settings are needed when you are using a Post or Patch web call as set in step #5. The Payload Type and HTTP Payload Expression are kept blank for Get or delete web calls. Review the webhooks video at the beginning of this section for some payload examples.
The system records the Changed By user and Last Changed date of each webhook.

The webhooks within this table can be created by a 3rd party solution or be manually entered by a technical EBMS user to communicate to the 3rd party solution.

Security

Review Security > Overview for information on configuring security for these interface tools.

Common use cases

Interact with EBMS Data from Other Applications

Quickly read, write, and create EBMS data from applications using a standard API (Application Programming Interface). Valuable CRM, production, scheduling, marketing, reporting, and web tools can interact with back-end EBMS data.

In its simplest form an API allows one application to talk to another application. This could be used to connect EBMS data and catalog to popular shopping carts, interact with complex product configurators, give your salesman access to customer accounts from a mobile app, and interface with powerful business software to create data visualizations and reports.

For 3rd Party Developers

We are an OData provider and source which gives 3rd party developers the ability to read and write EBMS data for other applications using a standardized “face”. It is increasingly common to access back-end data from user applications using API's. The API Gateway creates the connector technology between EBMS data and the standardized OData REST API. Data such as customer account info, inventory catalog, and sales invoices are available.

Features

Standarized REST API communicated through url
Create completely serverless APIs that web and mobile applications can use to call available services.
Exposes select tables (entities) and fields (properties)
Query data using ODATA
Read, write, and create data using JSON over REST
Test specific requests using Postman or LINQPad
Flexible security controls that require authentication
Standard url for your OData endpoint such as https://[your domain]:23200/MyEbms/[company id]/OData/
Entity documentation and relational diagrams available. Access approval needed through Eagle Business Software