Unanswered

Array - Object and Array - extract the Array value

(0) Share

Report

Posted on by LW-28112008-0

I have managed to extract from a larger array the following:

[
 {
 "Question": "Question1",
 "Answer": [
 "Answer1"
 ]
 },
 {
 "Question": "Question2",
 "Answer": [
 "Answer2"
 ]
 },
 {
 "Question": "Question3",
 "Answer": [
 "Question4"
 ]
 },
 {
 "Question": "Feedback:",
 "Answer": null
 },
 {
 "Question": "Question4",
 "Answer": [
 "Answer4"
 ]
 },
 {
 "Question": "Feedback:",
 "Answer": null
 }
 ]

I am somewhat struggling with now extracting the Answer, which is still in its own array.

The end objective is to create a document\pdf or excel table with the Question and Answers?

I can never seem to achieve getting an array to a point where I can use each value?

Please could someone assist me.

thanks

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Achavan 286 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LukePWilkins ,
I tried below
1. Initialize variable with type Array

2. Use the Parse json step

3. Read json/array

below is the image of what I tried

Output -
I have read the questions, similarly we can read the answers

Was this reply helpful? Yes No
LW-28112008-0 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Achavan, thank you for taking the time to reply.
I have made progress off of your suggestion! How are you handling where the Answer could be NULL and not of type array, and where it could be of type array.

This payload as an example
{ "Question": "Feedback:", "Answer": null }, { "Question": "Question4", "Answer": [ "Answer4" ] }

the schema is either Answer is of type Array or Null. Can the schema be set to accept either type?

Was this reply helpful? Yes No