Advertisement
Guest User

Untitled

a guest
Mar 18th, 2024
40
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 2.52 KB | None | 0 0
  1. let
  2.     url = "https://wyszukiwarkaregontest.stat.gov.pl/wsBIR/UslugaBIRzewnPubl.svc",
  3.     klucz = "abcde12345abcde12345",
  4.     regon = "000331501",
  5.     soap = "<soap:Envelope xmlns:soap=""http://www.w3.org/2003/05/soap-envelope"" xmlns:ns=""http://CIS/BIR/PUBL/2014/07"">
  6.            <soap:Header xmlns:wsa=""http://www.w3.org/2005/08/addressing"">
  7.            <wsa:Action>http://CIS/BIR/PUBL/2014/07/IUslugaBIRzewnPubl/Zaloguj</wsa:Action>
  8.            <wsa:To>" & url & "</wsa:To>
  9.            </soap:Header>
  10.            <soap:Body>
  11.            <ns:Zaloguj>
  12.            <ns:pKluczUzytkownika>" & klucz & "</ns:pKluczUzytkownika>
  13.            </ns:Zaloguj>
  14.            </soap:Body>
  15.            </soap:Envelope>",
  16.     options = [#"Content-Type" = "application/soap+xml;charset=UTF-8;"],
  17.     Source = (Web.Contents(url, [Content=Text.ToBinary(soap), Headers = options])),
  18.     #"Imported Text" = Lines.FromBinary(Source,null,null,1250){6},
  19.     #"Imported XML" = Xml.Tables(#"Imported Text",null,1250){[Name="Body"]}[Table],
  20.     id = #"Imported XML"{0}[Table]{0}[Table]{0}[ZalogujResult],
  21.     soap2 = "<soap:Envelope xmlns:soap=""http://www.w3.org/2003/05/soap-envelope"" xmlns:ns=""http://CIS/BIR/PUBL/2014/07"" xmlns:dat=""http://CIS/BIR/PUBL/2014/07/DataContract"">
  22.            <soap:Header xmlns:wsa=""http://www.w3.org/2005/08/addressing"">
  23.            <wsa:To>" & url & "</wsa:To>
  24.            <wsa:Action>http://CIS/BIR/PUBL/2014/07/IUslugaBIRzewnPubl/DaneSzukajPodmioty</wsa:Action>
  25.            </soap:Header>
  26.            <soap:Body>
  27.            <ns:DaneSzukajPodmioty>
  28.            <ns:pParametryWyszukiwania>
  29.            <dat:Regon>" & regon & "</dat:Regon>
  30.            </ns:pParametryWyszukiwania>
  31.            </ns:DaneSzukajPodmioty>
  32.            </soap:Body>
  33.            </soap:Envelope>",
  34.     options2 = [#"Content-Type" = "application/soap+xml;charset=UTF-8;", sid = id],
  35.     Source2 = (Web.Contents(url, [Content=Text.ToBinary(soap2), Headers = options2])),
  36.     #"Imported Text1" = Lines.FromBinary(Source2,null,null,TextEncoding.Utf8),
  37.     #"Removed Top Items" = List.Skip(#"Imported Text1",6),
  38.     #"Removed Bottom Items" = List.RemoveLastN(#"Removed Top Items",1),
  39.     #"Imported XML1" = Xml.Tables(Text.Combine(#"Removed Bottom Items"),null,1250),
  40.     result = #"Imported XML1"{1}[Table]{0}[Table]{0}[Table]{0}[DaneSzukajPodmiotyResult],
  41.     #"Imported XML2" = Xml.Tables(result,null,1250){0}[Table],
  42.     #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Imported XML2", {}, "Attribute", "Value")
  43. in
  44.     #"Unpivoted Columns"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement