I'm new to SkyVIA, and i am experimenting with publishing an Azure SQL database using a connect endpoint.
I have a very simple table, named Menu that has 3 fields.
I have populated the database with a single record:
Title: Company Menu
when i do a GET /xxxxxxxx/Menus it returns the single record. Great.
what i am noticing is, when querying for a single record, using the following syntax it is failing:
GET /xxxxxxxx/Menus(ID=guid'70fcabd9-41e6-4b54-9720-8f9ca38fb604')?$format=json. From looking at the logs, i can see it is generating the following query: SELECT t.ID, t.Title, t.Active FROM dbo.Menu AS t WITH (NOLOCK) WHERE (t.ID = 'ID=guid''70fcabd9-41e6-4b54-9720-8f9ca38fb604'''
If i remove the column name, it still fails. If i remove both the column name and type qualifier it still fails. However, if i also remove the single quotes around the guid string, it works: GET /xxxxxxxx/Menus(70fcabd9-41e6-4b54-9720-8f9ca38fb604)?$format=json
is this the expected behavior?
When i return an atom result, and look at a link reference, it returns the following: https://connect.skyvia.com/xxxxxxxx/Menus(guid'70fcabd9-41e6-4b54-9720-8f9ca38fb604'). That link does not work, because it doesn't like the single quotes or type qualifier.