Welcome back. In this video, we are going to understand about how to transform the XML input. Till now we have transformed JSON input. But now we'll see how to transform the XML input. Okay, so now I have this sample XML, I'm expecting the data to be in the form of XML like this, where I have route Tigers products, and a lot of product tags. Let's see how to transform this JSON to solve this XML to JSON.

Very simple. Again, I'll be working on this transforming XML. Here I have an empty flow. And I will define the payload metadata click on define and say my Redux XML Here I know the type is XML. I have an example. I'll point it to SRC main resources.

Products dot XML. Okay detected. So on the left side is showing payload under that we have products and we have product star repeated things. So let's see sample data, right click in sample data. Yeah, this is a sample data. Now, simply, I want to convert it to Java as a payload and I want to see the preview.

You can see the preview Actually, it is containing products. Preview is like a map. its kinetic products. How many product is showing actually here? Only one product. How come?

Okay, let's continue. And this product actually it's showing it as a map. Again, right? This is the raw data, whatever you're seeing down is the raw data and this is the actual converted object. So you can see that output is nothing but a map map. Because when you're converting an XML, the root action will always be converted to map only because root tag will be taken as a key and body will be the value every tag will be a key toggling we will a key and the body of the tag will be the value like that here it is taken products is our key and water is the body is a very in that product is a key and again it has a board like that right?

But actually tagname is same right? Can you guess why only one product is played in output in the map? Actually this is a map or the key tagname tag name is a key for each product the key same for each product is same if we put things inside the lab what will happen, the value will be overwritten is that so you can see actually the value of the productivity six. So last Friday is what we are seeing because the key is Same for the map whenever we are trying to put in a map or try to convert it to dw let us see now. Yep, now you can see the preview. Here, when I'm converting to dw, that's okay, I got all the products, product with ID one product with ID, two, three, etc.

When I'm converting just with the left side to right side, it's it's like every product is visible here, right? But when I convert with Java, since in Java, it's converted to a map. Since it's converted map, this is output, the actual output only one product is there because what will become the key inside this map tagname if there are six products for all the six products, the tablets product on. So all the values got overridden and we are seeing only the last product. Okay? What I'll do is I said product payload dot, the keys products.

Product if I say I'm getting an S zero hash. Actually, whenever you have a tag belonging to namespace we are to actually give information about the namespace here. I can read ns ns zero. What is a namespace is I'll copy this and paste it here. So now I'm telling that I'm referencing to product tag under this namespace. So On the top, you're specify LS and give an alias we'll say my ns, then here at use my and let's hash the referencing to prototype belongs to this namespace.

Okay? So once it's selected products see the preview? Well I got one product and it's a dot product. See I got only the key value pairs present inside first product actually want to stuff for products. So whenever you are whenever you want the repeated element, get you start, start. See now I got a list of all products.

So one difference you need to understand is whenever you are having repeated tags in an accent And if you want a list of all the repeat tags use star. This is one difference between XML and JSON processing. Now, this is a is a list and you got a list. You can store this in a variable, I'd say that products in question. And then here I'll simply write products. Now, product is a list.

Whatever operations we're doing in our earlier video, same thing are applicable. The only difference is whenever you are working on XML input, and if you want a list out of repeated elements or just rest Allah, same. That's all what I want to talk about XML transformations. Now. Let's see. The types data types in dw.

If you see I have opened this dw types where I have some configuration already. Now here, you are seeing the left side is an xml. xml is converted to Java type by iterating over it using a map. If I see the preview, see here, one is considered to be a string, all our strings only. But I know one, PhD is a number, how to do typecasting. It's very simple.

You say explicitly as number one, you know it's a digit number. Right? See here now as number and we got integer Similarly offered price also is a number heroes I'll use as number nine number is a predefined type. Okay? And what about offer valid until, for violently looks like to be a date, but here I'm getting it as a string. So how to convert it to data object as the now you can see after voluntas is converted to data object that but actually whenever you're converting string to date you tell what to expect input format I didn't tell but still it worked because by default the expected input format is what bye bye bye bye mmm DD but let's see you're getting data in different format.

How does Specify the input format. What you can do is can just use like this format alright yyyy mm DD. So this is how you have to specify the input format by default even if you don't specify the format also the sense that's right. But if you are date format is something else you have to specify the format like this. Let's assume that in my dw has a lot of places where I want to write where I have screen to get conversions every place I have to specify the format and date like this regard. If I can define my own type is it so We can define our own type, how to define our own type, it's very simply a trade type my day is a custom date and I just copy paste this format here.

So, I define my own date my own type and widescreen format also, whenever I want to use same conversion same string to date conversions everywhere I can use my date. Now, if you understood how to convert, how to actually define your own types, okay, but now you can see that offer is of rate map and this whole thing also is of type. Actually, I have a Java class in the same project called as offer offer is having two variables offer price offer value until offer prices double and approval endless data I don't want to hear an object of type nap for offer I want it to be class so what I can do is I can different type here type of the object here what I can do is for offer I don't want it to be a map I want to be an object so as object I can specific class never code comm dot line dot offer yeah I saved it the non landed offer Yeah.

So is my whole class name. As you can see that this offer tag is converted to offer. Similarly if I want the whole list of products to be converted, list of IDs of map I want product so what I can do is as object and here I can specify class way to react but when I'm converting to product it's not converting it's giving an error. Wait, because here if I see the keys are up ID name right. The keys should match the properties here I have product ID as a key. so here also whenever I'm creating who the key should be same as expected in the class.

And what is product name? Name is same. brand name is same. And restaurant looks the same. Let us see the preview right now. Is there anything else to be changed?

Yep, nauseous. Now you can see here the preview is an object of products. So now we understood how to specify our own types, number, date, product, etc. And this is very specific when you're converting to Java when you're converting to Jason doesn't make any sense to convert this product can offer. All right, so whenever you're converting to Java itself, should be moving to a specific about what is the type of the variable and the class types. So, these are we can define the types you can define your custom type and you can type cast also.

Right. So great. In this video, you understood XML transformations and also typecasting how to define your own types. Now, you have a lab, you have to open this document level Transformers complex. There are step one in step two and step three is to complete all the steps. This is a very good exercise.

Please don't skip this exercise. Do as per the document. See when next video