PersonAPIwRESTv2.md



This tutorial demonstrates how to create a connection within Informatica Intelligent Cloud Services (IICS) using the RESTv2 type to connect to the Mock Person API. In production, you will want to use the non-Mock Person API and you can request access to it via this link if you don't have access already. This tutorial will assume you already have a working IICS account with a secure agent installed as well as an API app set up in the Wisc Developer portal.
Note: It looks like we may need to also include how to get an App into a user's API login

Prerequisites
###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/swagger-files/swagger.json (this is a REST v2 file that in production you would have yourself. IICS doesn't currently accept V3.)


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.


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. This issue is being researched.
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.