PersonAPIwRESTv2.md



This tutorial demonstrates how to create a connection within Informatica Intelligent Cloud Services (IICS) using the RESTv2 connector to connect to the Mock Person API. In production, you will want to use the non-Mock Person API. Instructions for requesting access to it are here if you don't have access already.

Prerequisites

Access to IICS
Access to a working IICS secure agent
An App within the UW-Madison Developer Portal


Connections


Open a browser window and browse to the Mock Person API page. You will need to log in with your NetID. At the very bottom of the page, make note of the Token URL: https://api.wisc.edu/oauth/token


In the upper right of the developer.wisc.edu portal, click your name's drop menu and select Apps


Select the application connected to your developer account, then browse to the API Keys section. You will need the Key and the Secret on the IICS portal. If you do not have access to this, please follow these instructions to gain access to Person API.


Log into IICS with your NetID.
Chose the Administrator tile in the My Services window.
Select Connections in the left pane.
Select the New Connection button in the upper right of the window.


In the Type drop menu:

Create a Connection Name

Select REST V2 (Informatica Cloud)

Select your Runtime Environment

Select OAuth 2.0-Client Credentials in the drop menu for Authentication

Paste https://api.wisc.edu/oauth/token in the Access Token URL field (we got this from step 1 above)
Paste API and Secret from step 3 into the Client ID and Client Secret fields
Click the Generate Access Token button next to the Access Token field and it will auto-populate
In the Swagger File Path field, paste https://git.doit.wisc.edu/interop/iics/external-iics-docs/-/raw/master/docs/tutorials/PersonAPI/swagger.json (this is a REST v2 OpenAPI specification file that may be different than the one you use in production later. IICS doesn't currently accept V3 and also frequently refers to this OpenAPI specification as a Swagger file.)


Press the Test Connection button in the upper right of the window to verify the connection is successful.
If the connection is successful, press the Save button.


Usage as a Source in a Mapping

To use PersonAPI as a source in a mapping, select the connection you just created as the source. To get a list of all people, select get people as the operation.


In order for the source to be used, you must go to the Request Options of the source and Configure the Request Message


No request message is required for this specific API function to work, although IICS requires one. Simply add '{}'. This will throw an error message while validating, but will still result in successful access to the data once the mapping is run.


Go to the Field Mapping tab within the source, and click the boxes on the left for each item you would like to map. Different dropdowns will show up on the right, containing the values you have mapped. These are groups that will be used in the next step. Select data.


Once you have done Field Mapping, attempt to connect your source to any transformation. This will create a selection menu of several values, each corresponding to the groups seen in the Field Mapping. In this specific case, "data" contains all of the relevant data related to a Student.


Important Notes

Web Service connectors enabled by Business Service options do not currently operate with this API.
The RESTv2 Connector does not accept swagger files of the OpenAPI3.0 specification (which PersonAPI uses), so the Swagger file must be converted to 2.0 through tools or by hand. There is a link to a converted swagger file provided in this tutorial.