Automatically Export Reports from Lightspeed Retail POS

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.
1 comment
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?
Adrian Samuel
Software Developer
Lightspeed HQ