Integrating an external data source

Run the REST integration wizard to connect to the external data source.

1. Log in as Administrator, with username Admin@TestApp using password password123!
2. In the header of Dev Studio, click Configure > Integration > Connectors > Create REST Integration to run the New REST Integration wizard.
3. Enter the following connection details:
4. In the Name field, enter: ExternalContactData
5. In the Endpoint URL field, enter: http://localhost:8080/prweb/PRRestService/test/01-01-01/getContactData/{ContactId}
6. Click Add authentication to configure the authentication service:
   1. Select Define New.
   2. In the User name field, enter: serviceuser
   3. Click Set password, then enter: password123!
   4. Click Submit.
7. Click Next to configure the Resource methods.
8. In the Resource Name field, enter GET_ExternalContactData
9. Click Next to configure the data model.
10. On the Data model page, click Add a REST response.
11. In the Add a REST response dialog box, click Run to query the service and get a JSON response.
12. Click Submit to save the data model.
13. Click Next to review the configuration.
14. Click Create to create the REST connector.
15. Wait for the generation to complete, then click Close.

Create a copy of the Contact data page and the Response Data Transform in your application ruleset.

1. In Dev Studio, in the navigation pane, click Data types.
2. In the Data Explorer, click Contact to display Contact class.
3. Click the Sources tab, then click the first Contact page to display the the D_Contacts data page.
4. Create a copy of the D_Contacts page in your application's ruleset.
   1. Click Save as.
   2. On the new page, maintain the default Context settings:

      TestApp

      Applies to: Common-LDM-Entity

      Ruleset: TestApp:01-01-01

   3. Click Create and open, and then click Save.

5. Create a copy of the Response Data Transform in your application ruleset.
   1. On the new D_Contacts page, in the Data Source section under Profile_Con_Detail, next to the Response Data Transform field, click the Open icon. The Con_Detail_Up data transform is displayed.
   2. Click Save as.
   3. On the new page, maintain the default Context settings:

      TestApp

      Applies to: Common-LDM-Entity

      Ruleset: TestApp:01-01-01

   4. Click Create and open, and then click Save.

You now have the Contact data page and the Response Data Transform in the TestApp ruleset. You modify these files to reference the external data source.

Create a version of the Request Data Transform in your application ruleset and modify the Applies to field, to reference the REST service for the external data.

1. Create a copy of the Request Data Transform in your application's ruleset.
   1. On the new D_Contacts page, in the Data Source section under Profile_Con_Detail, next to the Request Data Transform field, click the Open icon. The Con_Detail_Down data transform is displayed.
   2. Click Save as.
   3. On the new page, use these Context settings:

      TestApp

      Applies to: Common-Int-External-GET_ExternalContactDataAPI

      Ruleset: TestApp:01-01-01

   4. Click Create and open, and then click Save.

2. Click the Pages & Classes tab and change the ConnectorPage class to: Common-Int-External-GET_ExternalContactDataAPI
3. On the Definitions tab, to map the contact ID to the external source, set the Target field in step 6 to: connectorPage.request.ContactID
4. Click Save.

Modify the D_Contacts page in your application ruleset to reference the external REST source.

1. Open the D_Contacts page. This is the version saved to ruleset TestApp:01-01-01.
2. In the new D_Contacts page, in the Data Source section, under Profile_Con_Detail, enter the external data source information.
   1. In the Source field, change the selection from Aggregate sources to Connector.
   2. In the Type list select REST and in the Name list, select GET_ExternalContactData
3. In the Request Data Transform field, select Con_Detail_Down. Ensure that you select the version in your application ruleset.
4. In the Response Data Transform field, select Con_Detail_Up. Ensure that you select the version in your application ruleset.
5. Set the Endpoint URL to the URL for the external data source: http://localhost:8080/prweb/PRRestService/test/01-01-01/getContactData/{ContactId} and the method to GET.
6. Click Save to save the D_Contact page.

Modify the Response Data Transform to map data from the external source to your application.

1. On the D_Contacts Data Page, in the Response Data Transform field, click the Open icon to open the Con_Detail_Up transform.
2. Click the Pages & Classes tab and change the ConnectorPage class to: Common-Int-External-GET_ExternalContactDataAPI
   
   Use the API class because it contains the request and response properties. The response property contains the values from the REST service after you call it.
3. Click Save to save the changes to D_Contact.
   
   After saving, the page displays some undefined property errors, which you fix in the following steps.
4. On the Definitions tab, modify the Source fields for the following properties to map fields from the external source. (The properties are listed in section 5.2.)

   Target	Source
   .ContactID	.response_GET.ContactId
   .FirstName	.response_GET.FirstName
   .LastName	.response_GET.LastName
   .Name	response_GET.FullName
   .MaritalStatus	response_GET.MaritalStatus
   .Salutation	.response_Get.Salutation
   .MotherMaidenName	.response_GET.MothersMaidenName

5. On the Definitions tab, disable or delete undefined properties.
   
   Properties that are not defined in the external data source result in an error message at the top of the Definitions page. To resolve the errors, right-click on the line number, then select Disable or Delete.
6. On the Definitions tab, add a page for the Phone List.
   
   To add a line, right-click an existing line number in the 5.2 section, then select Add sibling below.
7. Add a line in the 5.2 section (for example 5.2.50), then set Action to Append and map to, set Target to .PhoneList , and set Relation to a new page.
8. In the second-level line (for example, 5.20.50.1) set .Phonenumber to .response_GET.MobilePhone.
9. Add another second-level line (for example 5.2.50.2) and set .IsPrimary to "true".
10. On the Definitions tab, add a page for the Email List.
11. Add a line in the 5.2 section (for example 5.2.51) and set Action to Append and map to, set Target to .EmailList , and set Relation to a new page.
12. In the second-level line (for example 5.2.51.1) set .Email as equal to .response_GET.Email.
13. Add another second-level line (for example 5.2.2.51.2) and set .IsPrimary equal to "true".
14. Click Save to save your changes to the Con_Details_Up page.