Automatically Export Reports from Lightspeed Retail POS

rishi

Is there a workaround to automatically export reports from lightspeed retail pos? Perhaps via the API??

At the moment I do not have a need for Lightspeed Analytics, but simply being able to automatically fetch the export CSV's would be very helpful.

I'd like to have them upload directly into Google Sheets.

I know each export button in lightspeed has its own url, which if you go to directly and you're already authenticated in lightspeed, it will download the file directly. Can this be utilized somehow?

One option I'm thinking is to create a macro, but before I do this, I'm wondering if there's a better way.

Adrian Samuel

Hey @rishi,

The API would be the best way about doing this!

Here's a link to our documentation

Were you successful in this endeavour?

rishi

I was not, could you help me achieve this? @Adrian Samuel