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

https://simple-books-api.glitch.me/books

https://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,