Share via

Logic App- Export file from SQL Sproc resultset to CSV

Yomi 96 Reputation points
2021-02-15T04:40:23.937+00:00

I am trying to copy SQL table (object) resultset to a CSV format using Logic App but I keep getting this error (screenshot). ANY help is welcome

68303-error.png

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,542 questions
SQL Server Other
Accepted answer
  1. Yomi 96 Reputation points
    2021-02-16T04:13:09.993+00:00

    @Olaf Helper I added parse json, initialize variable and Append to array variable step respectively between Execute stored procedure and CSV and it worked. Thank you so much for helping

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Wayne F 6 Reputation points
    2021-11-08T03:41:52.983+00:00

    Also this should work:
    In the Create CSV table component and in the "From" field , code an expression like:
    outputs('Execute stored procedure (V2)')?['body/resultsets/Table1'].
    This will return the 1st (or only) resultset as an Array

    1 person found this answer helpful.
    0 comments
  2. Chandrasekhar Thiyagarajan 1 Reputation point
    2022-11-15T13:18:12.877+00:00

    Hi @Wayne F . Thanks Bunch for your valuable post. I had same issue as like @Yomi . Your solution only helped me to came out of the issue. Have a wonderful time. Keep rocking. Thanks again!!!

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.