BUG - NetSuite Transaction Export with Group Rows and Transformation 2.0
Spent the last few hours trying to figure out why my flow suddenly wouldn't present valid Input preview data for any branches or steps after the initial export. I checked everything, deleted all 42 Transformation 2.0 rules 1 by 1 (because I've seen a "bad" rule cause this before), but didn't manage to smoke out the offender.
I finally figured out it's related to "Group Rows" on the export.
To verify, I set the export to NOT Group Rows, creating a dead-simple single Transformation 2 rule "$.id". I updated the Mock Output and tested previews in the Branch immediately following the export - worked as expected.
Then I turned on group rows, updated Mock Output, updated Transformation 2.0 rule syntax to $[*].id. All downstream previews have the dreaded Input data:
"record": {
"myField": "sample"
}
I've submitted ticket #206987
This is a show-stopper (for me, at least)
Comments
Another clue for this bug: It only happens when there is Mock data. If you clear the Mock data (i.e., call the endpoint and pull live data) things work as expected.
This issue was introduced since the last update, it was all working fine before the update.
Steve Klett thanks for the video and ticket. It does in fact look like a bug when transformation 2.0 rules are used with row records and it breaks downstream previewing. For now, you could use transform 1.0, transform script, or preSavePage script - not ideal I know.
Hi Tyler Lamparter,
Thanks for the reply and confirmation.
Any chance you can provide an ETA on [hopefully] the hot fix that will be pushed out? It will help me decide how to proceed.
Tyler Lamparter
I just set out to re-implement my Transform with transform 1.0, but it doesn't seem possible. There seems to be another bug that erroneously thinks there are transform 2.0 rules when in fact they've all been removed.
I'll move forward script transform.
Steve Klett no eta yet. I updated your ticket to be linked to our internal ticket so you should get updates there once a fix date has been determined.
I've also got this bug on flows without transformation 2.0.
In my case a grouped NetSuite export with a script transformation, and after that a Branch. the branching preview only has the sample record.
Bas van Ditzhuijzen thanks for the added info.
Steve Klett Bas van Ditzhuijzen this should be fixed now. Let us know if you still see the issue.
Please sign in to leave a comment.