Forum Discussion
Data refresh not working;
Super UserThe way to solve this is you will need to take the steps from your other table and put it all into a single table without referencing the other table.
How can I generate something to put between the <twin:sessionID> ?
The SessionID query table code looks like this:
let
Source = Xml.Document(Web.Contents(""& URL_Logon &""
,[Content=Text.ToBinary("
<soap:Envelope xmlns:soap="&Character.FromNumber(34)&"http://schemas.xmlsoap.org/soap/envelope/"&Character.FromNumber(34)&" xmlns:xsi="&Character.FromNumber(34)&"http://www.w3.org/2001/XmlSchema-instance"&Character.FromNumber(34)&" xmlns:xsd="&Character.FromNumber(34)&"http://www.w3.org/2001/XmlSchema"&Character.FromNumber(34)&">
<soap:Body>
<Logon xmlns="&Character.FromNumber(34)&"http://www.twinfield.com/"&Character.FromNumber(34)&">
<user>"& User &"</user>
<password>"& Password &"</password>
<organisation>"& Organisation &"</organisation>
</Logon>
</soap:Body>
</soap:Envelope>
"),Headers=[#"Content-Type"="text/xml;charset=UTF-8"]])),
Value = Source{0}[Value],
Value1 = Value{0}[Value],
Value2 = Value1{0}[Value],
#"Filtered Rows" = Table.SelectRows(Value2, each ([Name] = "SessionID")),
#"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Value"}),
Value3 = #"Removed Other Columns"[Value]
in
Value3