Simplifier Makers ClubSimplifier Makers Club
  • Docs
  • Knowledge
  • F.A.Q
  • Forum
  • Courses
  • Marketplace
  • Pricing
  • Login
  • Try for free
  • German
  • English
  • Try for free
  • Docs
  • Knowledge
  • F.A.Q
  • Forum
  • Courses
  • Marketplace
  • Pricing
  • Login
  • Try for free
  • German
  • English
  • Try for free
home/Knowledge Base/Integrations/Create an ODataV2 Connector

Create an ODataV2 Connector

Written by Chris Bouveret
March 19, 2021

Create the Connector

First, create a connector with the connector type OData V2, the login method SAP_ID4_Freemium and the following endpoint:

http://sapid405.itizzimo.kinamu.at:8001/sap/opu/odata/sap/Z_SALES_ORDER_SRV

Important: do not skip the login method.

Create the Connector Call

After the connector is created, the connector calls must be defined. For this, use the Connector Wizard to make the creation of the connector calls much easier.

Select the entity sets: SalesOrderCollection

Select operations: SalesOrderCollection/readAll

Connector Call Name: SalesOrderCollection_ReadAll

… and create the connector call.

 

Test the Connector Call

Before you use the created connector call in an application, please test it to ensure that it works.

Create the UI

After the connector has been created and the connector call has been successfully tested, you can now focus on the user interface of your application.

I would say that we are creating a very simple app together, which displays the data of the OData service in a table. The data should be loaded by pressing a button.

So at first, add the widget Button to the screen. Change the ID of the button accordingly (e.g. Button_Read) and add the appropriate text (e.g. Read) to the Properties.

For the UI you also need the Widget Table, so add it to the screen. Here you have to customize the properties as follows:

  1. Activate itemsTemplate.
  1. Click on the Selection Helper at items.
    A dialog opens in which you have to select the connector on the left and then the Collection SalesOrder_Collection

Since the data should display three values of the OData service, we still need three Columns in the table and a ColumnListItem that contains three Text widgets.

To make it clear which data is displayed in the columns, you can add a label with the corresponding text Buyer Id, Gross Amount and Currency Code to each column in the header.

Your screen content should look like this:

Configure the Process Logic

Switch to the Process Designer and create the user story for the process logic.

Start the process with a Subscribe event of the read button (Widget Event: press). Then add the Data Object Connector and select the Connector and the corresponding Connector Call SalesOrderCollection_ReadAll.

For the Read Connector Call you don’t need an Input Mapping, because you don’t have to pass a value to read all data.

Only the output mapping has to be defined.

Open the Output Mapping and drag the Parameter from the left. Go deeper into Output – SalesOrderCollection.

Select the needed fields. In this case, select BuyerId, GrossAmount and CurrencyCode by clicking on the plus.

After you have added the fields, click Ok.

Now you have to define the widgets (drag it from the right) in which the selected parameters need to be mapped.

Select the screen, the widget Table and switch to Data Aggregation within the section Properties and Aggregations.

Go deeper into items.

Now go deeper into the items of the Table – ColumnListItem.

You will now see the three Text widgets as cells of the list item. For each Text, you have to select String text as property. It then appears on the right under Selected Properties.

When you have done this for all three of them, click Ok.

Now map the parameters into the table. The Output Mapping should look like this:

Connect the two shapes with each other:

Make sure that the app has the appropriate permissions to execute the connector.

After successful deployment the data will be read and displayed after pressing the button.

Conclusion

Creating a connector in Simplifier that accesses an OData service is not difficult. Especially the creation of connector calls is very efficient and easy, since the Connector Wizard can be used for it.

It is always important to test the connector call before using it in the process logic for the application.

I hope I could help you with how to create a connector that accesses an OData service and how to address it in the process logic of an application.

Did you know that we also offer the Connector Wizard for SOAP and SQL connectors?

Tags:designermountUIheaderODataconnectortemplatetexttoAPI

Was this article helpful?

2 Yes  No
Related Articles
  • Fine-tuning and Running Custom AI Models in Simplifier
  • Using the Simplifier Teams App
  • How to integrate SAP ERP (via SAP RFC)
  • Creating a ChatBot Client for ChatGPT
  • REST: Use a CSRF Token and a Cookie to authorize Requests
  • Dynamic where-clause and repeatable statement
Leave A Comment Cancel reply

You must be logged in to post a comment.

Integrations
  • Create an ODataV2 Connector
  • Identity Provider Setup
  • How to create a REST Connector
  • How to Use Data Services and ODataV4 REST
  • Dynamic where-clause and repeatable statement
  • REST: Use a CSRF Token and a Cookie to authorize Requests
  • Creating a ChatBot Client for ChatGPT
  • How to integrate SAP ERP (via SAP RFC)
  • Using the Simplifier Teams App
  • Fine-tuning and Running Custom AI Models in Simplifier
Knowledgebase Categories
  • Getting Started 4
  • Best Practices 4
  • How to's 27
  • Layout & Design 4
  • Widgets 8
  • Cloud Services 6
  • Database Handling 1
  • Integrations 10
  • Plugins 6
  • Mobile Client 2

  How to Use Data Services and ODataV4 REST

How to create a REST Connector  

Insert/edit link

Enter the destination URL

Or link to existing content

    No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.