Adding an external data source to a data type (2024)

1. In the App Studio navigation pane, clickData > Data objects and integrations to open the Integration Designer.

   

2. In the upper-right corner of the landing page, click New to open the Data Object wizard and create a data object to access the NHTSA service.
3. In the Data Object wizard, in the Data objects name field, enter NHTSA Model data.
4. In the System drop-down, select Create new. The wizard updates to display additional fields to define the new data source.
5. In the Name field, enter NHTSA vPIC.
6. In the Description field, enter NHTSA Product Information Catalog Vehicle Listing.

   

7. In the Endpoint URL field, enterhttps://vpic.nhtsa.dot.gov/api/vehicles/GetModelsForMakeYear/make/Ford/modelyear/2015/vehicletype/Truck?format=json to specify the URL for the NHTSA web service. The Parameters section expands to display the URL parts for the service URL.
8. Using the following table, add parameters for the make, model year, and vehicle type parts of the service URL.

   URL part	Parameter name
   Ford	make
   2015	modelyear
   Truck	vehicletype

   

9. Click Initialize call to call the REST service and advance to the second step of the wizard.

Note: The responseindicates sevenresults were returned and displays data for one of the seven results. The number of results returned varies according to the parameters passed to the service.

1. In the SearchCriteria row, click Add new to map the SearchCriteria field from the REST response to a field for the data object. The contents of the row update to display the Map to field and a drop-down listing field types.
2. In the SearchCriteria row, click the Add/Edit map to icon to accept the default mapping and create a text field named SearchCriteria in the data object.

   

3. Repeat steps 1 and 2 for the Make_Name, Model_Name, and VehicleTypeName response fields.

   

4. Click Next to complete the data mapping and advance to the third step of the wizard.

Note: The NHTSA does not require user authentication to access the service and receive response data. Other data providers may require authentication. Verify any authentication requirements when you configure an integration to a web service.

1. Under Endpoint URL, in the Name field, enter GetVehicleModels_BaseURL to identify the connection settings.
2. Under Stage, in the Base URL field, enter https://vpic.nhtsa.dot.gov to complete the URL used after migrating the application to a staging system.
3. Under Prod, in the Base URL field, enter https://vpic.nhtsa.dot.gov to complete the URL used after migrating the application to a production system.
4. Under Authentication, in the Name field, enter AuthProfile_NHTSA_vPIC.

   

5. Click Submit to complete the configuration of the data object and REST integration.

1. In the Dev Studio navigation pane, click Data typesto list the data objects defined for the GoGoRoad application.
2. Click Vehicle modelsto open the data type.
3. Click the Sources tab to view available sources and click List Vehicle models to openthe D_VehiclemodelsList data page, which caches a listing of vehicle models.
4. In the Data Sources section, clear theSimulate data source check box to remove the simulated data source from the data page.
5. In the Source drop-down, select Aggregate sources to source the data page using two REST calls.
6. In the Aggregate source name field, enter NHTSA vPIC to identify the data source for the data page.
7. In the Source drop-down, select Data transform.
8. Click Add source to add a second source for the data page.
9. In the second Source drop-down, select Data transform.

   

1. For the first source, in the Data transform field, enter MapModels.
2. Click the Openicon to create the data transform.

   

3. Click Create and open to accept the default settings and open the data transform rule form.
4. Click the Parameters tab to define the three parameters required by the NHTSA service.
   1. On the Parameters tab, click the Addicon to add a row to define a parameter.
   2. In the empty parameter row, in the Name field, enter make.
   3. In the Required drop-down, select Yes.
   4. Repeat steps 4a-4cto add two more parameters to the data transform, using the information in the following table.

      Name	Required
      modelyear	Yes
      vehicletype	Yes

5. Click the Pages & Classes tab to identify the pages used by the data transform and the class of each page.
   1. On the Pages & Classes tab, in the Page name field, enter Primary.pxResults to identify the page that contains the output of the data transform.
   2. In the Class field, enter or select GoGo-GoGoRoad-Data-VehicleModels to identify the class of the output page.
   3. Click the Add item icon to add a second row to the Pages & Classes tab.
   4. In the Page name field, enter D_NHTSAModelData.Results to identify the page that contains the output of the data transform.
   5. In the Class field, enter or select GoGo-GoGoRoad-Data-NHTSAModelData-Results to identify the class of the output page.

      

