How can we plug in?

riverwood

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 ?

gregarican

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!

Adrian Samuel

@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