Hi,
Here is what I am trying to do in creating a logic apps:
Process the flat file (.txt) on SFTP and do schema validations based on pre-defined rules.
Validation requirements are:
• Validate flat file (delimeted) against a flat file schema (multiple formats for different source systems) including mandatory fields and field type of each column
• If validation fails, send a file in flat file format with one more fields containing failure reason and send email with failure reasons.
• If validation is successful, transform it to json/xml for further processing.
We have connected to SFTP and able to retrieve the file contents, but now, we were stuck on the schema validation.
Is there anything way that we could pre-define the flat file schema for validation and mapping besides using Microsoft BizTalk Server?
Any help is appreciated!