Using File Endpoint- Reading Files

Mule 4 Indepth Using File Endpoint
13 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€65.39
List Price:  €93.41
You save:  €28.02
£55.92
List Price:  £79.90
You save:  £23.97
CA$96.01
List Price:  CA$137.16
You save:  CA$41.15
A$107.15
List Price:  A$153.08
You save:  A$45.93
S$95.13
List Price:  S$135.90
You save:  S$40.77
HK$547.14
List Price:  HK$781.66
You save:  HK$234.52
CHF 63.86
List Price:  CHF 91.23
You save:  CHF 27.37
NOK kr775.40
List Price:  NOK kr1,107.76
You save:  NOK kr332.36
DKK kr487.78
List Price:  DKK kr696.86
You save:  DKK kr209.07
NZ$118.01
List Price:  NZ$168.60
You save:  NZ$50.58
د.إ257.06
List Price:  د.إ367.24
You save:  د.إ110.18
৳7,680.49
List Price:  ৳10,972.60
You save:  ৳3,292.11
₹5,842.03
List Price:  ₹8,346.11
You save:  ₹2,504.08
RM332.86
List Price:  RM475.54
You save:  RM142.67
₦86,437.65
List Price:  ₦123,487.65
You save:  ₦37,050
₨19,491.96
List Price:  ₨27,846.85
You save:  ₨8,354.89
฿2,586.09
List Price:  ฿3,694.58
You save:  ฿1,108.48
₺2,265.39
List Price:  ₺3,236.41
You save:  ₺971.02
B$363.53
List Price:  B$519.35
You save:  B$155.82
R1,302.64
List Price:  R1,861
You save:  R558.35
Лв127.90
List Price:  Лв182.73
You save:  Лв54.82
₩96,270.48
List Price:  ₩137,535.16
You save:  ₩41,264.67
₪262.29
List Price:  ₪374.71
You save:  ₪112.42
₱4,033.94
List Price:  ₱5,763.02
You save:  ₱1,729.07
¥10,867.12
List Price:  ¥15,525.12
You save:  ¥4,658
MX$1,187.12
List Price:  MX$1,695.96
You save:  MX$508.84
QR254.93
List Price:  QR364.20
You save:  QR109.27
P994.08
List Price:  P1,420.18
You save:  P426.09
KSh9,360.69
List Price:  KSh13,372.99
You save:  KSh4,012.30
E£3,358.63
List Price:  E£4,798.26
You save:  E£1,439.62
ብር4,003.77
List Price:  ብር5,719.92
You save:  ብር1,716.15
Kz58,546.63
List Price:  Kz83,641.63
You save:  Kz25,095
CLP$67,216.99
List Price:  CLP$96,028.39
You save:  CLP$28,811.40
CN¥506.70
List Price:  CN¥723.89
You save:  CN¥217.19
RD$4,073.53
List Price:  RD$5,819.58
You save:  RD$1,746.04
DA9,418.34
List Price:  DA13,455.35
You save:  DA4,037.01
FJ$158.31
List Price:  FJ$226.17
You save:  FJ$67.86
Q543.96
List Price:  Q777.12
You save:  Q233.16
GY$14,650.29
List Price:  GY$20,929.88
You save:  GY$6,279.59
ISK kr9,815.39
List Price:  ISK kr14,022.59
You save:  ISK kr4,207.20
DH707.71
List Price:  DH1,011.06
You save:  DH303.35
L1,237.78
List Price:  L1,768.33
You save:  L530.55
ден4,025.24
List Price:  ден5,750.59
You save:  ден1,725.35
MOP$563.96
List Price:  MOP$805.69
You save:  MOP$241.73
N$1,304.33
List Price:  N$1,863.42
You save:  N$559.08
C$2,570.38
List Price:  C$3,672.13
You save:  C$1,101.75
रु9,397.27
List Price:  रु13,425.24
You save:  रु4,027.97
S/263.43
List Price:  S/376.35
You save:  S/112.91
K270.11
List Price:  K385.89
You save:  K115.77
SAR262.49
List Price:  SAR375.01
You save:  SAR112.51
ZK1,873.89
List Price:  ZK2,677.10
You save:  ZK803.21
L325.37
List Price:  L464.84
You save:  L139.46
Kč1,643.47
List Price:  Kč2,347.91
You save:  Kč704.44
Ft25,458.03
List Price:  Ft36,370.18
You save:  Ft10,912.14
SEK kr764.90
List Price:  SEK kr1,092.76
You save:  SEK kr327.86
ARS$61,327.27
List Price:  ARS$87,614.14
You save:  ARS$26,286.87
Bs483.57
List Price:  Bs690.85
You save:  Bs207.27
COP$273,218.78
List Price:  COP$390,329.27
You save:  COP$117,110.49
₡35,710.66
List Price:  ₡51,017.42
You save:  ₡15,306.75
L1,733.65
List Price:  L2,476.75
You save:  L743.09
₲524,442.73
List Price:  ₲749,236.02
You save:  ₲224,793.28
$U2,683.09
List Price:  $U3,833.15
You save:  $U1,150.06
zł283.24
List Price:  zł404.64
You save:  zł121.40
Already have an account? Log In

Transcript

Welcome back. In this video, we are going to understand how to use file module how to configure file connector and how to trigger a flow when a new file is added to a directory. So, I'll tell you my requirement in my C drive I have a folder called as files inside this I have input whenever I keep any file into this folder, I want the flow to be triggered and process the file that is my simple requirement. So actually, in the lab documentation, which is shared to you, I have sales dot CSV l LP open it it is simple CSV file, which contains some sales related line each line is one record. I want to process all this records by pulling for a file in this input directory. So let us see So I'll be working on this project using file module.

