Loads Search API:/api/p/v{version}/loads/search
- Create a New Query for the
Loads SearchEndpoint:- Add a new query and give it a descriptive name, such as
Loads Search, to easily identify its purpose. - Open the query in Advanced Editor and paste the following code:
- Add a new query and give it a descriptive name, such as
- The
Loads Searchquery will retrieve data from the Alvys API and display the Loads table in Power BI. - You can explore additional details in the query results:
- On the right-hand pane, click to expand the JSON response to view total results, nested objects, or other relevant details from the API.

This query allows you to dynamically retrieve customer data filtered by their statuses or created date range. Modify the request body as needed to include additional filters or adjust the search criteria for more specific results.
Drivers Search API:/api/p/v{version}/drivers/search
- Create a New Query for the
Drivers SearchEndpoint:- Add a new query in Power BI and name it descriptively, such as
Drivers Search, to clearly identify its purpose. - Open the query in the Advanced Editor and paste the following code:
- Add a new query in Power BI and name it descriptively, such as
- The
Drivers Searchquery will successfully retrieve data from the Alvys API and display the Drivers table in Power BI.
This query allows you to filter drivers dynamically based on their status or other parameters in the request body. Modify the query as needed to adjust filtering criteria, such as fleet name or active status.
Fuel Search API:/api/p/v{version}/fuel/search
Create a New Query for the Fuel Search Endpoint:
- Add a new query in Power BI and name it descriptively, such as
Fuel Search, to easily identify its purpose. - Open the query in the Advanced Editor and paste the following code:
- The
Fuel Searchquery will successfully retrieve data from the Alvys API and display the Fuel Transactions table in Power BI.
This query allows you to filter and retrieve fuel transaction data dynamically, using parameters like fuel card number, truck number, and transaction date range. Adjust the query body to refine your search criteria as needed.
Invoice Search API:/api/p/v{version}/invoices/search
Create a New Query for the Invoice Search Endpoint:
- Add a new query in Power BI and name it descriptively, such as
Invoice Search, to identify its purpose clearly. - Open the query in the Advanced Editor and paste the following code:
- The
Invoice Searchquery will retrieve data from the Alvys API and display the Invoices table in Power BI.
This query provides dynamic filtering options like date ranges, status, and customer ID to fetch specific invoice data. You can adjust the request body to include additional filters or parameters as needed.
Maintenance Search API:/api/p/v{version}/maintenance/search
Create a New Query for the Maintenance Search Endpoint:
- Add a new query in Power BI and name it descriptively, such as
Maintenance Search, to clearly identify its purpose. - Open the query in the Advanced Editor and paste the following code:
- The
Maintenance Searchquery will retrieve data from the Alvys API and display the Maintenance Records table in Power BI.
This query allows you to filter and retrieve maintenance records dynamically based on date ranges or other parameters. You can modify the request body to adjust the search criteria or include additional filters as needed.
Toll Search API:/api/p/v{version}/tolls/search
Create a New Query for the Toll Search Endpoint:
- Add a new query in Power BI and name it descriptively, such as
Toll Search, to clearly identify its purpose. - Open the query in the Advanced Editor and paste the following code:
- The
Toll Searchquery will retrieve data from the Alvys API and display the Toll Transactions table in Power BI.
This query enables you to dynamically retrieve toll transaction data based on date ranges or other parameters. You can adjust the request body to refine your search criteria as needed.
Trailer Search API:/api/p/v{version}/trailers/search
Create a New Query for the Trailer Search Endpoint:
- Add a new query in Power BI and name it descriptively, such as
Trailer Search, to clearly identify its purpose. - Open the query in the Advanced Editor and paste the following code:
- The
Trailer Searchquery will retrieve data from the Alvys API and display the Trailers table in Power BI.
This query allows you to dynamically retrieve trailer data based on status, fleet name, or trailer number. Adjust the request body to include additional filters or refine your search criteria as needed.
Trips Search API:/api/p/v{version}/trips/search
Create a New Query for the Trips Search Endpoint:
- Add a new query in Power BI and name it descriptively, such as
Trips Search, to clearly identify its purpose. - Open the query in the Advanced Editor and paste the following code:
- The
Trips Searchquery will retrieve data from the Alvys API and display the Trips table in Power BI.
This query allows you to dynamically retrieve trip data based on parameters like status or pagination. Adjust the request body to include additional filters or refine your search criteria as needed.
Trucks Search API:/api/p/v{version}/trucks/search
Create a New Query for the Trucks Search Endpoint:
- Add a new query in Power BI and name it descriptively, such as
Trucks Search, to clearly identify its purpose. - Open the query in the Advanced Editor and paste the following code:
- The
Trucks Searchquery will retrieve data from the Alvys API and display the Trucks table in Power BI.
This query allows you to dynamically retrieve truck data based on parameters like status, fleet name, or VIN. Adjust the request body to include additional filters or refine your search criteria as needed.
User Search API:/api/p/v{version}/users/search
Create a New Query for the User Search Endpoint:
- Add a new query in Power BI and name it descriptively, such as
User Search, to clearly identify its purpose. - Open the query in the Advanced Editor and paste the following code:
- The
User Searchquery will retrieve data from the Alvys API and display the Users table in Power BI.
This query allows you to dynamically retrieve user data based on filters such as keywords or pagination. You can adjust the request body to include specific search criteria to refine your results further.
Customer Search API:/api/p/v{version}/customers/search
Create a New Query for the Customer Search Endpoint:
- Add a new query in Power BI and name it descriptively, such as
Customer Search, to clearly identify its purpose. - Open the query in the Advanced Editor and paste the following code:
- The
Customer Searchquery will retrieve data from the Alvys API and display the Customers table in Power BI.
This query allows you to dynamically retrieve customer data filtered by their statuses or created date range. Modify the request body as needed to include additional filters or adjust the search criteria for more specific results.
Visibility Outbound Errors API:/api/p/v{version}/visibility/outbound/errors
Create a New Query for the Visibility Outbound Errors Endpoint:
- Add a new query in Power BI and name it descriptively, such as
Visibility Errors, to clearly identify its purpose. - Open the query in the Advanced Editor and paste the following code:
- The
Visibility Outbound Errorsquery will retrieve data from the Alvys API and display the Errors table in Power BI. - You can explore the following columns in the result:
- Id: Unique identifier for each error record.
- ErrorMessage: Description of the error.
- Timestamp: The time the error occurred.
- ErrorDetails: Additional details about the error, if available.
This query allows you to dynamically retrieve outbound error data for visibility operations based on a specified time range. Modify the request body to adjust the date range, page size, or other parameters for tailored results.