• CRUD methods for an odata source in Connect

CRUD methods for an odata source in Connect

  • 141Views
  • Last Post 13 January 2020
0
votes
warren cowan posted this 13 January 2020

Hi I have recently created an odata layer in connect for one of my azure sql databases. and would like to know if there is any swagger documentation generated for the read write methods. I have to tell my app what methods to call for the endpoint in order to perform these operations and so far I have only managed find a cheat sheet for a handful of read and query methods. Any help you cudl provide here would be much appreciated.

Also is it possible to generate new endpoints programmatcially though a cli or api, so my app can generate one automatcially for the database it needs to connect to.

many thanks in advance

odata connect sql
0
votes
Dmitriy Muzurov posted this 13 January 2020

Hi Warren,

Thank you for submitting a ticket with us.

Skyvia Connect is using OData protocol and CRUD methods are common for entities exposed through our Connect as for every OData feeder.

For example, to remove a record in Salesforce Contact you need to use such DELETE request:

 

DELETE https://connect.skyvia.com/n73pe60m/Contacts('003A00000232NBzIAM')

where 

n73pe60m - Id of your Skyvia Connect endpoint

003A00000232NBzIAM - Id of the contact

You can find more details over this link.

 Unfortunately, it's not possible to generate new endpoints programmatically. Skyvia has no public API for now.

Should you have any questions, do not hesitate to contact us back.

New Ticket
Categories
Popular Tags
Close