question

RachelTan-1402 avatar image
0 Votes"
RachelTan-1402 asked RachelTan-1402 commented

Logic Apps Flat File Schema Validation and Mapping

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!

azure-logic-apps
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello anonymous user , Thank you for reaching out. I am currently working on the issue faced, I will share my updates soon.

0 Votes 0 ·
RachelTan-1402 avatar image RachelTan-1402 ChaitanyaNaykodiMSFT-9638 ·
0 Votes 0 ·

0 Answers