[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.
2,943 questions
0 comments No comments
{count} votes

Accepted answer
  1. 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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful