Call PowerServer DataWindow CRUD REST APIs from another application

Symptom

Though PowerServer Compiler automatically converts all your data access related logic to the server side and packages it into REST APIs, it is not recommended to consume those restful APIs from another application since the transmitted data is formatted in a way for optimal commutation between the PowerServer client (cloud app) and the PowerServer server side. It is not suitable for external use.

Environment

PowerServer 2021 or above

Resolution

If you are using PowerBuilder 2025 or later, you can directly create a .NET DataStore project in the IDE. For detailed instructions, refer to this link: https://docs.appeon.com/pb2025/pbug/Working_with_a_NET_DataStore_project.html

If you are using a version from PowerBuilder 2021 to PowerBuilder 2022 R3 (inclusive), please follow the instructions below:

Your PowerBuilder Cloud Pro package includes tools that designed for this scenario. The tools are included without extra charge and it is also high-automated and very flexible to expand.

So to re-use your DataWindow & SQLs in your PowerBuilder app, there are over all four steps to follow:

• Step 1. Open the PB workspace including the DataWindows that you want to reuse in SnapDevelop (the free C# IDE included in your PowerBuilder).
Right-click the solution name, and select Open PB Workspace to open your PowerBuilder application.

• Step 2. Select the targeted DataWindow objects and convert them to the C# Models with DataWindow Converter.

• Step 3. Scaffold the Service and Controller or you can add more services to your API.