API Report Automation Utility


Project Description

A custom .NET Core application that runs on a scheduled task to automatically download data from the Black Diamond Wealth Platform API and securely move the data to a destination on the local network. The routine is scheduled to run via a Windows Scheduled Task and begins by authenticating against the Black Diamond API. It then issues a request to instruct the API to begin generating the data report. Generating this custom business data report takes the Black Diamond system around 15 minutes. During this time the application we developed queries the API periodically to check for completion of the report generation. Once the report is marked as completed the application downloads the report, formats it according to specifications, and moves the data file to the appropriate destination on a file server on the local network.

Major Features

  • Automatically authenticates with the API, requests a valid token as needed to facilitate the retrieval of wealth management portfolio reports.
  • Runs on scheduled tasks multiple times per day to generate the reporting data.
  • Securely manages encrypted API account credentials
  • Downloads the resulting data, saves it to the local drive specified in the configuration file.

Martin Pellicore is the President and Founder of Pell Software, LLC, an award-winning custom business software development company whose 100% US-based engineers have built and maintained thousands of custom applications and integrations. Martin graduated from Lewis University with a degree in Computer Science and a minor in Philosophy. He and his team work hard to build strong, authentic relationships with clients to provide insight and consulting/advice in addition to valuable software solutions. Outside of software development, Martin enjoys playing soccer, learning about business strategy and development, and connecting with other entrepreneurs. He also delights in spending time with his wife and their golden retriever, Montgomery. President and Founder of Pell Software, LLC.

Contact Us

Reach out today to get a free consultation for your next project

  • Client-oriented
  • Results-driven
  • Independent
  • Problem-solving
  • Competent
  • Transparent

Schedule Free Consultation

Name(Required)