SQL Get Rows - row count

Like (0) Share

Report

Posted on 13 Feb 2024 10:47:00 by DuncanIVH

I have been using the following expression with an om premises SQL Get Rows action, to check if any rows were returned:

length(body('Get_rows_(V2)')?['value'])

Recently this seems to have stopped working and I get the error:

Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'length' expects its parameter to be an array or a string. The provided value is of type 'Null'.

Has anyone else experience this? I have been using the above for years and it has been fine.

All responses (2)

Answers (0)

DuncanIVH 86 on 13 Feb 2024 at 11:54:56

Like (0)

Report

Re: SQL Get Rows - row count

ems to be related to the SQL view that I'm selecting from. Some views return an empty Body, others return no body at all
DuncanIVH 86 on 13 Feb 2024 at 11:08:13

Like (0)

Report

Re: SQL Get Rows - row count

I have also tried
length(outputs('Get_rows_(V2)')?['body/value'])