Solved

API into Google Sheets

  • 1 August 2023
  • 4 replies
  • 184 views
C
Rank
Userlevel 3
Badge

Hey there everyone, 

Is there a way to connect a Google sheet into an Acumatica screen to get real time data?  

icon

Best answer by darylbowman 1 August 2023, 17:19

View original

4 replies

darylbowman
Rank
Badge +11

Acumatica, specifically Generic Inquiries, supports OData.

This describes how to expose a GI to OData.

This describes how to connect Sheets to an OData feed.

Daryl ⚡Contract Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman
C
Rank
Userlevel 3
Badge

Thanks for the info.  Time to start playing!!!!

D
Rank

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? 

P
Rank
Userlevel 3
Badge

@dcobey yes I posted that in AUGforums because I was hoping someone else had discovered a way to do it. So far I have yet to see a path. Thanks for pressing on this all!

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved