![](\"\/Pictures\/Workflow\/yes.gif\")
<\/td>\n <\/tr>\n <\/td>\n <\/td>\n <\/tr>\n <\/td>\n <\/tr>\n <\/tbody>\n<\/table>\nThe Workflow will work in the following manner:<\/b><\/p>\n Let’s start creation of the Workflow.<\/b><\/p>\n 1. Start SharePoint Designer, open the site, point to \u201cWorkflows\u201d, click the \u201cSite Workflow\u201d button on the ribbon and type the name of the Workflow. Click OK. An empty workflow is now created.<\/p>\n 2. Use the Send HTTP GET Request<\/b> action from the HarePoint Activities \u2013 Network<\/a> activity group:<\/p>\n This action allows us to download the required XML file.<\/p>\n Use the XML file URL the first parameter:<\/p>\n Leave the second parameter unchanged and set two variables:<\/p>\n The configured action looks like this:<\/p>\n 3. Now we should check the value in the statusCode<\/b> variable to be sure that the data is received. If the requested data is received, this variable contains the value equal to 200<\/i>. To verify the value of the variable we will use the condition If any value equals value<\/b>. Select the variable as the first parameter and type 200<\/i> as the second one:<\/p>\n 4. Now we should transform the received XML file to HTML. We can do that using the Transform XML<\/b> action which is located in the HarePoint Activities \u2013 Development<\/a> activities category.<\/p>\n Select the response<\/b> variable as the first parameter in this action.<\/p>\n The second parameter should include an XSLT request which transforms XML data into HTML. In our example this request looks like this:<\/p>\n The third parameter is the variable in which the HTML code will be saved. When this action is configured it looks like this:<\/p>\n 5. Finally, we can save the HTML code into the file. To do that, we should use the Create document from Text<\/b> action which is located in HarePoint activities \u2013 Document Library<\/a> activities category.<\/p>\n The first parameter is the variable which contains HTML data.<\/p>\n The second parameter is location of the file which should be created. It should also contain a filename. For example: YOUR_SITE\/Shared%20Documents\/Rates.aspx<\/i><\/p>\n Set the \u201coverwrite\u201d option in the third parameter to overwrite the existing file each time the workflow is started.<\/p>\n The workflow is ready. It looks like this:<\/p>\n\n
![](\"\/Pictures\/Workflow\/example-xml-1.png\")
<\/p>\n![](\"\/Pictures\/Workflow\/example-xml-2.png\")
\n\n
![](\"\/Pictures\/Workflow\/example-xml-3.png\")
<\/a><\/p>\n![](\"\/Pictures\/Workflow\/example-xml-4.png\")
<\/p>\n<xsl:stylesheet version=\"1.0\"\nxmlns:xsl=\"http:\/\/www.w3.org\/1999\/XSL\/Transform\"\nxmlns:gesmes=\"http:\/\/www.gesmes.org\/xml\/2002-08-01\"\nxmlns:cubes=\"http:\/\/www.ecb.int\/vocabulary\/2002-08-01\/eurofxref\">\n<xsl:template match=\"\/\">\n<html>\n<body>\n<table border=\"1\">\n<tr bgcolor=\"#9acd32\">\n<th>Currency<\/th>\n<th>Rate<\/th>\n<\/tr>\n<xsl:for-each select=\"\/\/cubes:Cube\/cubes:Cube\/cubes:Cube\">\n<tr>\n<td><xsl:value-of select=\"@currency\"\/><\/td>\n<td><xsl:value-of select=\"@rate\"\/><\/td>\n<\/tr>\n<\/xsl:for-each>\n<\/table>\n<xsl:value-of select=\"\/\/gesmes:name\"\/>: <xsl:value-of select=\"\/\/cubes:Cube\/@time\" \/>\n<\/body>\n<\/html>\n<\/xsl:template>\n<\/xsl:stylesheet><\/pre>\n
![](\"\/Pictures\/Workflow\/example-xml-5.png\")
<\/p>\n![](\"\/Pictures\/Workflow\/example-xml-6.png\")
<\/p>\n
![](\"\/Pictures\/Workflow\/example-xml-7.png\")
<\/a><\/p>\n![](\"\/Pictures\/Workflow\/example-xml-9.png\")
<\/p>\n![](\"\/Pictures\/Workflow\/example-xml-10.png\")
<\/p>\n