The 'from' property value in the 'query' action inputs is of type 'Object'. The value must be an array

byMaheshkumar Tiwari •8:38 PM

0

{tocify} $title={Table of Contents}

In a logic app where I have to read the blob files having specific suffix in name from the list of blobs, I used Filter Array from Data operations.

Input to it is the output of Http call (Previous step) which gets the list of blobs and with filter on Name

Filter array is an action in Azure Logic Apps that can be used to filter an array/list/collection of items/records based on a certain condition.

It returns an array of items that meet the specified condition. You can use this action to filter an array of objects or an array of strings.

In testing it worked fine except for one scenario - when there was only one record in the list.

When there was only one blob the http call to get list returned one item/record - so array was not formed, it remained as single JSON object.

And it is used as the input to Filter array, but Filter array doesn't allow anything other than array. Thus it throwed the error.

"BadRequest.The 'from' property value in the 'query' action inputs is of type 'Object'. The value must be an array. "

Having a single blob file is a valid scenario, and also the complain by Filter Array action is also valid - so how to solve it.

We take help of array function, which helps in converting the input into an array

Thus the input which is already an array will remain so, and if single object is received then it is converted to array.