I'll drag and drop. There's no file module here, I had to add a module. file, drag it to the left side. So the file module should be added here in the class path. Now there is an operation called as on new or upload for updated file. I'll drag and drop flow with this.

Yeah, so I'll configure the properties of this one. For this also added to configure configuration for every endpoint as I told you, there is one configuration here let's check what tasks in this character configuration. Yep, it is asking for a working directory. The base directory for all this so I want to see called files with a working directory. Working Directory is nothing but a big Directly Okay. Now, here there is one more attribute which is asking directly.

I'll give this as input so I want to pull four files in C colon files slash input. And what are the recursive checkbox? recursive means suppose under c colon files colon input slash input. If there are some recursive directories directory inside our directory answer directory, if I want to go into all his directives recursively and pick the files, then I can simply say recursive by selecting this checkbox. Okay. A lot of other options in this file and point I will discuss next, but I want to drag and drop the logger to display the content of the file.

Okay, I'll drag and drop the logger and I just configure it to log the payload. Simply I'll write hash payload. Okay. Now let me start. Okay, the application got deployed. Now what I'll do is, I'll copy this sales dot CSV and paste it inside the input.

Let's observe the console. See, the file content is printed. I'll clear the console. Again, the file control is printed out their console. It's actually what is happening is the final Still there, the files still there. Again, when the file endpoint polls, the file is that login ticket.

It's actually if you see here in my file endpoint configuration, I have configured it to Paul by default. For a fixed frequency scheduling strategy, you can see it is configured to pull up our scheduled frequency of 5000 milliseconds, I'll make it as five and time notice seconds so I want you to call for every five seconds now. So after every five seconds, what it is doing is polling the input directory and reading it, but the file is not deleted, the file is not deleted in the next poll also same file will be processed. So I want the file to be deleted. Is there an option? Let's see.

Yes, there is In a section called as post processing section, where you can configure auto delete equals true. Okay, now I will save my file. I will restart. Okay, it started now what I'll do is I'll keep my sales are CSV again the input directory. It should get processed and it should be deleted after it is processed. Let's wait.

Yep, see it got deleted. And now you can see the console right? So if I just configure the end Point to delete, it'll automatically delete once a file is processed. Sometimes I don't want the file to be deleted, so I'll make it as false. I want the file to be moved to some other directory. So what I have done is in the sequel files, I have output directory I want the files to be moved to this one.

So what I'll do is here c colon slash files slash output as a mood, I want the files to be read to move directly so I'll go and create a directory called us. mode. Okay. And in this mode directory, what should be the file name? Actually, to retrieve the file name, what I can do is I can say attributes dot file name, so this will give me the original file. Name and I want to concatenate it with say, dot backup.

I want the file to be moved and it should be renamed to a file with extension dot bak. Now let us see I made these auto auto deltas false Now let us see. Better I will restart it and killing it. So let me restart. Okay, it got started so I'll copy the sales dot CSV into files. So it should be automatically picked up and it should be mowed right now after five seconds Three seconds is over what is happening Yeah, it got picked up and in the mood directory let us see yes I can see says our CSV dot backup.

So now you understood the option of how to move the process to file. Okay. I don't want it to be moved. I want the file and also I don't want the file to be deleted from the input folder. So what to do, there is one option in file module called as watermarking. So first of all I will remove this moto directory and renamed to okay.

So here there is something called as watermarking which is disabled. So here I'll configure it as modified timestamp. I like explain you what is this watermarking right now. So again, I will restart after enabling the watermarking. I'm going to restart Oh, it's already running. So I want to stop and start.

So I'll wait for it to start. Okay, it started now. I'll put the file says our CSV in the input. I see that the file got processed once. I'll clear this and I will check if in the input that there is a file still there. Yes.

Still the file is there. But after five seconds, Let us wait it should not be processed. So actually, it will not get reprocessed. Even though the file is present the on new or upload file connector, it understood that the file was already processed, how actually I selected watermarking murders modified timestamp, what is watermarking actual the watermarking concept came from maybe I can say the dams, if you have seen any water dams which are created, which are actually present there will be water level every day the people who are working on at the dams they wanted to record the water level every day. So, every day to port for time, they will they used to create in olden days, they used to create one Mark they used to mark the level of water and then next day they used to compare what is the level of water today.

So, the word watermarking came from that point simply Here in case of fire endpoint, the fire endpoint what it will do is now it will whenever the fire is processed, here it is configured to store. It's configured to store what modified timestamp, the timestamp of the file the modified timestamp of the file. So the file is not modified, it will not be reprocessed. Even after the next poll, it will check what is the modified timestamp. If the file is not modified, it will not reprocess so what I'll do is right now, I just go to the input directory and I'll open the sales and I will delete one line modifying it. So now let us see if it gets reprocessed.

And observe the console. Yes, it got reprocessed is it. So that means after the fight is modified when the file in point went for the next poll it chequered. What is the updated timestamp of this file? Is this greater than whatever I have saved earlier? Yes.

So it will reprocess the file that is what watermark mode. So, it can also configure as created timestamp. So, if you configure the watermark in more as created timestamp, what the file endpoint will store the file creation time, even though your file is modified. Now, it will not be picked up with the next poll, because the Create timestamp will always remain same. so if you want the file to be processed only once, even though the file is not final file is modified you don't want it to process. Then you can select Create a timestamp, or if you want the file to be processed whenever it is modified, it can select modified timestamp Right.

So now you understood about watermarking also. In the next video, we'll see how to write the files. See you in next video.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.