CODEWITHSUNDEEP
odataazure-logic-appsazure-table-storage
SeaDude
SeaDude

Reputation: 4405

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:

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

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"
    }
  }
}

enter image description here enter image description here

What am I missing?

Upvotes: 0

Views: 1183

Answers (1)

SwethaKandikonda
SwethaKandikonda

Reputation: 8254

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'

Upvotes: 1

Related Questions