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.

Workflow990×318 29.3 KB

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

580×587 20.4 KB

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.

1255×484 19.9 KB

1. Choose the action to perform

1548×523 47.5 KB

1. Choose the business object as products

1163×657 29.9 KB

1. Select the data fields

1331×415 28.7 KB

1. Preview the action details and confirm

1102×506 26 KB

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

1207×736 31.6 KB

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

332×676 27.2 KB

1. Configure the workflow as below

990×318 29.3 KB

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

1207×736 31.6 KB

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

1919×463 60.5 KB

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

1040×321 34.3 KB