Hey there everyone,
Is there a way to connect a Google sheet into an Acumatica screen to get real time data?
Solved
API into Google Sheets
Best answer by bwhite49
Missy Main on the support team helped me get this working in 2024 R2. in 2024 R2 the Odata URLs have changed to accommodate the new version.
URLs should now look like this to support OData V4: https://((Company)).acumatica.com/t/((Tenant))/api/odata/gi
https://help.acumatica.com/(W(7))/Help?ScreenId=ShowWiki&pageid=7e92b45b-3610-4498-9898-24110bfccae3
+13Daryl ⚡Contract Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman
Thanks for the info. Time to start playing!!!!
This doesn’t seem to work.
For example, see: https://www.augforums.com/forums/acumatica-odata-with-microsoft-excel-and-power-bi/connecting-acumatica-to-google-sheets-via-odata-feed/
Has anyone gotten it to acumatica to google sheets to work?
1 person likes this
+1Missy Main on the support team helped me get this working in 2024 R2. in 2024 R2 the Odata URLs have changed to accommodate the new version.
URLs should now look like this to support OData V4: https://((Company)).acumatica.com/t/((Tenant))/api/odata/gi
https://help.acumatica.com/(W(7))/Help?ScreenId=ShowWiki&pageid=7e92b45b-3610-4498-9898-24110bfccae3
1 person likes this
Please don’t shoot me….. we are on 2023R2.
Will this google sheets connection work on this release or do I need to find older documentation for the url format?
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.