News


Components - Web Api R4

Updated: 02.07.2020 12.18.56

Introduction Appframe R4 provides a RESTful interface to its database and framework functionality. Built while strictly following the REST architecture and its constraints, even the commonly ignored HATEOAS constraint. Access via HTTPS, optionally using our .NET client library. Da ...

Read more...

Web Scheduler - Scheduler

Updated: 01.07.2020 11.51.05

Web Scheduling is hosted on web backend. It allows for executing predefined jobs. The easiest way to define your job is using code modules. But you do not need to do that if stored procedure execution is enough for you. You can use Appframe built-in jobs types like SQLProcedure or QueueProcessor. Bel ...

Read more...

Web Scheduler - Queues - System queue

Updated: 01.07.2020 11.42.37

System Queue is a specialized fail safe queue. You insert records into stbl_System_Queue and in turn SystemCallProcessor job will handle the message by calling static .net methods. Since This table is a regular queue table it does not have any views or triggers, so final users will never have access ...

Read more...

2. Web - Appframe Data API

Updated: 01.07.2020 09.37.27

The Appframe Data API can be used to perform CRUD operations on all views and to execute procedures available to the af_user role in the database . ...

Code modules - Code Modules 365

Updated: 29.06.2020 07.44.35

Code modules in Pims365 Code modules usually are used as RouteHandlers, Data Import/Export and Jobs Examples bellow are created using Pims365 Minimal example of a RouteHandler A standard RouteHandler as of 2019 uses RouteHandlerBase instead of the previous ReusableRouteHandlerBase Like all good tut ...

Read more...

4. Flutter - 3. Appframe API Resources

Updated: 17.06.2020 18.32.20

Installation 1. Add dependency Add this to your pubspec.yaml under dependencies: appframe_api: git: url: 'https://981b027dc46f4c36e26ae91eeeb88e61af1e3321@github.com/Omega365/flutter-appframe-api.git' ref: 'v2.0.0' 2. Install it You can now install the package from the command ...

Read more...

4. Flutter - 1. Getting started

Updated: 17.06.2020 18.24.38

System RequirementsTo install and run Flutter, your development environment must meet these minimum requirements: Operating Systems: Windows 7 SP1 or later (64-bit) Disk Space: 400 MB (does not include disk space for IDE/tools). Tools: Flutter depends on these tools being available in your environmen ...

Read more...

6. Setup and configuration - Cookies explained

Updated: 17.06.2020 07.23.46

Appframe auth Cookies explained The below flow-chart outlines how the client (browser) and Appframe server interact relating to cookies. This is mainly to describe how Appframe works related to the new SameSite requirements and CSRF attacks. See bottom of diagram for 3 examples of how ...

Read more...

Code modules - Code Modules

Updated: 17.06.2020 06.50.18

Code modules usually are used as route handlers. Examples bellow are created using Pims R4 Minimal example of code module Response type will be text/html. Route will be available public. using Appframe.Web.Context; using Appframe.Web.Registries.Attributes; using Appframe.Web.RouteHa ...

Read more...

6. Setup and configuration - Enabling WCF

Updated: 16.06.2020 07.37.17

To enable WCF as a replacement for .Net remoting in your solution, you need to update web.config of your site and include Appframe.WCFService as http module to be loaded. Update Appframe to the latest version Add <system.serviceModel> configuration to web.config if it ...

Read more...

1. Appframe Updates - Release Notes

Updated: 15.06.2020 12.43.06

Overview An overview of changes to a specific release can be found here: Workflow Items Register Use the Milestone column to filter out items related to a specific release. Appframe milestones are named by year and week number "AF YY.WW" ie. "AF 20.17" Release Summary May 2020 ...

Read more...

Graph API - Web App

Updated: 12.06.2020 05.32.40

Pims R4 Dev Web App The Web application in Pims R4 Dev with id: msgraphapi uses the Microsoft MSAL library to integrate with Microsoft Graph API. Setup is required On load the app will try to authenticate and show an Office365 Popup to the user, if the user is authenticating against with Pims R4 wit ...

Read more...

Graph API - Setup

Updated: 12.06.2020 05.26.14

When you have a code module that will interact with Microsoft Graph API you need to register an application in Microsoft Azure AD, set permissions and choose if the integration should be "on behalf of a user" or by then end user logged in to Pims (requires that the end user in Pims is authentication ...

Read more...

5. Developer Tools - DB Updater v4

Updated: 12.06.2020 05.25.02

Overview Updater v4, formerly known as Namespace deployer, is available in R4 systems since 22 April 2020. This means that it is possible to subscribe to updates from other databases by subscribing to individual namespaces. Namespace can be applied to these objects in Appframe: ...

Read more...

Web Scheduler - Queues

Updated: 11.06.2020 13.58.35

Queues As mentioned in web scheduling article, queues deliver asynchronous trigger promise. So you should be able to do something from inside of the trigger in a deferred execution manner. So instead of executing some code in trigger directly, you insert data into a queue table. Data is then fetched ...

Read more...

Power BI - Web API Connect

Updated: 10.06.2020 08.17.14

Introduction Will set up Power BI to retrieve data from Web API and end result look similar to example picture below Setting up data source Clicking on "Get data ↓ " will open "Common data sources" From there select "Web". If in your Power BI Common data sources not ...

Read more...

.Net Code - Web API - CRUD operations

Updated: 10.06.2020 07.09.59

Get Items List To get all your view/table rows require GET Request with Accept: application/json otherwise, response will be returned in text/html. Example URL: https://api.yourhost.com/[api_resource_name] Resources and their names found in Appframe -> Web API Resources: ...

Read more...

4. Flutter - 6. Appframe Authentication

Updated: 05.06.2020 12.09.01

Installation1. Add dependencyAdd this to yourpubspec.yamlunderdependencies: appframe_authentication: git: url: 'https://981b027dc46f4c36e26ae91eeeb88e61af1e3321@github.com/Omega365/flutter-appframe-authentication.git' ref: 'master'2. Install it You can now install the package from the c ...

Read more...

4. Flutter - 2. AppCenter.ms integration

Updated: 05.06.2020 10.08.36

Describes how to prepare and configure your flutter project for continuous delivery using AppCenter.ms services. ...

.Net Code - Handling Refresh Data Source Error

Updated: 05.06.2020 08.09.52

When performing afDataObject.RefreshDataSource/RefreshDataSourceAsync if an error is encountered by default it is handled inside of the control using CR3.HandleException. If this functionality is not wanted the developer, he can set afDataObject.ThrowExceptionOnRefreshError property to true and the ...

Read more...

Graph API - Codemodule

Updated: 04.06.2020 09.04.41

Pims R4 Dev have an example code module "api/graphapiauthentication" that will authenticate against the Microsoft Graph API and provide an Access Token that you need in order to integrate against for example the One Drive service. This code module uses the "on behalf of a user" concept. The Micr ...

Read more...

Placeholder "LocalizeWeb2016" failed