Forum Discussion

Mikki's avatar
Mikki
New Contributor III
2 months ago

Fetch Metadata values from Text file in Transformation Event Handler

Hi Experts, I am working on TransformationEventHandler rule in which we need to read the first 4 columns of a text file that is being uploaded to Workflow Import so I can do some sanity checks and ...
Parsing
DanielWillis's avatar
DanielWillis
Valued Contributor
2 months ago

Hey Mikki

Not directly answering your question but just wanted to check if you'd seen whether using a Connector Rule on a file data source would better suit your requirement? I mention it because many don't know about the functionality, allowing you to read a file straight into a BR before handing it to the data source.

You can find an example @ https://community.onestreamsoftware.com/t5/Community-Blog/Beyond-Flat-and-Delimited-Files-How-to-Load-XML-or-JSON-Data/ba-p/28185

- Daniel