Excel - Add-ins Javascript
Budget: $2 – $8 USD
Task 1: Create an Excel add-in that opens a dialog box and goes through the Quickbooks Online Oauth process. Then save realm_id, Access_token, and Refresh Token to the Firebase database (This is already set up), and the Quickbooks app is already set up (I have this working in a separate python app)
This should take anywhere from 8-15 hours
- This is how you create the folder structure of an add-in: https://learn.microsoft.com/en-us/office/dev/add-ins/quickstarts/excel-quickstart-jquery?tabs=yeomangenerator
- This explains that you need the dialogue box to do Oauth process: https://learn.microsoft.com/en-us/office/dev/add-ins/develop/auth-with-office-dialog-api
- This is Quickbooks Online Documentation on how their process works: https://developer.intuit.com/app/developer/qbo/docs/develop/authentication-and-authorization/oauth-2.0
- I can find code on how to save info to Google's Firebase Database (that is not that hard)
This should take anywhere from 8-15 hours
- This is how you create the folder structure of an add-in: https://learn.microsoft.com/en-us/office/dev/add-ins/quickstarts/excel-quickstart-jquery?tabs=yeomangenerator
- This explains that you need the dialogue box to do Oauth process: https://learn.microsoft.com/en-us/office/dev/add-ins/develop/auth-with-office-dialog-api
- This is Quickbooks Online Documentation on how their process works: https://developer.intuit.com/app/developer/qbo/docs/develop/authentication-and-authorization/oauth-2.0
- I can find code on how to save info to Google's Firebase Database (that is not that hard)