Map Data to XML Structure and Pass WebService

Unknown

Map Data to XML Structure and Pass WebService

Unknown

Hi,

I was hoping that I could get some help in how to map data into an XML structure. So I can pass that data into an XML Post Web Service as XML deserialized. Im currently passing the XML as a data string to the web service. Although this works, it doesnt give us the dynamic ability to pass in different data values, as the service data will be different for every request. I need help in taking the data, from the database. Mapping it into the XML structure and then deserializing the data so I can pass it to the body of the request. How is this accomplished?

Thanks,

Unknown

[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]Hi,[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]1. In order to fetch your data from the Database and posting it by using XML Structure, you have to use Screenshot-1 flow structure. [/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
2. First of all, you need to use Fetch Entities step to get your data from the database.

3. Then you have to create data type by using [b]Create DataTypes/Integration[/b] tab.

4. Now, you can add POST step and match input/output data to your flow to post your data.

5. I hope this helps you to solve your problem. If you have any problem or questions please let me know.

[/font][/color][color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][b]Screenshot-1 [/b][/font][/color][color=rgb(34, 34, 34)]font=Arial, Helvetica, sans-serif[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][img]att8[/img][/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][b]Screenshot-2[/b][/font][/color][color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif] (Create DataType)[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][img]att7[/img][/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][b]Screenshot-3[/b][/font][/color][color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif] (Select Create Types From XML)[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][img]att6[/img][/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][b]Screenshot-4[/b][/font][/color][color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif] (Name your structure and upload your XML file)[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][img]att5[/img][/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][b]Screenshot-5[/b][/font][/color][color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif] (Find your XML structure in Steps menu under XML Structures name, Pick serialized data and drag to your flow)[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][img]att4[/img][/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][b]Screenshot-6[/b][/font][/color][color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif] (Click on XML serialize step, go to properties, click on Object to Serialize and select Build Data. Do the same action until you reach core data)[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][img]att3[/img][/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][b]Screenshot-7[/b][/font][/color][color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif] (Go to your Fetch Entities and XML Serialize input mappings and match database data with XML serializing data) [/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][img]att2[/img][/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
[/font][/color]
[color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][img]att1[/img][/font][/color]
[i]edited by kenan@decisions.com on 3/12/2019[/i]
[i]edited by kenan@decisions.com on 3/12/2019[/i]