9.11. Import Data from REST Services
9.11. Import Data from REST Services Procedure 9.2. Import Data from REST Services Go into the Model Explorer . In Model Explorer, right-click and then click Import... or click the File > Import... action in the toolbar or select a project, folder or model in the tree and click Import... Select the import option Web Service Source >> Source and View Model (REST) and click . Select an existing or connection profile from the drop-down selector. Alternatively, press the New... button to launch the New Connection Profile dialog or Edit... to modify or change an existing connection profile prior to selection. If you are creating a new connection profile, choose the Web Services Data Source (REST) Name your new REST Connection Profile and click . Set your REST URL in the Connection URL text field and your Security Type and credentials, if applicable. Click to see a summary of your properties or click Finish to end. There is also an option to add Request Header parameters. The importer assumes an Accept header value of application/xml and a Content-Type header value of application/xml. These defaults can be overriden in the Optional Request Header Properties section. You can also add any other header properties required for the service. Click the Test Connection button to validate your connection properties. After selecting or creating a new Connection Profile, the REST XML result from the connection profile will be displayed in the REST Web Service Response Data File panel. Check the data file you wish to process and click . Enter a unique source model name in the Source Model Definition section. Alternatively, you can select an existing source model using the Browse button. Note The Model Status section which will indicate the validity of the model name, whether the model exists or not and whether the model already contains the invokeHttp() procedure. In this case, the source model nor the table will be generated. Enter a unique view model name in the View Model Definition section. Alternatively, you can select an existing view model using the Browse button. Note The Model Status section which will indicate the validity of the model name, whether the model exists or not. Enter a new view procedure name in the View Model Definition section. Click . Enter a JNDI Name in the Jboss Data Source Information section and click . Note The primary purpose of this importer is to help you create a view procedure containing the transformations required to query the user-defined data file. The panel contains an XML tree view of your result contents and actions/buttons you can use to create column entries displayed in the middle, Column Information panel. The root path is used for xpath parsing of the result document. The importer sets a root path for you. You can change the root path, if needed, by selecting an XML element and right-click select Set as root path action. , select columns in the tree that you wish to include on your query and select Add button. You can also modify or create custom columns, by using the ADD, DELETE,EDIT, UP, DOWN to manage the column info in your SQL. to generate your models and finish the wizard. Click Finish to generate your models and finish the wizard.