web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Extracting data from j...

Power Automate

Unanswered

Extracting data from json with conditions

(0) Share

Report

Report

Posted on by schwibach

2 Moderator

Hello,

I would like to extract data from a json object that I get from a source that uses xapi.

I am interested in the test results for each task. The following json object contains one task called "Kaufvertrag". The score reached was 3.

I got the score out with this code

outputs('Parse_JSON')?['body']?['xapi'][6]?['result']?['score']?['raw']

I cannot be sure that the result will be in the sixth element of ['xapi'] and in future I want to get out the results of more than one task and write the data into a table with a column for each task.

My end goal is to get the

Name and the score of all the tasks that were "answered".

I don't know if we could maybe create a new array of objects that contain the name and score of all the tasks that were done. Then I could match the array to the database that I need to enter into.

I'm open to any and all solutions.

Thank you guys!

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @schwibach ,

Have you tried to create the array? Since you mentioned that you will need to get all items from the xapi json and filter the answered tasks, I think this will be the exact way to achieve that goal.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No

Join the conversation