Tips, Tricks and Code Tips, Tricks and Code

Back

Cloud Connector - OData 2.0 Connector

Created by Sandeep Lati, last modified on Tue, 3 Sep 2019, 14:09

This article describes OData 2.0 connector usage in webMethods.io Integration with OData connector use case.

Use case:

Get the list of products from public OData backend services and write them to new CSV file if data is more than 20 records file name appends with the date and if less than 20 records update the existing CSV file.

Workflow

Steps:

Create Account:

 

  1. Add Account by clicking on + icon at “Connect to OData v2.0”
  2. And then provide account details.
  3. Let's use below  generic test account for the demo purpose

URL : http://services.odata.org/(S(1hge4mn2zqwrcatw55e5na0w))/V2/OData/OData.svc

 

Action:

We can choose existing actions or can create new custom actions.

Let’s create a new custom action for getting the listing of products.

  1. Click on + icon at “Select Action” to create a new custom action. Provide required inputs and choose account configured above.

  1. Choose the action to perform

  1. Choose the business object as products

 

  1. Select the data fields

 

  1. Preview the action details and confirm

 

 

  1. Click on Done button
  2. Click on the Test button to test the action

 

  1. Add the “JSON to CSV”, switch and file operation developer utilities from right side pallet.

    

 

  1. Configure the workflow as below

 

  1. Configure the switch condition for case1 to create a new file if no of products are grater than 20.

 

  1. Click on the Play icon to execute the workflow.

 

  1. It also shows a graphic view of execution as below at each step.


0 Attachments
356 Views
Average (1 Vote)
Comments
Great article, Sandeep! Anymore for other connectors coming up soon?
Posted on 8/19/19 7:04 AM.
Hi Mike,

Yes, we will publish for more connectors.

-Sandeep
Posted on 8/19/19 12:00 PM.