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

Hi Mikki

Not directly answering your question, but I wanted to check if you'd considered / knew about being able to user a connector BR on a file based import. It basically sends the file straight to a BR and then you process it and send a data table back to the data source. If it quite an under the radar feature which I feel not many people know about which is why i mention it.

Some info @ https://community.onestreamsoftware.com/t5/Community-Blog/Beyond-Flat-and-Delimited-Files-How-to-Load-XML-or-JSON-Data/ba-p/28185

- Daniel