We're looking to extract P&L and Balance Sheet data from Sage200 to use in a cloud based system for planning and analytics. As we're trying to access the data via the Power Automate custom connector to the Sage200 API, we found we do not have access to the endpoints here: Transactions | Sage Developer.
Adriana Nita
| Idea Benefit | Sage200 would become the source of truth for powerful planning and analytics base don transaction level information. It would make the integration seamless without the need for additional servers and file transfers... |
| How do you solve for this problem today? | Today the data transfer is made manually: user exports reports from Sage and loads them in the cloud based system |
| Product Variant | Sage 200 Professional |
I'd suggest using the Microsoft On-Premise Data Gateway for this. You can create custom views in SQL, and pull data directly using Power Automate.
Attachments Open full size
For specific support questions please raise on sage community hub https://communityhub.sage.com/gb/sage-200 or you can email our developer support team on developer.programme@sage.com
Attachments Open full size
I’ve asked the developer to take a look at the existing API again as I’ve seen in the custom connector’s list of references the nominal_period_value_view and was thinking maybe using that in conjunction with the GetNominalCodes would give us the monthly values per nominal. He wasn’t able to figureniut how to use that, do you guys have a guide or instructions of some sort you could share? Or are we looking at a completely different thing here?
Attachments Open full size
so for clarity are there additional API endpoints you need that are not documented as available here - https://developer.sage.com/200/reference/?
Attachments Open full size
Thank you for your comment, Jo!
Yes, we would need something similar for our customer's Sage 200 environment. We need to be able to "seamlessly" extract data without setting up servers and file transfers to make it work, if at all possible.
Attachments Open full size
The helpfile you have provided is for Sage Accounting, this is a different product.
Sage 200's APIs endpoints can be found here - https://developer.sage.com/200/reference/
I am fairly certain we don't have the endpoints you need currently exposed but please check the helpfile & confirm.
Attachments Open full size