Convert a JSON result to Array required for Create CSV action

Question

Convert a JSON result to Array required for Create CSV action

Srinivas Mehenderker Nath 86

Hi,

In my logic app, I have created steps as follows:

Oracle query step which fetches the result as JSON object
I have an array which I want to convert the JSON which is being returned as QueryResult and ResultSet.
When I try to set the variable value to either of above, it is giving the error as below: The JSON looks like :

   {
     "OutputParameters": {},
     "ResultSets": {
       "Table1": [
         {
           "Field1": "value1",
           "Field2": "value2",
           "Field3": "value3"
        
         },
         {
           ......
   }
   ]
   }

Is there a way by which I can directly parse below JSON to array without the nested loop? The main objective is to pass the JSON to Create CSV.

Thanks,

MayankBargali-MSFT 70,936 Reputation points Moderator

2023-02-28T04:32:29.31+00:00

Hi @Srinivas Mehenderker Nath

Following up to see if Bruno answer and comment helps. Feel free to get back to me if you need any assistance.

Please accept as "Yes" if the answer is helpful so that it can help others in the community. If you need any help/clarification/concerns/follow up questions, then please click on "Add Comment" on my answer and provide more details.

1 answer

Your answer

MayankBargali-MSFT 70,936 Reputation points Moderator

2023-02-28T04:32:29.31+00:00

Hi @Srinivas Mehenderker Nath

Following up to see if Bruno answer and comment helps. Feel free to get back to me if you need any assistance.

Please accept as "Yes" if the answer is helpful so that it can help others in the community. If you need any help/clarification/concerns/follow up questions, then please click on "Add Comment" on my answer and provide more details.

Answer 1

Bruno Lucas 4,436 MVP

Hi @Srinivas Mehenderker Nath

If the main objective is to generate a CSV you can use the Json parser and it should expose the "Table1" as an array ready to be used

First, prepare a valid version of the json. does not need an entire recordset. As long it represents the correct format. (couple records will do):

User's image

Second step: Add a "parse json" action and click on "use payload to generate schema". paste the json in the pop up . It will generate the schema for you

User's image

You don't need to pass to an array. I added below just to show how could be done if the goal is to pass to an array variable. you can go straight to "create csv table"

User's image

and that's it:

User's image

Srinivas Mehenderker Nath 86 Reputation points

2023-02-22T11:23:25.55+00:00

I followed the steps as above, but in Set variable step it failed. it is showing null. However, the Parse JSON step is showing the correct results. Hence subsequent steps are failing. I assigned the Table1 from the Parse Json exactly as above, should it be some other variable?
Bruno Lucas 4,436 Reputation points MVP

2023-02-23T09:31:27.8266667+00:00

Hi @Srinivas Mehenderker Nath

You don't need the "set variable" task if the goal is to create csv

I just left it to show that "Table1" could also be set as an Array.

What is the output you get in the "parse json" task?

did you paste the whole json in the parser window?

the parse json should have an output if succeeds:

for that simple example you can use Create CSV Table with Columns set to automatic

Share via

Convert a JSON result to Array required for Create CSV action

1 answer

Your answer