Improved Software List API:
Subject: Feature Request: Enhanced Software List API for Power BI Integration
Dear SolarWinds,
I am writing to request a new feature for your software list API that would greatly enhance its usability for Power BI integration. I am currently trying to build a department-filtered list of software in Power BI and encountering limitations with the current API capabilities. If at the very least allowing these options in columns.
Current Functionality:
- The API can only pull the list of software itself.
Desired Functionality:
- Filter by Department: The ability to filter the software list by department directly within the API call would significantly improve workflow and data accuracy.
- Daily Power BI Update: Seamless integration with Power BI for automatic daily updates of the software list would greatly reduce manual data refresh steps.
- Expanded Information on Demand: Instead of requiring navigation to a new URL, clicking on a software name or a quick-view option within the API response would be incredibly helpful. This would allow for easily pulling details like computer/IP, logged-in user, site, and department directly into Power BI reports.
Benefits of Implementation:
- Increased Efficiency: Automating data filtering and updates within the API would save significant time and effort compared to manual processes.
- Improved Data Accuracy: Filtering by department directly in the API would eliminate potential filtering errors in Power BI.
- Enhanced Reporting: Accessing additional information on demand within the API response would enable richer and more insightful Power BI reports.
Overall Impact:
Adding these features to the software list API would significantly enhance its value for users like myself who rely on Power BI for data analysis and reporting. It would streamline workflows, improve data accuracy, and enable more comprehensive reporting capabilities.
Thank you for your time and consideration of this request. I am confident that implementing these features would greatly benefit both myself and many other users.
Sincerely,
Nicolai Laquaglia
{
"software": {
"id": "1",
"name": "Google Chrome",
"tag": "software tag",
"manufacturer": "Google LLC",
"version": "0.0.0",
"category": "Google softwares",
"vendor": {
"id": "1",
"name": "Google",
"address": "address description",
"country": "US",
"city": "Texas",
"zip": "1",
"tech_support": "+000000000",
"business_phone": "+000000000",
"url": "www.google.com",
"created_at": "2020-01-01T00:00:00.000+01:00",
"updated_at": "2020-10-01T00:00:00.000+01:00"
},
"installs": 1,
"created_at": "2020-01-01T00:00:00.000+01:00",
"updated_at": "2020-10-01T00:00:00.000+01:00"
}
}