OData: startswith Function
by Besides operators, OData also enables us to have functions on our data. These are super useful to filter the data on the source to pull …
Category: OData Reference
OData or Open Data Protocol is a convention that describes a set of rules in building an URL. You can have things like operators, queries, and more. I will simplify its concepts since the specification is quite dense.
Microsoft’s Power Platform takes full advantage of it, so we will too. I’ll show you cases, especially in Power Automate, where you filter the data before it’s transmitted.
If you don’t understand it, the syntax can be tricky, so I want to provide some help by defining my own OData reference. For example, you can specify that you wish to only items that start with a particular set of characters or an older date than today. There is a lot to explore.
OData: OR Operator
Data aggregation is essential when performing requests for data, and we’ve already covered the And Operator that helps with that. On the other end of …
OData: Lower Than or Equals Operator
The “lower than or equals” or “le” operator helps us filtering the data based on criteria of something being “lower” than another. We’ve covered the …
OData: Greater Than or Equals Operator
The “greater than or equals” or “ge” operator helps us filtering the data based on the criteria of something being “greater” than another. We’ve covered …
OData: Lower Than Operator
The lower than operator is used to filter data that fit within certain criteria, in this case, something being “lower” than another. Having this on …
OData: Not Equals Operator
We’ve already covered the “equals” operator but let’s look at its counterpart. The “not equals” operator. It provides a useful filter of data that we …
OData: Greater Than Operator
The greater than operator helps us filtering the data based on the criteria of something being “greater” than another. Having this on numbers or dates …
OData: And Operator
Sometimes having one operator that provides us with all the data that we need is hard, so it’s useful to aggregate several in the same …
OData: Equals Operator
Checking for equality is essential when using operators. For example, if we want to filter data, we usually use one or more equals operator(s) to …
OData Reference: An Introduction
First and foremost, OData or Open Data Protocol dates back to 2007 when Microsoft started it, being standardized later by OASIS (not the band, unfortunately) …