How to call Omnitracs REST API in ODBC Apps like Power BI, Crystal Reports

[nayan]

In this post, we will see how to call Omnitracs API using ZappySys JSON Driver (for API and Files)

Prerequisite

1. Download and install ZappySys ODBC PowerPack (it includes JSON Driver we need)
2. After that add new ODBC DSN (see example steps here)
3. Configure your UI like below to call Omnitracs API
   Enter URL for some API call to get data. Feel free to change URL as per your need.
   Example: https://apex-prod-integration.aws.roadnet.com/integration/v1/admin/locations?identifiers=**SOMETHING**
   
   
4. Clicking on the Dynamic Token link will show something like this.
   ===Request Tab===
   URL: https://apex-prod-integration.aws.roadnet.com/integration/v1/login
   Method: POST
   Body: { "username": "[$userid$]", "password": "[$password$]" }
   Content Type: application/json
   
   
5. Now go to the Response Tab and set it below. For Json Expression enter $.token
   
6. Now go to preview Tab and select table from the dropdown and click Preview Data
   
7. That’s it. If everything goes well you will see something like below.
   

Call Omnitracs REST API in Crystal Reports

Once ODBC DSN is created, Here is how to call Omnitracs REST API in Crystal Reports. Some steps might be different based on your App Version but the concepts are the same.

Call Omnitracs REST API in Power BI

Once ODBC DSN is created, here is how to call Omnitracs REST API in Crystal Reports in Power BI. Some steps might be different based on your App Version but the concepts are the same.