By using this website, you agree to our Terms of Use (click here)
I'm relatively inexperienced with Acumatica and VERY inexperienced with coding outside of the minimal self-teaching I've done.
I've been tasked with housing a report in Google Sheets so that the entire organization can access the information. I've seen on this blog how to create a connection between Excel and Acumatica, but due to the purpose of this report, it'll need to be in Google Sheets. The data is protected so a log-in/verification is required, as is creating a XML XPath query (as formatted in Google Sheets).
Has anyone done this before? Or can anyone give me resources to study up on XML/XPath code?
Thanks
I'm not sure how it would be done. You could accomplish the same thing with OneDrive and Excel Online, but it doesn't look like that is an option.
You could build the report in Excel using OData to pull from Acumatica, then use Power Update (click here) to automatically refresh the report and put it in a Windows folder that is synced with Google Drive. The end result would be an automatically refreshed report that appears in Google Drive. Technically it's an Excel report, but Google Drive knows how to open Excel reports.
Just read about this, looks like Google spreadsheets can't handle this integration yet. More on this on Acumatica feedback https://feedback.acumatica.com/ideas/ACU-I-835 .... Only option for now as Tim mentioned to sync data from Excel to Google spreadsheet or use 3rd party tools like https://www.import.io/
Online Members
