Create your API

Create your API
calac41
The following diagram illustrates the approaches that you can use to create your API using 
CA Live API Creator
:
  how (1).png  
Whatever approach you use, you can iterate quickly. You can receive immediate feedback from business users while continuing to refine application logic and develop custom client interfaces (applications). The APIs you create using API Creator provide enterprise-pattern automation, including optimistic locking, pagination, and generated key support.
 
Follow these steps:
 
  1. In API Creator, on the APIs page, click 
    Create New API
    .
    The connection wizard opens. The following image shows the connection wizard:
    Screenshot 2017-08-18 11.49.29.png  
  2. Click the approach you want to use to create your API:
     If you are new to creating APIs using API Creator, we recommend that you create your API by connecting to the Northwind sample database (click 
    Database First
    , and then click 
    Example Northwind database
    ).
    •  
      Database First
      With the 
      Database First
       approach, create your API by connecting to an existing database. This approach creates a default API based on schema discovery. You can then extend your API.
       
      Prerequisite:
       You have the database server information and credentials required to connect to the database. 
      In the connection wizard, connect to your database by selecting one of the following options, and then click 
      Continue
      :
      •  
        New empty database. 
        This option creates an API for a managed database.
        Prerequisite: 
        You have added a managed data server and it is active.
        For more information about how to add a managed data server, see Managed Data Server Administration.
      •  
        Empty API.
         This option creates an API without an initial database connection.
      •  
        JNDI data source.
         Select this option if your connection information is not stored in the admin database or if you want greater flexibility in leveraging database management system (DBMS)-specific options, such as SSL access and mirroring.
         Firewalls require accommodations.
      A default API that matches your schema and a connection to the database are created.
      For more information about how to view your schema, see Database Connectivity.
    •  
      App First
      With the 
      App First
       approach, you create an empty API, connect to a managed data server, and then add a data source for a managed database. With this approach, you create your tables, fields, and data using Data Explorer. API Creator creates your application, your schema, and your default API.
      Prerequisite:
       You have added a managed data server and it is active.
      A default API is created. Data Explorer starts in a new browser window in Author Mode. Build your application using Data Explorer.
       If you are using the defaults, enter
      admin
      as your username and
      Password1
      as your password.
      For more information:
    •  
      Code First
      With the 
      Code First
       approach, you create an empty API and then customize your API by writing JavaScript functions, JavaScript resources, and custom endpoints in JavaScript. You can get help in writing your custom code using code completion, logic libraries, and the debugger.
      For more information:
    •  
      Model First
      With the 
      Model First
       approach, API Creator creates your data source for a managed database and your default API. You convert a model, such as Swagger, to schema format and then create your schema and API by importing your model (JSON file).
       
      Prerequisite: 
      You have added a managed data server and it is active.
      A default API is created and its associated database is created.
      For more information:
Watch the Video
For more information about how to create your default API, watch the following Creating APIs - Alternatives video:
 

 
Next Steps
Now that you have created your API, you can:
  •  
    Customize your Favorites Section
    The Favorites section in API Creator includes links to the Learning Center, the Resources page, the Rules page, the REST Lab, and to Data Explorer by default. You can add more links to API Creator pages, remove links, and reorganize links using the drag-and-drop method.
     
  •  
    Customize your API with resources that you explicitly define.
    For more information about how to define these resource, see Customize your API.
  •  
    Specify your business logic and security.
    For more information, see Logic.
  • Enhance and extend system automation for update and retrieval logic with procedural code using server-side JavaScript.
    For more information, see Extensibility.
  •  
    Explore your data and create new databases using Data Explorer.
    For more information about how to use Data Explorer, see Data Explorer.