6. Click the Definition tab to configure the data transform logic.
   1. For step 1, in the Action drop down, select Append and Map to to create a new results page for each result returned. The data transform adds a child row labeled 1.1 below step 1.
   2. For step 1, in the Target field, enter Primary.pxResults.
   3. In the Relation drop-down, select each page in.
   4. In the Source field, enter D_NHTSAModelData[vehicletype:param.vehicletype,modelyear:param.modelyear,make:param.make].Results to pass the required parameters to the data page that calls the NHTSA service and caches the response.
   5. For step 1.1, in the Target field, enter or select .Make to set the value of the Make property on the target page.
   6. In the Source field, enter or select .Make_Name to identify the property to copy to the target.
   7. Click the Add a rowicon twice to addsteps 1.2 and 1.3 to the data transform.
   8. Complete the fields of steps 1.2 and 1.3 by using the information in the following table.

      	Action	Target	Source
      1.2	Set	.Model	.Model_Name
      1.3	Set	.VehicleType	.VehicleTypeName

      

7. Click Save to complete the configuration of the data transform.

1. In Dev Studio, click the D_VehiclemodelsList tab to return to the data page rule form.
2. On the D_VehiclemodelsList data page rule form, click the Parameters tab to add parameters to the data page.
3. In the empty row, in the Name field, enter make to define a parameter for the make to pass to the data transform.
4. In the Required drop-down, select Yes to mark the parameter as required.
5. Click the Add itemicon to add a second parameter to the data page.
6. In the second row, in the Name field, enter modelyear to define a parameter for the model year to pass to the data transform.
7. In the Required drop-down, select Yes to mark the parameter as required.
8. Click the Definition tab to resume configuration of the aggregate sources.
9. Below the Data transform name field, click Parameters to open a dialog box for setting values to pass to the data transform.
   1. In the dialog box, in the Value field for the make parameter, enter param.make to pass the value of the make parameter passed to the data page.
   2. In the Value field for the modelyear parameter, enter param.modelyear to pass the value of the model year parameter passed to the data page.
   3. In the Value field for the vehicletype parameter, enter Passenger Carto pass a constant string.
   4. Click Submit to close the modal dialog and save the parameter configuration.
10. For the second aggregate source, in the Data transform name field, enter or select MapModels to call the data transform a second time to populate the data page.
11. Press the Tabkey to exit the field. The Parameters link is displayed below the Data transform name field.
12. Repeat step9 for the second aggregated source to add parameter values for the MapModels data transform byusing the information in the following table.

    Parameter	Value
    make	param.make
    modelyear	param.modelyear
    vehicletype	Truck

13. Click Save to complete the configuration of the data page.

1. In App Studio, click Preview application to return to the User Portal.
2. Create a new Assistance Request case.
3. Advance the case to the Identify vehicle step, completing any required fields.
4. In the upper right corner, click theDesignicon to open Design mode.

   

5. On theVehicle Informationsection, click theEdit this sectionicon.

   

6. On theModelfield, click theEdit this fieldicon to configure the Model drop-down list to pass the required parameters to the data page. A configuration pane is displayed on the right side of the browser window.
   1. In the List source section, clear the contents of the Data page field.
   2. In the Data page field, enter or select D_VehiclemodelsList to re-select the page and update the properties paneto display the required parameters.
   3. In the Value field for the make parameter, enter or select .Make.
   4. In the Value field for the modelyear parameter, enter or select .ModelYear.
   5. In the Property for value field, enter or select .Model.

      

   6. In the upper right corner of the pane, click Apply to complete the configuration of the drop-down.
   7. Click Design to toggle Design mode.
7. In the Model year field, enter 2015.
8. In the Make field, enter Ford.
9. Click the Model drop-down to display a list of vehicle models, grouped by vehicle type.