5 ms·

AFAIK, oData only lets you request a single entity type at a time, doesn't it? For example, in the example you provided, would it be possible to fetch a collect

AFAIK, oData only lets you request a single entity type at a time, doesn't it? For example, in the example you provided, would it be possible to fetch a collection of People and Airports as part of the same request? What would that request look like?

jmull 8y ago
No, you can batch requests.
- wsy 8y ago
  The question was not about batching, it was about join queries over more than one resource type.
  - jmull 8y ago
    I guess I should be more clear... batch means you can do things like combine these: GET /serviceRoot/Airports GET /serviceRoot/People into one request (and get the results in one response) I believe that's what the poster was asking. Here's a link to a different example from the OData site: https://www.odata.org/getting-started/advanced-tutorial/#batch https://www.odata.org/getting-started/advanced-tutorial/#bat... You're using the word "join". I'm not sure if you meant that in a relational sense or not. If yes, then maybe you're wondering if you can get airports with their related people, or people with their related airports in one request with OData. Again, the answer is yes.
    - wsy 8y ago
      Thanks for the explanation!
      - jmull 8y ago
        No problem... I realize my initial answer was pretty useless. "batch" has a specific meaning in Odata but of course you wouldn't know that unless you already knew Odata.
jbreiding 8y ago
No, you can query a collection of these entities and get back the resulting set with pagination.
ako 8y ago
You can include associated entities by using expand, e.g. order with orderlines. See: https://www.odata.org/getting-started/basic-tutorial/#expand https://www.odata.org/getting-started/basic-tutorial/#expand The oData contract, $metadata, describes an entire domain model, including associations between entities. You can use expand to join entities over these associations. You can request multiple queries in one http operation using batch requests: https://www.odata.org/getting-started/advanced-tutorial/#batch https://www.odata.org/getting-started/advanced-tutorial/#bat...

jmull 8y ago

No, you can batch requests.

wsy 8y ago
The question was not about batching, it was about join queries over more than one resource type.
- jmull 8y ago
  I guess I should be more clear... batch means you can do things like combine these: GET /serviceRoot/Airports GET /serviceRoot/People into one request (and get the results in one response) I believe that's what the poster was asking. Here's a link to a different example from the OData site: https://www.odata.org/getting-started/advanced-tutorial/#batch https://www.odata.org/getting-started/advanced-tutorial/#bat... You're using the word "join". I'm not sure if you meant that in a relational sense or not. If yes, then maybe you're wondering if you can get airports with their related people, or people with their related airports in one request with OData. Again, the answer is yes.
  - wsy 8y ago
    Thanks for the explanation!
    - jmull 8y ago
      No problem... I realize my initial answer was pretty useless. "batch" has a specific meaning in Odata but of course you wouldn't know that unless you already knew Odata.

jbreiding 8y ago

No, you can query a collection of these entities and get back the resulting set with pagination.

ako 8y ago

You can include associated entities by using expand, e.g. order with orderlines. See: https://www.odata.org/getting-started/basic-tutorial/#expand https://www.odata.org/getting-started/basic-tutorial/#expand The oData contract, $metadata, describes an entire domain model, including associations between entities. You can use expand to join entities over these associations. You can request multiple queries in one http operation using batch requests: https://www.odata.org/getting-started/advanced-tutorial/#batch https://www.odata.org/getting-started/advanced-tutorial/#bat...