The OData endpoint of Connect is empty by default. After creating a connection, you must choose which entities should be exposed before accessing them in the OData API.

Tables & Views

After establishing and saving a connection, you can import the tables and views from this connection to expose them in the Connect API. To do so, follow these steps:

1. In the Tables tab of the OData page, click Add Tables.
2. Select the newly created connection.
3. Select any number of tables and views you wish to import.

Enable and Disable columns

By default, all columns are available in each Table and View. If desired, you can open a Table or View and uncheck any columns that you do not want to be available in the CData Connect API.

Enable and Disable operations on a Table

By default, all HTTP operations are available for each table:

• GET
• POST
• PUT/PATCH/MERGE
• DELETE

If desired, you can open a table and uncheck the box next to any of these operations to disable it for that table. See OData Operations for more information about running OData requests against the imported OData entities.

Procedures

After establishing and saving a connection, you can import the procedures from this connection to expose them in the Connect API. To do so, follow these steps:

1. In the Tables tab of the OData page, click Add Procedures.
2. Select the newly created connection.
3. Select the procedures you wish to import.

Note: Users must be authorized to run HTTP POST requests to access a procedure.

See Procedures for more information on how to run OData Actions, procedures or functions in the Connect OData API.