Logic App Execute Query and based on SP result set and assign

Question

I am writing a logic app to to execute SP and return result and based on the result i am builing the Kusto Query till here it's working

after this step i am generating CSV table out of the result set and in that one of the column should be from kusto query how to return result from executed query result to csv column value ?

any thoughts on this ? one more complication is when i execute kusto query it's a forloop so i wont be able to get one item a time any suggestion on how to resolve this

have you considered, instead of running a query and using an additional step to try and persist its results to a CSV file, to run an .export command that does that for you? docs.microsoft.com/en-us/azure/kusto/management/data-export/… — Yoni L.
The result set is from different SP and I am running another sp to get data , Only thing i need now is how to get the result from Kusto query thats executed in logic app i am not seeing properties in dynamic object — R Kumar

R Kumar R Kumar · Accepted Answer · 2019-03-01T15:49:07

-1

votes

I have fixed it using returning as Parse Json and using it from it

Logic App Execute Query and based on SP result set and assign

1 Answers