How to create csv file from sql get rows on logic apps

user_5778015 0
Viewed 4520

I have created recurrence then i have connected sql server and getting rows from table . I want to export csv file from sql rows and send email

azure-logic-apps
1 Answers
  1. Use the Compose CSV Action to convert the output of SQL to CSV.
  2. Convert the output to Base64 string using the @base64() wdl function
  3. Convert the base64 string to binary using the @base64toBinary() wdl function
  4. Pass the output of Step 3 the to Attachment Content in logic app action
  5. Give a name to the attachment with .csv extenstion

Refer here for more details

user_32126390
Related