This type of irregular JSON expansion can definitely be a bit tricky. While there’s no exact way to ‘tell’ Parabola where to look for the data, Parabola will look at the JSON in the first row and use that as a ‘template’ for expanding JSON in subsequent rows. If there is an invalid or missing key in the top row, our expand step JSON step will omit that field in subsequent expanded rows.
Are you able to identify a record that is missing a key? If you’re able to do that, you can then use an “If/Else” step to ‘tag’ rows with missing keys (ex. Use If/Else to create a new column called
Need key? → Rule: If
JSON column doesn’t contain
key name then set the new column value to
You can then use another “If/Else” step to create a new column that directly manipulates all rows where
Needs key = true, virtually rebuilding a complete JSON package. Other steps that can be helpful here include the “Combine Tables” and “Insert Text Column” steps, which you can use to piece the data back together/ add keys to your JSON body.
If you’re unable to unpack the JSON with these suggestions, feel free to send a link to your flow over to firstname.lastname@example.org and we’re happy to make a more specific recommendation over email!