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
+17Acumatica, specifically Generic Inquiries, supports OData.
This describes how to expose a GI to OData.
This describes how to connect Sheets to an OData feed.
Translate
Thanks for the info. Time to start playing!!!!
Translate
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?
Translate
Translate
+12Missy 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
Translate
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?
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.