[SQL Server] Odata issue with aggregation and filter

Sylvain 216 Reputation points

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.


Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,943 questions
0 comments No comments
{count} votes

Accepted answer
  1. Sylvain 216 Reputation points

    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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful