Hi, so i just learned webMethods currently, i really want to know, is it possible to read a file from file polling and then validate the content of the file?? If it’s possible, could you guide me to do that?

Yes.

File pollers are IS admin configurations used to identify if an expected file appears in directory

Once file is found by file pollers, it will invoke a service

You can code this service to read file (getFile Service) and read as bytes or stream based on size of file.

You can write Schemas and validate structure during parsing.

I’ve created the file polling and running a manual service to insert value inside the files to DB now can i automate it? if yes, how? Automate means like when i put file, the file will insert to DB without running the service

Hi Vincent,

Assuming that you create the File Polling Port by hand from the UI, you have to specify the processing service.

Once the port finds something in the Monitoring directory, it will execute the processing service.

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/6eca58bcab06c857b4f4de6be3e0d561698025d5_2_1035x465.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/6eca58bcab06c857b4f4de6be3e0d561698025d5.png 2x" data-dominant-color="D5D7CF">

fpp.png1141×513 33.7 KB

Hi Vincent,

as pointed out above:

when you already have the processing service for the file polling port available to read in the file and validate it as well as the service for inserting into DB you can just add an invocation of the insert service at the end of the processing service.

So, when the file arrives, it will be read in, validated and then handed over to the inserting service.

Regards,
Holger