Objetc returns

[d4n13l74]

Hello, I am using power automate for the first time and I have a problem.
I am making a query to a Query, which returns an object.

{

   "statusCode":200,

   "headers":{

      "Pragma":"no-cache",

      "Transfer-Encoding":"chunked",

      "Vary":"Accept-Encoding",

      "x-ms-request-id":"cff19ae7-d876-489d-aff8-8af2dd3c2f50",

      "Strict-Transport-Security":"max-age=31536000; includeSubDomains",

      "X-Content-Type-Options":"nosniff",

      "X-Frame-Options":"DENY",

      "Timing-Allow-Origin":"*",

      "x-ms-apihub-cached-response":"true",

      "Cache-Control":"no-store, no-cache",

      "Date":"Mon, 22 Feb 2021 18:26:38 GMT",

      "Content-Type":"application/json; charset=utf-8",

      "Expires":"-1",

      "Content-Length":"1256961"

   },

   "body":{

      "OutputParameters":{

      },

      "ResultSets":{

         "TableA":[

            {

               "Type":"",

               "URL":"",

               "File_name":"",

               "File_Desc":"",

               "Date_1":"",

               "Date_2":"",

               "Status":,

               "City":"",

               "Number_of_doc":,

               "Client":"",

               "Source":,

               "Order_number":,

               "Order_status":""

            },

            {

               "Type":"",

               "URL":"",

               "File_name":"",

               "File_Desc":"",

               "Date_1":"",

               "Date_2":"",

               "Status":,

               "City":"",

               "Number_of_doc":,

               "Client":"",

               "Source":,

               "Order_number":,

               "Order_status":""

            },

            {

               "Type":"

I have been looking for a way to separate this object into different variables (Type, URL,File_name, etc), so that I can save this information later in a sharepoint list.
I have watched some video tutorials and have been browsing this forum all morning.
I have tried to apply compose and parse json but I have not obtained any satisfactory result.
Could you help me? Please.

[v-litu-msft · Accepted solution]

Hi @d4n13l74,

You could following these steps to process, and I upload my Flow as a zip file under the post, you could download it and import it into your Flows to test:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.