In my flow, I have a JSON Flattener step which is consistently resulting in the following error:
“Failed to calculate: The step failed to calculate. Please try again.”
I have tried it several times over 2-3 days and I have tried reconnecting the step. Sometimes this error manifests as the step being highlighted red and perpetual “Calculating…” which went on for several hours until I stopped it.
The errored JSON Flattener step is preceded by another JSON Flattener step which is providing an input of 408 rows and 36 columns. The field to be flattened on each row has 52 objects consisting of 4 attribute-value pairs in each object. I believe this should result in about 21,216 rows after flattening.
For example, it has one of these objects for each week of the year:
The objects are enclosed in a set of brackets to indicate the array .
Do you happen to see where I may be going wrong? I have successfully used JSON Flattener in similar ways elsewhere in this flow, so this error is strange. Thank you!