question

sylvain31 avatar image
0 Votes"
sylvain31 asked MayankBargali-MSFT commented

[SQL Server] Odata issue with aggregation and filter

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
get-rows.png (14.2 KiB)
get-rows-error.png (19.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

sylvain31 avatar image
1 Vote"
sylvain31 answered MayankBargali-MSFT commented

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@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.

0 Votes 0 ·