Share via

[SQL Server] Odata issue with aggregation and filter

Sylvain 216 Reputation points
2021-09-15T08:14:04.71+00:00

Hi,
Using the action "Get Rows" from SQL Server standard connector:

  • With only the aggregation transformation it works fine
  • With only the filter query it works fine
  • With both it fails (see picture, it generates a BadRequest)

Thanks for your help.

132248-get-rows.png132167-get-rows-error.png

Azure Logic Apps
Azure Logic Apps

An Azure service that automates the access and use of data across clouds without writing code.

0 comments

Answer accepted by question author

Sylvain 216 Reputation points
2021-09-15T08:23:42.61+00:00

Ok found it: since the aggregate rename the column, I had to replace the name of the previous column "pixocect" with the new ones "DistinctInvoices".
With this change, it works.

Was this answer helpful?

1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.