This repository contains source data for data retrieval process implemented with XPath Language version 3.1 (XML). The whole process can be pictured or generally divided into the following subprocesses:
- Use OAuth2.0 (which is frequently used by big companies such as Facebook, Google and Microsoft) to securely access database with a given API key.
- Do subsequent API calls (defined with XPath and XML) to retrieve data from the database and parse data into spreadsheet.
- Use the data to generate reports (business, contacts, membership renewal, membership lapsed etc.)
The application uses OAuth2.0 authentication to gain access of the admin view of the database supported by Wild Apricot (https://www.wildapricot.com/). It retrieves contact information, auditLog items information and event registrations information from the database and utilizes the data to plot subsequent pivot charts. To guarantee the efficiency of the User Interface (UI), the program is also supported with a progress bar to indicate current progress.
The main purpose for this project is to provide a simplistic way to securely access the database and retrieve data for business analysis purposes using Excel VBA. For security reasons, the API keys used for testing is omitted. Understanding that VBA is a programming language that is intended for users primarily to automate task in excel instead of retrieving data, for better experience and performances users and analyses are encouraged to use other interactive data visualization tools such as PowerBI and Google Analytics.
Strutured business Analysis (functions include creating creating detailed charts or pivot tables to store business information so as to reckon and analyse market trend.)
Email: edtsoi@umich.edu/ edtsoi430@gmail.com
Wild Apricot Help (syntax and API calls references): https://gethelp.wildapricot.com/en
XPath References (Syntax and examples): https://msdn.microsoft.com/en-us/library/ms256086(v=vs.110).aspx