Ultimate OutSystems Course: From Beginner to Pro Developer

Explore the service module in Outsystems, navigating front end and back end, and build processes, timers, drag‑and‑drop logic, API integrations, and database architecture.

Create the first data entity for a movie app by defining a public movies entity with name and release date. Also set up static genre and ratings entities.

Create data static entity named genre with predefined records like comedy, horror, and action, set is public value to yes, then add a stars entity with 1–5 ratings and publish.

Create a database diagram by dragging the movies, genre, and stars entities, then connect them to add the ids from static entities and establish 1-to-1, 1-to-many, and many-to-many relationships.

Create our first service action, SVA Create Movie, to populate the database and add create date and update date attributes to the movies entity, while exploring inputs and outputs.

Open the data tab, drag the create movie action into the flow, and map inputs. Set id to null, name Spider-Man, create date to current date time, and schedule publish.

Publish the movies entity, verify data updates, and switch the action from create to update. Set the timer ID to 1, update the data, and publish.

Learn how IDs are unique by creating and deleting a movie, using the ID attribute, copying its ID formula, and observing a new row with a different ID.

Implement a create or update action for the movie entity in a movies folder. Determine creation or update by movie id with dates set to current date time.

Label steps to clarify the flow and labels in the action that checks the database for a movie id, updates when it exists, or creates an entry, improving team handover.

Create a back-end service action that retrieves all movies, filters to new movie three and four, assigns the genre comedy using a for each loop, and schedules a publish timer.

Use a switch statement to set genres for specific movies by name, create backend logic with an aggregate and assigns, then publish results as frontend tasks are prepared.

Create your first hello world page in OutSystems by dragging a screen widget, naming it main, inserting hello world in the title container, and publishing to view in the browser.

Explore the interface tab by navigating the widget panel, screens blocks, and widget tree, then drag a container and use properties and style tabs to set css height 400 px.

Master the difference between client variables and local variables in OutSystems by seeing how client variables persist across screens and sessions, while local variables reset after a screen or action.

Connect front-end and back-end to enable actions from the movie database by linking dependencies with the plug icon, then fetch Test Items and Test Service data in the data tab.

Publish the service module after making the star entity public, then fetch data for the movies entity and drag a table widget to create a table in OutSystems low-code interface.

Create a list widget to display data as cards, compare it with a table using the drag-and-drop workflow, and publish with a 20-pixel bottom margin.

Create the first pop-up widget in OutSystems using a local boolean isPopup and the not operator to toggle visibility, with an add movie button triggering the popup.

Create a movie entry form by fetching an empty dataset, auto-creating inputs and a save action, validating required fields like name, and linking a backend save or update action.

Implement pagination for the movie table by sorting by ID in descending order. Create max records and start index variables, wire a pagination widget, and refresh after each page change.

Create a search input to filter the movies table with a text var using a like filter on the get movies entity, and use onchange to reset startindex.

Build a charts screen in Outsystems using a column widget and a pie chart, create an aggregate for movies and genres, group by genre and count movies, publish.

Expose our movie entity as a rest api with basic authentication, then verify user login and return the full movies list using an aggregate and list append all.

Learn to verify the movies API by opening the rest API action, viewing its documentation, and testing the get endpoint by copying the URL into a browser and logging in.

Consume the rest API to fetch the movie list into the interface by configuring the get method, adding basic authorization with username and password, and validating a 200 response.

Consume rest api part 2: create a rest action with a response output, fetch movies, map api response to a movie list, display it in a list widget, and publish.