Thanks for the reply.
Yes I used that very same link to configure my initial flow however I require the information at every link to populate the Release date, KB version , OS version etc
I've managed to create an HTTP GET function to retrieve the redirected website. Json export here:
"{\"$schema\":\"https://schema.management.azure.com/schemas/2015-01-01/deploymentTemplate.json#\",\"contentVersion\":\"1.0.0.0\",\"parameters\":{\"logicAppName\":{\"type\":\"String\",\"metadata\":{\"description\":\"Name of the logic app.\"}},\"logicAppLocation\":{\"defaultValue\":\"[resourceGroup().location]\",\"allowedValues\":[\"eastasia\",\"southeastasia\",\"centralus\",\"eastus\",\"eastus2\",\"westus\",\"northcentralus\",\"southcentralus\",\"northeurope\",\"westeurope\",\"japanwest\",\"japaneast\",\"brazilsouth\",\"australiaeast\",\"australiasoutheast\",\"southindia\",\"centralindia\",\"westindia\",\"canadacentral\",\"canadaeast\",\"westcentralus\",\"westus2\",\"[resourceGroup().location]\"],\"type\":\"String\",\"metadata\":{\"description\":\"Location of the logic app.\"}},\"excelonlinebusiness_Connection_Name\":{\"defaultValue\":\"excelonlinebusiness\",\"type\":\"String\",\"metadata\":{\"description\":\"Name of the connection.\"}},\"rss_Connection_Name\":{\"defaultValue\":\"rss\",\"type\":\"String\",\"metadata\":{\"description\":\"Name of the connection.\"}}},\"resources\":[{\"type\":\"Microsoft.Logic/workflows\",\"name\":\"[parameters('logicAppName')]\",\"apiVersion\":\"2016-06-01\",\"location\":\"[parameters('logicAppLocation')]\",\"properties\":{\"state\":\"Disabled\",\"definition\":{\"$schema\":\"https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#\",\"contentVersion\":\"1.0.0.0\",\"parameters\":{\"$connections\":{\"defaultValue\":{},\"type\":\"Object\"},\"$authentication\":{\"defaultValue\":{},\"type\":\"SecureObject\"}},\"triggers\":{\"When_a_feed_item_is_published\":{\"recurrence\":{\"interval\":1,\"frequency\":\"Minute\"},\"splitOn\":\"@triggerBody()?['value']\",\"metadata\":{\"flowSystemMetadata\":{\"swaggerOperationId\":\"OnNewFeed\"}},\"type\":\"ApiConnection\",\"inputs\":{\"host\":{\"connection\":{\"name\":\"@parameters('$connections')['rss']['connectionId']\"}},\"method\":\"get\",\"path\":\"/OnNewFeed\",\"queries\":{\"feedUrl\":\"https://support.microsoft.com/app/content/api/content/feeds/sap/en-us/6ae59d69-36fc-8e4d-23dd-631d98bf74a9/rss\"},\"authentication\":\"@parameters('$authentication')\"}}},\"actions\":{\"Add_a_row_into_a_table\":{\"runAfter\":{},\"metadata\":{\"012QESWE2E76N6HTBR7ZAK7HLW4HAFTBPR\":\"/WindowsUpdateReleases.xlsx\",\"flowSystemMetadata\":{\"swaggerOperationId\":\"AddRowV2\"}},\"type\":\"ApiConnection\",\"inputs\":{\"host\":{\"connection\":{\"name\":\"@parameters('$connections')['excelonlinebusiness']['connectionId']\"}},\"method\":\"post\",\"body\":{\"RSS\":\"@triggerBody()?['title']\",\"Feed 2\":\"@triggerBody()?['summary']\",\"Feed 3\":\"@triggerBody()?['publishDate']\",\"Feed4\":\"@triggerBody()?['updatedOn']\",\"Feed 5\":\"@triggerBody()?['primaryLink']\"},\"path\":\"/codeless/v1.2/drives/@{encodeURIComponent('b!gbgmVYVqGEi_EHz8_D2_Ae6xthDz5bhJjbfln4dtN0JDrLtILLegR4XLuicuPTOy')}/items/@{encodeURIComponent('012QESWE2E76N6HTBR7ZAK7HLW4HAFTBPR')}/workbook/tables/@{encodeURIComponent('Table1')}/rows\",\"queries\":{\"source\":\"me\"},\"authentication\":\"@parameters('$authentication')\"}},\"HTTP\":{\"runAfter\":{},\"type\":\"Http\",\"inputs\":{\"method\":\"GET\",\"uri\":\"@triggerBody()?['primaryLink']\"}},\"HTTP_2\":{\"runAfter\":{\"Initialize_variable\":[\"Succeeded\"]},\"type\":\"Http\",\"inputs\":{\"method\":\"GET\",\"uri\":\"https://support.microsoft.com@{variables('NewURL')}\"}},\"Initialize_variable\":{\"runAfter\":{\"HTTP\":[\"Succeeded\",\"Failed\",\"TimedOut\"]},\"type\":\"InitializeVariable\",\"inputs\":{\"variables\":[{\"name\":\"NewURL\",\"type\":\"String\",\"value\":\"@{outputs('HTTP')['headers']?['location']}\"}]}}}},\"parameters\":{\"$connections\":{\"value\":{\"excelonlinebusiness\":{\"id\":\"[concat('/subscriptions/', subscription().subscriptionId, '/providers/Microsoft.Web/locations/', parameters('logicAppLocation'), '/managedApis/', 'excelonlinebusiness')]\",\"connectionId\":\"[resourceId('Microsoft.Web/connections', parameters('excelonlinebusiness_Connection_Name'))]\",\"connectionName\":\"[parameters('excelonlinebusiness_Connection_Name')]\"},\"rss\":{\"id\":\"[concat('/subscriptions/', subscription().subscriptionId, '/providers/Microsoft.Web/locations/', parameters('logicAppLocation'), '/managedApis/', 'rss')]\",\"connectionId\":\"[resourceId('Microsoft.Web/connections', parameters('rss_Connection_Name'))]\",\"connectionName\":\"[parameters('rss_Connection_Name')]\"}}}},\"runtimeConfiguration\":{\"lifetime\":{\"unit\":\"Day\",\"count\":30},\"collections\":{\"maximumItemCount\":100000},\"performanceProfile\":{\"throttles\":{\"mode\":\"Medium\"}}}},\"dependsOn\":[\"[resourceId('Microsoft.Web/connections', parameters('excelonlinebusiness_Connection_Name'))]\",\"[resourceId('Microsoft.Web/connections', parameters('rss_Connection_Name'))]\"]},{\"type\":\"Microsoft.Web/connections\",\"name\":\"[parameters('excelonlinebusiness_Connection_Name')]\",\"apiVersion\":\"2016-06-01\",\"location\":\"[parameters('logicAppLocation')]\",\"properties\":{\"api\":{\"id\":\"[concat('/subscriptions/', subscription().subscriptionId, '/providers/Microsoft.Web/locations/', parameters('logicAppLocation'), '/managedApis/', 'excelonlinebusiness')]\"},\"displayName\":\"[parameters('excelonlinebusiness_Connection_Name')]\"}},{\"type\":\"Microsoft.Web/connections\",\"name\":\"[parameters('rss_Connection_Name')]\",\"apiVersion\":\"2016-06-01\",\"location\":\"[parameters('logicAppLocation')]\",\"properties\":{\"api\":{\"id\":\"[concat('/subscriptions/', subscription().subscriptionId, '/providers/Microsoft.Web/locations/', parameters('logicAppLocation'), '/managedApis/', 'rss')]\"},\"displayName\":\"[parameters('rss_Connection_Name')]\"}}]}"I need only the right way to extract and format the content.
