IICS Example 43: Webservice transformation-Rest v2- Swagger File- API data store into table

Step 1: End point URL to get response
-- Sample End point URL
simple-books-api.glitch.me/books
github.com/vdespa/introductio...
Step 2: Test the API using Postman
Download the Postman
Create a login
Then click on + symbol
Step 3: Create Swagger file and download JSON file
Swagger helps users build, document, test and consume RESTful web services.Swagger is a specification for documenting REST API. It specifies the format (URL, method, and representation) to describe REST web services. A Swagger file is JSON format file. It is mandatory to have Swagger file to configure IICS REST V2 connection to integrate with any REST API
Step 4: Add Rest-V2 connection from Add on connector
Step 5: Create Rest-V2 connection and attach Swagger file
Step 6: Create Business Service Component
Step 7: Create source file with port number
Step 8: Craete target table to load the data
-- Create below sample target table for BOOKS Api
create table t_api_books
(
id number,
name varchar2(100),
type varchar2(100),
available varchar2(100),
port varchar2(100)
);
Step 9: Create a mapping with Web Service Transformation
Step 10: Run the mapping and verify the data
informatica interview preparation,informatica interview scenarios,informatica interview questions,informatica interview videos,informatica interview,informatica admin interview questions,informatica interview tips,informatica interview questions and answers,informatica powercenter interview questions,technical interview questions,informatica questions,informatica training,informatica answers,informatica powercenter,informatica tutorial
informatica intelligent cloud services, iics informatica tutorial, iics to cloud data base connection, iics data integration tutorial, iics cloud data integration services, iics training informatica, iics tutorial for beginners, iics informatica tutorial telugu, iics informatica, iics informatica interview questions, iics informatica resume, iics informatica training, iics data integration, iics data integration interview questions, what is informatica iics, iics login issue, informatica intelligent cloud services, iics, iics Informatica Cloud secure agent,

[@ganeshchilka9613]

Hello, thanks for the detailed video. Could you please explain if we need to create separate Rest V2 connections and Swagger file for each api end point. Like there will be different api end points one for customer, another for order.

[@RiteshGatpalli]

I tried using informatica cloud secure agent to create swagger but it failed. does it mean I cant use informatica hosted cloud agent to create swagger files ?

[@user-fo6mm7dr6z]

What can we do if some fields from JSON files are not coming into Business service component? Normally all fields will come,but I want to know scenario where 1 or some fields is not getting fetched to next level.Thanks