How do you add parameters to the rest endpoint ?

[xclaim494]

I have a View called 'Quotes_V'

columns are :
          "underlying",
		  "option_type",
		  "strike",
		  "expiration_date",
		  "bid",
		  "ask"

i need to build a rest endpoint on the quotes View with parameters for "underlying", "option_type", "strike", "expiration_date" and the payload returned needs to be bid, ask (+ others)

I am absolutely new to this so please excuse my ignorance :

I got as far as building a simple config file with a key-fields like below :

"entities": {
    "Quote": {
      "source": {
        "object": "dbo.Quote_V",
        "type": "view",
        "key-fields": [
          "underlying",
		  "option_type",
		  "strike",
		  "expiration_date"
        ]

when i run the rest URL I use :
http://localhost:5000/api/Quote/underlying/aapl/option_type/call/strike/100/expiration_date/2024-07-12

and the payload that is retuned is correct :

{
"value": [
{
"bid": 127.2,
"ask": 128.64999
}
]
}

my question is : does the rest url look right ? I thought the parameters to query the fields needed to be structured differently ?

any guidance is much appreciated

example in curl I am used to something like this ?
curl -X GET "http://localhost:5000/api/Quote/?underlying=aapl&option_type=call&strike=100&expiration_date=2024-07-12"

[seantleonard]

Hi @xclaim494, the 'key-fields' can be thought of as "primary keys." Wouldn't the primary key in this case be underlying? then your REST url can use the filter query parameter to filter results:

GET  https://localhost:5001/api/Quote/underlying/aapl?$filter=option_type eq 'call' and strike eq 100 and expiration_date eq '2024-7-12'

https://learn.microsoft.com/en-us/azure/data-api-builder/rest#filter