You can access various data from EBIS via its external API, allowing you to pull data into Power BI, Tableau, build your own accounting integration, etc.
Introduction
Depending on your EBIS license, it may be possible for you to access various parts of EBIS' data via the external API. This is commonly used to access information such as work order, purchase order, or over the counter totals, as well inventory data.
To obtain an access key, please send a request to support@datcomedia.com
What is Available?
Please see apidocs.ebis5.com for a list of accessible API calls.
Postman Access Example
- Determine the data point you want to use, from apidocs.ebis5.com. In this example, we will receive some work order totals.
- Create a new request and set the method to POST and set the proper URL
- In Authorization, specify "Basic Auth" as the Type and set the Username and Password to the info received from EBIS support
- In the Body, select Raw, JSON, and enter the parameters such as below:
- Press "Send" to run the query, and your results will appear below in the "Data" section of the response.
Note that if you have access errors, this will appear in the "Auth" section of the response:
If no data is found for the criteria you enter, it's common for the Data to return as a blank array:
Structure of Data
Depending on the type of data in the call and how you want to consume the data, you may have the option to output the data as either flat or nested. Please see the individual API call in the API docs for more.
Consuming Data and Processing On Your End
Once you have accessed your data, you can incorporate this access into applications such as Power BI or Tableau.
If you are looking to do take this data, and process it accordingly and post it into another application, you may want to look at the Javascript AXIOS example on the API docs homepage.
For accounting purposes, the most commonly used calls would be:
Other Notable Items:
Note that we have additional external API calls on our roadmap for late Q2/early Q3.