Search code examples
odataazure-logic-appsazure-table-storage

Logic Apps Table Storage Get Entities action returns no/unusual results

I have a boolean column in an Azure Table Storage table called reported. It looks like this:

enter image description here

From within an Azure Logic App, I'm trying to use the Get Entities action to pull all records where recorded eq null OR where recorded ne true.

I can't seem to find the correct syntax for parsing null. The docs here have no reference to nulls.

Tried so far:

  • These all return a blank array of results

enter image description here enter image description here enter image description here enter image description here

  • This returns an error

enter image description here

{
  "odata.error": {
    "code": "InvalidInput",
    "message": {
      "lang": "en-US",
      "value": "One of the request inputs is not valid.\nRequestId:21e33cd2-c002-001d-17eb-8d7c61000000\nTime:2021-08-10T13:27:02.5345973Z"
    }
  }
}
  • These return the only true record in the table

enter image description here enter image description here

What am I missing?

Solution

  • I tried reproducing the same and found this enter image description here

    As it is a boolean value and there is no values assigned to reported property in the entity, the value isn't showing up. There has to be either true or false value to the reported property to perform manipulations. That's the reason why you cannot find the reported column which are null.

    In order to make it visible you can make the null to false and so that you can access them having filter query to be reported eq 'false'