Skip to Content

Import an OpenAPI document to create an endpoint in Jitterbit App Builder

Introduction

Since version 4.45, you can create a REST endpoint from an OpenAPI document. You can do this from either of these places:

  • IDE > Data Servers

  • App Workbench > Data Sources

This page shows the steps for both.

Create a REST endpoint from an OpenAPI (Swagger) document via the IDE

Follow these steps:

  1. Select IDE > Data Servers.

  2. Click the + Server button. The Server dialog opens.

  3. Set values for the following:

    • Server Name: Enter a name for the server.

    • Type: Select REST API. (REST is automatically selected for Subtype.)

    • URL: Enter the endpoint root (base URL).

    • (Optional) Description: Enter a description.

  4. Click the Save button.

    The following example uses the OpenAPI test document URL https://ipinfo.io/developers/openapi.yaml:

    Server dialog

  5. In the Server dialog, click the Endpoints icon.

  6. In the Web Service panel, click the Import button. The first page of the Web Service Import wizard dialog opens:

    Web Service Import dialog

  7. Select one of the following tabs, depending on how you want to provide your OpenAPI document:

    • URL: Select to provide a URL for the OpenAPI document.

    • Document: Select to paste the content of an OpenAPI document.

    • Upload: Select to upload an OpenAPI document from your file system.

  8. Click the Next button. The second page of the Web Service Import wizard dialog opens:

    Create Endpoints

  9. (Optional) To import one or more endpoints, do either of the following:

    • Enter a pattern in the Import by Name field, then click the Import button.

      A pattern is a comma-delimited list of wildcard expressions which select a subset of tables to import. Each pattern uses the mvSQL LIKE syntax. You can use % to match zero or more characters, and _ to match a single character. Characters in square brackets (for example [abc]) match any character in the group.

    • Click any of the Import Schema buttons to import endpoints.

  10. Click the Finish button.

Create a REST endpoint from an OpenAPI (Swagger) document via the App Workbench

Follow these steps:

  1. Select App Workbench from the action drawer, or Workbench from the application menu, then click Data Sources.

  2. Click the + Source button. The Add a Source to your Application dialog opens.

  3. Select the New Connection option, then click the Next button. The Choose Connection Type wizard page opens.

  4. Under Connection Category, select the REST option.

  5. Under Types of Connections, select the REST API option, then click the Next button.

  6. Select or set up a security provider, or click the Skip button. The Create New Connection wizard page opens.

  7. Under Server Settings, set values for the following:

    • Server Name: Enter a name for the server.

    • URL: Enter the endpoint root (base URL).

  8. Click the Next button. The Create Endpoints wizard page opens:

    Create Endpoints

  9. Click the Import button. The Web Service Import dialog opens:

    Web Service Import

  10. Select one of the following tabs, depending on how you want to provide your OpenAPI document:

    • URL: Select to provide a URL for the OpenAPI document.

    • Document: Select to paste the content of an OpenAPI document.

    • Upload: Select to upload an OpenAPI document from your file system.

  11. Click the Next button. The Web Service Import dialog opens again:

    Web Service Import

  12. (Optional) To import one or more endpoints, do either of the following:

    • Enter a pattern in the Import by Name field, then click the Import button.

      A pattern is a comma-delimited list of wildcard expressions which select a subset of tables to import. Each pattern uses the mvSQL LIKE syntax. You can use % to match zero or more characters, and _ to match a single character. Characters in square brackets (for example [abc]) match any character in the group.

    • Click any of the Import Schema buttons to import endpoints.

  13. Click the Finish button. The Create Endpoints wizard page opens.

  14. To test the endpoints, click any of the icons in the Status column. When successful the icon changes to :

    Create Endpoints

  15. Click the Next button. The New Data Source Summary dialog opens.

  16. Click the Done button.