How can we plug in?

in Development
We are trying to gain access to the Lightspeed backend for uploading catalogs and customer info without having to submit a ticket. We primarily use VBA because of our excel data. How can we interact with the Lightspeed databases using VBA? where do we begin? can you recommend a book?
A. OAuth2 protocol through VBA?
B. XML or JSON ?
Answers
Here's a link to get started with --> https://retail-support.lightspeedhq.com/hc/en-us/articles/229129268-Understanding-the-API. The Retail API is documented and has working examples. Good luck!
@riverwood, you'll still need to do the OAuth protocol and then send the data into Lightspeed in either XML or JSON.
I'm of the opinion that it would be easier to sync your data from excel into some kind of server and then program that authentication and data transfer
If you want simplicity, it looks like Excel provide a way for you to build apps natively into the interface: https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-overview
Adrian Samuel
Software Developer
Lightspeed HQ