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.
2,827 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,631 questions
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