Sage 200 UKI Ideas Portal

Extend the Power Automate Custom Connector

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
  • Feb 6 2024
  • Further Information Required
API
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
  • Tony Davis-Coyle commented
    19 Feb 09:43am

    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.

  • Admin
    Jo Kirkup commented
    12 Feb 05:13pm

    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

  • Adriana Nita commented
    12 Feb 04:02pm

    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?

  • Admin
    Jo Kirkup commented
    8 Feb 09:15am

    so for clarity are there additional API endpoints you need that are not documented as available here - https://developer.sage.com/200/reference/?

  • Adriana Nita commented
    7 Feb 02:33pm

    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.

  • Admin
    Jo Kirkup commented
    7 Feb 11:47am

    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.