EnterWorks - ETT 147 - How to Strip Empty Fields from XML or JSON Exports Using a Post Processor
Data Flow, Export Post-Processing
Some versions of EnterWorks include attribute tags (XML) or keys (JSON) when there is no value for the attribute, even though the option to include null values is set to NOT include them. This can result in very large XML or JSON files.
While waiting for a version of EnterWorks in which this has been addressed, the empty fields can be stripped out of the export using a Post Processor, launched from a Scheduled export.
This session shows how to create and use the Post Processor (code for Processor included).
Prerequisites - ETT 053