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.


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.


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.
@sylvain31 Thanks for your answer and glad to know that you were able to resolve the issue. Feel free to 'Accept as Answer' so it can help other community members facing the similar issue.
8 people are following this question.