Supported OData API operations

The following table shows the operations that can be performed and their associated URLs. Query the data source name to get a list of the valid entities.

In the URL examples in this table,

<myserver> is the DNS name or the IP address of the machine on which Hybrid Data Pipeline is installed.

<myds> is the name of your Hybrid Data Pipeline data source.

<plural-name> is the name you designate in your schema map for entity plurals. In the schema map, Hybrid Data Pipeline pluralizes the table name automatically. You use the plural entity name in OData requests.

pkey is the primary key.

Purpose Request URL
Fetch Data from an OData Service 
GET
 https://<myserver>:8443/api/odata/<myds>/<plural-name>
Create an Entity 
POST
 https://<myserver>:8443/api/odata/<myds><plural-name>
Update an Entity 
POST
X-HTTP-Method:MERGE
 https://<myserver>:8443/api/odata/<myds><plural-name>('pkey')
Delete an Entity 
DELETE

Or

POST
X-HTTP-Method:DELETE
 https://<myserver>:8443/api/odata/<myds><plural-name>('pkey')