Export CSV results to file - Bad Request Error Message

Question

I'm trying to create a simple recurring data export from an Azure SQL database. using Azure Logic Apps.

I want the process to be

• Time recurrance
• Run query
• Export results to Storage account

However, I'm unexpectedly failing due to the error message displayed below:

"BadRequest. The 'from' property value in the 'table' action inputs is of type 'Object'. The value must be of type 'Array'."

I cannot find any documentation shedding any light on this, and I definitely wasn't expecting an error message of this type from a "no code" solution.

I have tried skipping this step, but the file export is simple a file without a format, so I have to create a csv within the workflow. Any CODE FREE ideas how to correct / work around this?

Answer 1

Hi @Neil-LinguaBuddy

Welcome to Microsoft Q&A! Thanks for posting the question.

As per the error, the input type is Object where the action Create CSV Table accepts the input type in Array.
If you check the output of your action execute sql query (V2) it will be dynamic. The response will be as below:

{  
  "ResultSets": {  
    "Table1": [  
      {  
        "Column1": "Value1",  
        "Column2": "Value2",  
        "Column2": "Value3",  
        "Column4": "Value4"  
      }  
    ]  
  },  
  "OutputParameters": {}  
}  

To get the array values from the above output in the create csv table you need to traverse to Table1 as below. If you scroll down at the last of your dynamic content you will see the below dynamic content.

Hope the above helps you to resolve the issue. Please let me know if you need any assistance.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.