question

50032637 avatar image
0 Votes"
50032637 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

50032637 avatar image
1 Vote"
50032637 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.

@50032637 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 ·