Is it possible to use the API to retrieve the export csv file report in purchase orders?
Unfortunately, this is not possible with the API. You only can do this manually through the back office.
Thanks for the response.
Is it possible to use the API to GET all the purchase order information into a google sheet let's say, so rows with the PO ID, Status, Vendor, Notes, Custom Fields, Dates, #Ordered, #Received, $Total Ordered, $Total Received, etc.
As well, is it possible to use google apps/scripts to connect with Lightspeed's Retail API without OAuth 2?