sage 100 ERP的sData REST API [英] sData REST APIs for sage 100 ERP

问题描述

我有一个商业伙伴帐户.而且，我在窗口服务器计算机上设置了Sage SData和Sage ERP 100.我可以在浏览器中访问一些资源，例如:

I have a business partner account. And, I have setup sage SData and Sage ERP 100 on window server machine. I can access some resources in the browser like:

https://sage.lvh.me/SData/MasApp/MasContract/ABX/AR_Customer

它返回一个巨大的XML文件. 我的问题是 我需要将Sage ERP与我的Rails应用程序集成.哪个可以从Sage ERP获取产品，还可以从Rails应用程序订购这些产品?

It returns a huge file of XML. My problem is that, I need to integrate Sage ERP with my Rails application. Which will fetch products from Sage ERP and also make order for those products from rails application?

因此，我需要一个完整的示例API请求，该请求在请求中接受一些参数(例如页面，页面，请求GET或POST的类型)并返回可解析的XML/JSON响应.

So, I need a complete sample API request which accepts some parameters (like page, perpage, type of request GET or POST) in request and return parseable XML/JSON response.

在这方面的任何帮助将不胜感激.

Any help in this regard will be appreciated.

推荐答案

我对SData不熟悉.但是我确实找到了一个可以帮助您的链接:

I'm not familiar with SData. But I did find a link that will help: https://sagecity.na.sage.com/support_communities/sage100_erp/f/sage-100-business-object-interface/72926/sdata-install-training

从阅读中看，它看起来并不真正成熟.

From the read, it doesn't really look mature.

我使用SOTAMAS90 ODBC DSN读取Sage 100数据，并使用业务对象接口(BOI)将对象写回到Sage100.对于读取数据，您就像使用任何ODBC数据源一样进行读取，只需提供连接字符串" DSN = SOTAMAS90; UID =; PWD =;公司= ABC"

I use the SOTAMAS90 ODBC DSN to read Sage 100 data, and the Business Objects Interface (BOI) to write objects back to Sage 100. For reading data, you just read like with any ODBC data source, providing the Connection string "DSN=SOTAMAS90; UID=; PWD=; Company = ABC"

要写回Sage，通常需要使用BOI，BOI是随Sage一起安装的COM对象. BOI论坛上有大量示例代码，位于以下位置: https://sagecity.na.sage.com/support_communities/sage100_erp/f/sage-100-business-object-interface .

For writing back to Sage you would typically use the BOI, which is a COM object that gets installed with Sage. There is a ton of sample code on the BOI forum, which is here: https://sagecity.na.sage.com/support_communities/sage100_erp/f/sage-100-business-object-interface.

祝你好运.让我们知道您是否需要更多帮助.

Good luck. Let us know if you need more help.

亚伦

这篇关于sage 100 ERP的sData REST API的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！