Last modified by Olivier Roussel on 2025/04/25 09:57
Change comment:
Renamed from xwiki:Implementatie dcoumentatie.Documentation TerraIndex Export format - dsFieldProject\.xsd.Setting up a Webservice connection to get Overview data from TerraIndex.WebHome
Summary
-
Page properties (3 modified, 0 added, 0 removed)
Details
- Page properties
-
- Title
-
... ... @@ -1,0 +1,1 @@ 1 +Setting up a Webservice connection to get Overview data from TerraIndex - Parent
-
... ... @@ -1,0 +1,1 @@ 1 +Implementatie dcoumentatie.Documentation TerraIndex Export format - dsFieldProject\.xsd.WebHome - Content
-
... ... @@ -1,0 +1,833 @@ 1 +To connect with the TerraIndex database to retreive specific datasets/overviews from TerraIndex, you can connect to a webservice. This webservice provides a function to request the available queries and it’s required Paraterms, and a function to request the actual data. 2 + 3 +An example of such an overview is presented in the image below. 4 + 5 +[[image:1637574454403-426.png||height="346" width="1486"]] 6 + 7 +{{toc/}} 8 + 9 + 10 +== 1. Retreive all overviews queries from TerraIndex == 11 + 12 +To retreive all available queries from the TerraIndex Environment, there is a SOAP webservice call available. This will return all overview queries with it’s names and the required parameters. 13 +With the name and the parameters you can request the actual data with function 2, explained in the next chapter. 14 + 15 +To start connecting this webservice, you should use this URL: 16 +[[https:~~/~~/web.terraindex.com/DataWS/ITWViewServiceASMX_V1_0.asmx>>url:https://web.terraindex.com/DataWS/ITWViewServiceASMX_V1_0.asmx]] 17 + 18 +(% class="box infomessage" %) 19 +((( 20 +If you prefer a REST service, please let us know. It’s currently a SOAP webservice because there will be a typed definition available to avoid mistakes. 21 +))) 22 + 23 +Get the WSDL from: 24 +[[https:~~/~~/web.terraindex.com/DataWS/ITWViewServiceASMX_V1_0.asmx?wsdl>>url:https://web.terraindex.com/DataWS/ITWViewServiceASMX_V1_0.asmx?wsdl]] 25 + 26 +[[image:1637574900554-168.png]] 27 + 28 + 29 +Fill the **Envelope **of a **SOAP **HTTP call with: 30 + 31 +{{code language="XML" layout="LINENUMBERS"}} 32 + 33 +<soap:Envelope 34 + xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" 35 + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 36 + xmlns:xsd="http://www.w3.org/2001/XMLSchema"> 37 + <soap:Body> 38 + <GetOverviewQueries 39 + xmlns="https://wsterraindex.terraindex.com/ITWorks.TerraIndex/"> 40 + <request> 41 + <Authorisation> 42 + <Username>USERNAME</Username> 43 + <Password>PASSWORD</Password> 44 + <Licensenumber>LICENSENUMBER, of the customer</Licensenumber> 45 + <ApplicationCode>YOUR APP CODE, REQUEST at service@terraindex.com</ApplicationCode> 46 + <FeatureWord>0</FeatureWord> 47 + </Authorisation> 48 + <WebserviceVersion>1.0</WebserviceVersion> 49 + <LanguageCode>nld</LanguageCode> 50 + <UseZipStream>false</UseZipStream> 51 + <DataType>JSON</DataType> 52 + <!--JSON or XML --> 53 + </request> 54 + </GetOverviewQueries> 55 + </soap:Body> 56 +</soap:Envelope> 57 +{{/code}} 58 + 59 +Set the correct values for: 60 + 61 +* (% class="mark" %)Username(%%); as the username in TerraIndex 62 +* (% class="mark" %)Password(%%); as the username in TerraIndex 63 +* (% class="mark" %)Licensenumber(%%); as your companies license number 64 +* (% class="mark" %)ApplicationCode(%%); as provided by TerraIndex to you, if not provided, request one at: [[service@terraindex.com>>path:mailto:service@terraindex.com]] 65 +* (% class="mark" %)UseZipStreamto (%%)'true', to get GZip data stream. This will be much faster over the internet. 66 +Check here for the Class to use it: [[Setting up a Webservice connection for project exports>>Implementatie dcoumentatie.Setting up a Webservice connection for project exports.WebHome]], Chapter: Zip Stream class. 67 +* (% class="mark" %)DataType(%%); set the correct data type you would like to receive, this is 'JSON' or 'XML'. 68 + 69 + 70 +You will receive a response like this: 71 + 72 +{{code layout="LINENUMBERS"}} 73 + 74 +<soap:Envelope 75 + xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" 76 + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 77 + xmlns:xsd="http://www.w3.org/2001/XMLSchema"> 78 + <soap:Body> 79 + <GetOverviewQueriesResponse 80 + xmlns="https://wsterraindex.terraindex.com/ITWorks.TerraIndex/"> 81 + <GetOverviewQueriesResult> 82 + <ResultCode>Succes</ResultCode> 83 + <Content>[ 84 + { 85 + "Name": " ", 86 + "Parameters": null, 87 + "Description": "" 88 + }, 89 + { 90 + "Name": "ArcGIS Export - 1 - Coords", 91 + "Parameters": [ 92 + "ProjectID" 93 + ], 94 + "Description": "" 95 + }, 96 + { 97 + "Name": "ArcGIS Export - 2 - An.results", 98 + "Parameters": [ 99 + "ProjectID" 100 + ], 101 + "Description": "" 102 + }, 103 + { 104 + "Name": "ATKB Overzicht 2", 105 + "Parameters": [ 106 + "PROJECTID" 107 + ], 108 + "Description": "" 109 + }, 110 + { 111 + "Name": "ATKB Peilbuisoverzicht 2", 112 + "Parameters": [ 113 + "PROJECTID" 114 + ], 115 + "Description": "" 116 + }, 117 + { 118 + "Name": "BAM Overzicht diameters", 119 + "Parameters": [ 120 + "ProjectID" 121 + ], 122 + "Description": "" 123 + }, 124 + { 125 + "Name": "BBK", 126 + "Parameters": [ 127 + "projectid" 128 + ], 129 + "Description": "" 130 + }, 131 + { 132 + "Name": "BQ6:Toetsing grond(meng)monste", 133 + "Parameters": [], 134 + "Description": "20190805 BOOT Query #6: Toetsing grond(meng)monsters" 135 + }, 136 + { 137 + "Name": "BQ6A:Toetsing grond(meng)monst", 138 + "Parameters": [ 139 + "ProjectID" 140 + ], 141 + "Description": "20190805 BOOT Query #6: Toetsing grond(meng)monsters" 142 + }, 143 + { 144 + "Name": "Corr. watermonsters (STAP)", 145 + "Parameters": [ 146 + "DateBegin", 147 + "DateEnd" 148 + ], 149 + "Description": "Hiermee zoekt u naar watermonsters die voor alle componenten uit het STAP-pakket een <D hebben. Datum invoeren als MM/DD/YYYY" 150 + }, 151 + { 152 + "Name": "datum", 153 + "Parameters": [], 154 + "Description": "" 155 + }, 156 + { 157 + "Name": "field/analysemonsters", 158 + "Parameters": [], 159 + "Description": "" 160 + }, 161 + { 162 + "Name": "FROM ITWBMAM0 AM ", 163 + "Parameters": null, 164 + "Description": "" 165 + }, 166 + { 167 + "Name": "Gebruikte analyses", 168 + "Parameters": [ 169 + "StartDatum", 170 + "EindDatum" 171 + ], 172 + "Description": "Geeft een overzicht van het aantal keer dat analyses gebruikt zijn, in een op te geven periode, per laboratorium/klantcode/prijsafspraak\r\nDatum invoeren als MM/DD/YYYY\r\n" 173 + }, 174 + { 175 + "Name": "Haskoning aangepast", 176 + "Parameters": [ 177 + "ProjectID" 178 + ], 179 + "Description": "" 180 + }, 181 + { 182 + "Name": "Haskoning nieuw", 183 + "Parameters": [ 184 + "ProjectID" 185 + ], 186 + "Description": "" 187 + }, 188 + { 189 + "Name": "ITW Analysemonsters + deelmons", 190 + "Parameters": [ 191 + "ProjectID" 192 + ], 193 + "Description": "Gegevens analysemonsters" 194 + }, 195 + { 196 + "Name": "ITW Analyseresultaten Grond", 197 + "Parameters": [ 198 + "ProjectID" 199 + ], 200 + "Description": "Overzicht van analyseresultaten van grondmonsters" 201 + }, 202 + { 203 + "Name": "ITW Asbest veldmonsters", 204 + "Parameters": [ 205 + "ProjectID" 206 + ], 207 + "Description": "Overzicht van asbestveldmonsters" 208 + }, 209 + { 210 + "Name": "ITW Boringen + Peilbuizen", 211 + "Parameters": [ 212 + "ProjectID" 213 + ], 214 + "Description": "Overzicht gegevens boringen met peilbuizen" 215 + }, 216 + { 217 + "Name": "ITW Dieptes per meetpunt", 218 + "Parameters": [ 219 + "ProjectID" 220 + ], 221 + "Description": "Dieptes van de meetpunten" 222 + }, 223 + { 224 + "Name": "ITW Dubbele watermonsters", 225 + "Parameters": [], 226 + "Description": "Overzicht dubbele watermonsters in de actieve projecten" 227 + }, 228 + { 229 + "Name": "ITW Grondverzet overzicht", 230 + "Parameters": [ 231 + "ProjectID" 232 + ], 233 + "Description": "Analyseresultaten voor de Grondverzet toetsing" 234 + }, 235 + { 236 + "Name": "ITW Lagen incl. Archeologie", 237 + "Parameters": [ 238 + "ProjectID" 239 + ], 240 + "Description": "Lagen inclusief Archeologie kenmerken" 241 + }, 242 + { 243 + "Name": "ITW MVS export", 244 + "Parameters": [ 245 + "ProjectID" 246 + ], 247 + "Description": "" 248 + }, 249 + { 250 + "Name": "ITW Normen Bbk", 251 + "Parameters": [], 252 + "Description": "Normen van het Besluit Bodemkwaliteit" 253 + }, 254 + { 255 + "Name": "ITW Normen Vlarebo", 256 + "Parameters": [], 257 + "Description": "Normen Vlarebo (> 1-6-2008)" 258 + }, 259 + { 260 + "Name": "ITW Project totalen", 261 + "Parameters": [ 262 + "ProjectID" 263 + ], 264 + "Description": "Van diverse onderdelen de totalen in het project" 265 + }, 266 + { 267 + "Name": "ITW Rekencoëfficienten Bbk", 268 + "Parameters": [], 269 + "Description": "Rekencoëfficienten van het Besluit bodemkwaliteit" 270 + }, 271 + { 272 + "Name": "ITW Sada export", 273 + "Parameters": [ 274 + "ProjectID" 275 + ], 276 + "Description": "Alle gegevens om te importeren in Sada" 277 + }, 278 + { 279 + "Name": "ITW Samples Duplicate Bar Code", 280 + "Parameters": [], 281 + "Description": "Report Field Samples With Duplicate Barcode" 282 + }, 283 + { 284 + "Name": "ITW Samples Without Bar Code", 285 + "Parameters": [], 286 + "Description": "Report Field Samples Without Barcode" 287 + }, 288 + { 289 + "Name": "ITW Toetsing Bbk", 290 + "Parameters": [ 291 + "ProjectID" 292 + ], 293 + "Description": "Resultaten toetsing Bbk" 294 + }, 295 + { 296 + "Name": "ITW Toetsing BBK BoToVa", 297 + "Parameters": [ 298 + "ProjectID" 299 + ], 300 + "Description": "Resultaten toetsing BBK BoToVa" 301 + }, 302 + { 303 + "Name": "ITW Toetsing Brusselse", 304 + "Parameters": [ 305 + "ProjectID" 306 + ], 307 + "Description": "Resultaten Brusselse toetsing" 308 + }, 309 + { 310 + "Name": "ITW Toetsing Eigen normen", 311 + "Parameters": [ 312 + "ProjectID" 313 + ], 314 + "Description": "Resultaten toetsing aan eigen normen" 315 + }, 316 + { 317 + "Name": "ITW Toetsing Vlarebo", 318 + "Parameters": [ 319 + "ProjectID" 320 + ], 321 + "Description": "Resultaten toetsing Vlarebo" 322 + }, 323 + { 324 + "Name": "ITW Toetsing Vlarebo Grondverz", 325 + "Parameters": [ 326 + "ProjectID" 327 + ], 328 + "Description": "Resultaten toetsing Vlarebo grondverzet" 329 + }, 330 + { 331 + "Name": "ITW Toetsing Waalse", 332 + "Parameters": [ 333 + "ProjectID" 334 + ], 335 + "Description": "Resultaten Waalse toetsing" 336 + }, 337 + { 338 + "Name": "ITW Toetsing Waterbodem BoToVa", 339 + "Parameters": [ 340 + "ProjectID" 341 + ], 342 + "Description": "Resultaten waterbodemtoetsingen BoToVa (T1, T3, T5, T6, T7)" 343 + }, 344 + { 345 + "Name": "ITW Toetsing Wbb", 346 + "Parameters": [ 347 + "ProjectID" 348 + ], 349 + "Description": "Alle gegevens die nodig zijn om in een gis te importeren met Wbb gegevens" 350 + }, 351 + { 352 + "Name": "ITW Toetsing WBB BoToVa", 353 + "Parameters": [ 354 + "ProjectID" 355 + ], 356 + "Description": "Resultaten toetsing WBB BoToVa" 357 + }, 358 + { 359 + "Name": "ITW Toetsresultaten Wbb", 360 + "Parameters": [ 361 + "ProjectID" 362 + ], 363 + "Description": "Alle gegevens die je nodig hebt om in een gis te importeren met Wbb gegevens" 364 + }, 365 + { 366 + "Name": "ITW Veldmonsters", 367 + "Parameters": [ 368 + "ProjectID" 369 + ], 370 + "Description": "Gegevens veldmonsters" 371 + }, 372 + { 373 + "Name": "ITW Waterm. incl. flessen", 374 + "Parameters": [ 375 + "ProjectID" 376 + ], 377 + "Description": "Overzicht gegevens watermonsters inclusief flessen" 378 + }, 379 + { 380 + "Name": "ITW Watermonsters", 381 + "Parameters": [ 382 + "ProjectID" 383 + ], 384 + "Description": "Overzicht gegevens watermonstername" 385 + }, 386 + { 387 + "Name": "ITW Watermonsters (NL)", 388 + "Parameters": [ 389 + "ProjectID" 390 + ], 391 + "Description": "Overzicht watermonsters" 392 + }, 393 + { 394 + "Name": "ITW Watermonsters uitgebreid", 395 + "Parameters": [ 396 + "ProjectID" 397 + ], 398 + "Description": "Overzicht gegevens watermonstername (uitgebreid)" 399 + }, 400 + { 401 + "Name": "ITW zoeken barcode", 402 + "Parameters": [ 403 + "Barcode" 404 + ], 405 + "Description": "Toont een overzicht van alle veldmonsters met een (gedeelte van) een barcode, en in welk analysemonster ze voorkomen" 406 + }, 407 + { 408 + "Name": "ITW zoeken project", 409 + "Parameters": [ 410 + "ProjectCodeNaam" 411 + ], 412 + "Description": "Zoeken op (gedeelte van) projectcode en projectnaam in archieven en over vestigingen heen" 413 + }, 414 + { 415 + "Name": "ITW Zoeken projectnaam", 416 + "Parameters": [ 417 + "Projectnaam" 418 + ], 419 + "Description": "" 420 + }, 421 + { 422 + "Name": "MP, XY, Lagen", 423 + "Parameters": [ 424 + "ProjectID" 425 + ], 426 + "Description": "" 427 + }, 428 + { 429 + "Name": "MP, XY, Lagen alle Proj", 430 + "Parameters": [], 431 + "Description": "" 432 + }, 433 + { 434 + "Name": "ORDER BY AM.ANLMONSNM", 435 + "Parameters": null, 436 + "Description": "" 437 + }, 438 + { 439 + "Name": "Ovam test", 440 + "Parameters": [ 441 + "ProjectID" 442 + ], 443 + "Description": "" 444 + }, 445 + { 446 + "Name": "Overzicht analyseresultaten", 447 + "Parameters": [ 448 + "ProjectID" 449 + ], 450 + "Description": "" 451 + }, 452 + { 453 + "Name": "Sada", 454 + "Parameters": [ 455 + "ProjectID" 456 + ], 457 + "Description": "Sada export" 458 + }, 459 + { 460 + "Name": "Test", 461 + "Parameters": [ 462 + "ProjectID" 463 + ], 464 + "Description": "Geef meetpunten met x-y" 465 + }, 466 + { 467 + "Name": "Test Env1", 468 + "Parameters": [ 469 + "ProjectID" 470 + ], 471 + "Description": "" 472 + }, 473 + { 474 + "Name": "Test Env2", 475 + "Parameters": [ 476 + "ProjectID" 477 + ], 478 + "Description": "" 479 + }, 480 + { 481 + "Name": "Test Env3", 482 + "Parameters": [ 483 + "ProjectID" 484 + ], 485 + "Description": "" 486 + }, 487 + { 488 + "Name": "test jayme", 489 + "Parameters": [], 490 + "Description": "" 491 + }, 492 + { 493 + "Name": "Test nle", 494 + "Parameters": [], 495 + "Description": "" 496 + }, 497 + { 498 + "Name": "Test vandaag", 499 + "Parameters": [ 500 + "PROJECTID" 501 + ], 502 + "Description": "" 503 + }, 504 + { 505 + "Name": "testLSC2", 506 + "Parameters": [], 507 + "Description": "" 508 + }, 509 + { 510 + "Name": "veldmonsters", 511 + "Parameters": [], 512 + "Description": "" 513 + }, 514 + { 515 + "Name": "Watermonsters over database", 516 + "Parameters": [], 517 + "Description": "" 518 + }, 519 + { 520 + "Name": "Watersamples", 521 + "Parameters": [ 522 + "ProjectID" 523 + ], 524 + "Description": "Watersamples" 525 + }, 526 + { 527 + "Name": "Watersamples in project", 528 + "Parameters": [ 529 + "ProjectID" 530 + ], 531 + "Description": "Shows all water samples in the current project" 532 + }, 533 + { 534 + "Name": "zzw", 535 + "Parameters": [], 536 + "Description": "" 537 + } 538 +]</Content> 539 + </GetOverviewQueriesResult> 540 + </GetOverviewQueriesResponse> 541 + </soap:Body> 542 +</soap:Envelope> 543 +{{/code}} 544 + 545 +The Content JSON looks like this, but is also available as XML: 546 + 547 +{{code language="JSON" layout="LINENUMBERS"}} 548 +[ 549 + { 550 + "Name": "ITW Toetsing WBB BoToVa", 551 + "Parameters": [ 552 + "ProjectID" 553 + ], 554 + "Description": "Resultaten toetsing WBB BoToVa" 555 + }, 556 + { 557 + "Name": "ITW Toetsresultaten Wbb", 558 + "Parameters": [ 559 + "ProjectID" 560 + ], 561 + "Description": "Alle gegevens die je nodig hebt om in een gis te importeren met Wbb gegevens" 562 + }, 563 + { 564 + "Name": "ITW Veldmonsters", 565 + "Parameters": [ 566 + "ProjectID" 567 + ], 568 + "Description": "Gegevens veldmonsters" 569 + }, 570 + { 571 + "Name": "ITW Waterm. incl. flessen", 572 + "Parameters": [ 573 + "ProjectID" 574 + ], 575 + "Description": "Overzicht gegevens watermonsters inclusief flessen" 576 + }, 577 + { 578 + "Name": "ITW zoeken barcode", 579 + "Parameters": [ 580 + "Barcode" 581 + ], 582 + "Description": "Toont een overzicht van alle veldmonsters met een (gedeelte van) een barcode, en in welk analysemonster ze voorkomen" 583 + }, 584 + { 585 + "Name": "MP, XY, Lagen alle Proj", 586 + "Parameters": [], 587 + "Description": "" 588 + }, 589 + { 590 + "Name": "Overzicht analyseresultaten", 591 + "Parameters": [ 592 + "ProjectID" 593 + ], 594 + "Description": "" 595 + }, 596 + { 597 + "Name": "Watersamples in project", 598 + "Parameters": [ 599 + "ProjectID" 600 + ], 601 + "Description": "Shows all water samples in the current project" 602 + } 603 +] 604 +{{/code}} 605 + 606 + 607 +(% class="box infomessage" %) 608 +((( 609 +Is UseZipStream = true; the Content needs to be inflated using the ZipSteamHelper Class. The code can be found here: [[Setting up a Webservice connection for project exports>>Implementatie dcoumentatie.Setting up a Webservice connection for project exports.WebHome]] 610 +))) 611 + 612 + 613 +== 2. Retreive the actual query data from TerraIndex == 614 + 615 +To request the actual data from the Overview query in TerraIndex we have a second SOAP webservice call in the same WSDL/Webservice. 616 + 617 +[[image:1637575660334-733.png]] 618 + 619 +Fill the **Envelope **of a **SOAP **HTTP call with: 620 + 621 + 622 +{{code language="none" layout="LINENUMBERS"}} 623 + 624 +<soap:Envelope 625 + xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" 626 + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 627 + xmlns:xsd="http://www.w3.org/2001/XMLSchema"> 628 + <soap:Body> 629 + <GetQueryResult 630 + xmlns="https://wsterraindex.terraindex.com/ITWorks.TerraIndex/"> 631 + <request> 632 + <Authorisation> 633 + <Username>USERNAME</Username> 634 + <Password>PASSWORD</Password> 635 + <Licensenumber>LICENSENUMBER, of the customer</Licensenumber> 636 + <ApplicationCode>YOUR APP CODE, REQUEST at service@terraindex.com</ApplicationCode> 637 + <FeatureWord>0</FeatureWord> 638 + </Authorisation> 639 + <WebserviceVersion>1.0</WebserviceVersion> 640 + <LanguageCode>nld</LanguageCode> 641 + <UseZipStream>true</UseZipStream> 642 + <ViewName>ITW Toetsresultaten Wbb</ViewName> 643 + <Param>{"ProjectID":"100000218"}</Param> 644 + <DataType>JSON</DataType> 645 + </request> 646 + </GetQueryResult> 647 + </soap:Body> 648 +</soap:Envelope> 649 +{{/code}} 650 + 651 +Set the correct values for: 652 + 653 +* (% class="mark" %)Username(%%); as the username in TerraIndex 654 +* (% class="mark" %)Password(%%); as the username in TerraIndex 655 +* (% class="mark" %)Licensenumber(%%); as your companies license number 656 +* (% class="mark" %)ApplicationCode(%%); as provided by TerraIndex to you, if not provided, request one at: [[service@terraindex.com>>path:mailto:service@terraindex.com]] 657 +* (% class="mark" %)UseZipStreamto (%%)'true', to get GZip data stream. This will be much faster over the internet. 658 +Check here for the Class to use it: 659 + 660 +* (% class="mark" %)Chapter(%%): Zip Stream class. 661 +* (% class="mark" %)DataType(%%); set the correct data type you would like to receive, this is 'JSON' or 'XML'. 662 +* (% class="mark" %)Param (%%)must be the Array as received from the GetOverviewQueries, and filled with data. Always needs to be JSON. 663 + 664 + 665 +You will receive a response like this: 666 + 667 +{{code language="xml" layout="LINENUMBERS"}} 668 + 669 +<soap:Envelope 670 + xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" 671 + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 672 + xmlns:xsd="http://www.w3.org/2001/XMLSchema"> 673 + <soap:Body> 674 + <GetQueryResultResponse 675 + xmlns="https://wsterraindex.terraindex.com/ITWorks.TerraIndex/"> 676 + <GetQueryResultResult> 677 + <ResultCode>Succes</ResultCode> 678 + <Content>H4sIAAAAAAAEAO1R30/CMBD+V0yfhzk3gsnemBgxYdHoIhpjzMEOVuha0rUgEv53y7ATfTcxkbfvV+56/TYsw5EgFj9v2K1WMxqbscodZ2kICUDYaUUhAAu8KxHLnYt6RfykR2JSGY2F5e8kXSolMgsrfaw3gPMEzpzxyGJphQjYkwcpIl+SyAulpoZ+qnc0WQqcN7KSlSH9OTavcLcLjeZvjk61krkTemjszg4hhBa0WxBl0Imjdlwf8ICSxW04hYBlyrD4DGrct6Wt/JqBrSfsSX+QrRfNwy7qb9njm7IaF5rPllxOmxe6y1eI+itVK10xQS+4mzy8JFkc5nI8WDysxyS0Ssk0qft1OVJKeJrM+fDbNidcaUWLJv/aHXqceXC9B9vgF9sOj23/o7ajY9t/rO2X7QeXis4U1QUAAA==</Content> 679 + </GetQueryResultResult> 680 + </GetQueryResultResponse> 681 + </soap:Body> 682 +</soap:Envelope> 683 +{{/code}} 684 + 685 +(% class="box infomessage" %) 686 +((( 687 +Is UseZipStream = true; the Content needs to be inflated using the ZipSteamHelper Class. The code can be found here: [[Setting up a Webservice connection for project exports>>Implementatie dcoumentatie.Setting up a Webservice connection for project exports.WebHome]] 688 +))) 689 + 690 + 691 +The Content JSON looks like this, but is also available as XML (see below the json for xml): 692 + 693 +{{code language="JSON"}} 694 +{ 695 + "Table": [ 696 + { 697 + "Projectcode": "M20B0026-3200", 698 + "Projectnaam": "Marwei Delfstrahuizen", 699 + "Meetpuntnaam": "DL07B01", 700 + "X": null, 701 + "Y": null, 702 + "Maaiveldhoogte": null, 703 + "MaaiveldRefvlak": null, 704 + "Monsternaam": "dsa", 705 + "Matrix": "grond", 706 + "Datum": "2020-04-03T06:34:00", 707 + "Van": 40, 708 + "Tot": 100, 709 + "Humus": null, 710 + "Lutum": null, 711 + "HLType": null, 712 + "Code": null, 713 + "Omschrijving": null, 714 + "Meetwaarde": null, 715 + "MeetwAlfa": null, 716 + "Ref": null, 717 + "Eenh": null, 718 + "Meetdatum": null, 719 + "WaardeBewMeth": null, 720 + "Symbool": null, 721 + "BkiWaarde": null, 722 + "BkiGroep": null, 723 + "S_AW": null, 724 + "T": null, 725 + "I": null 726 + }, 727 + { 728 + "Projectcode": "M20B0026-3200", 729 + "Projectnaam": "Marwei Delfstrahuizen", 730 + "Meetpuntnaam": "DL07B02", 731 + "X": null, 732 + "Y": null, 733 + "Maaiveldhoogte": null, 734 + "MaaiveldRefvlak": null, 735 + "Monsternaam": "dsa", 736 + "Matrix": "grond", 737 + "Datum": "2020-04-03T06:34:00", 738 + "Van": 40, 739 + "Tot": 100, 740 + "Humus": null, 741 + "Lutum": null, 742 + "HLType": null, 743 + "Code": null, 744 + "Omschrijving": null, 745 + "Meetwaarde": null, 746 + "MeetwAlfa": null, 747 + "Ref": null, 748 + "Eenh": null, 749 + "Meetdatum": null, 750 + "WaardeBewMeth": null, 751 + "Symbool": null, 752 + "BkiWaarde": null, 753 + "BkiGroep": null, 754 + "S_AW": null, 755 + "T": null, 756 + "I": null 757 + }, 758 + { 759 + "Projectcode": "M20B0026-3200", 760 + "Projectnaam": "Marwei Delfstrahuizen", 761 + "Meetpuntnaam": "DL07B03", 762 + "X": null, 763 + "Y": null, 764 + "Maaiveldhoogte": null, 765 + "MaaiveldRefvlak": null, 766 + "Monsternaam": "dsa", 767 + "Matrix": "grond", 768 + "Datum": "2020-04-03T06:34:00", 769 + "Van": 40, 770 + "Tot": 100, 771 + "Humus": null, 772 + "Lutum": null, 773 + "HLType": null, 774 + "Code": null, 775 + "Omschrijving": null, 776 + "Meetwaarde": null, 777 + "MeetwAlfa": null, 778 + "Ref": null, 779 + "Eenh": null, 780 + "Meetdatum": null, 781 + "WaardeBewMeth": null, 782 + "Symbool": null, 783 + "BkiWaarde": null, 784 + "BkiGroep": null, 785 + "S_AW": null, 786 + "T": null, 787 + "I": null 788 + } 789 + ] 790 +} 791 +{{/code}} 792 + 793 +The Content XML looks like this: 794 + 795 +{{code language="none" layout="LINENUMBERS"}} 796 +<NewDataSet> 797 + <Table> 798 + <Projectcode>M20B0026-3200</Projectcode> 799 + <Projectnaam>Marwei Delfstrahuizen</Projectnaam> 800 + <Meetpuntnaam>DL07B01</Meetpuntnaam> 801 + <Monsternaam>dsa</Monsternaam> 802 + <Matrix>grond</Matrix> 803 + <Datum>2020-04-03T06:34:00+02:00</Datum> 804 + <Van>40</Van> 805 + <Tot>100</Tot> 806 + </Table> 807 + <Table> 808 + <Projectcode>M20B0026-3200</Projectcode> 809 + <Projectnaam>Marwei Delfstrahuizen</Projectnaam> 810 + <Meetpuntnaam>DL07B02</Meetpuntnaam> 811 + <Monsternaam>dsa</Monsternaam> 812 + <Matrix>grond</Matrix> 813 + <Datum>2020-04-03T06:34:00+02:00</Datum> 814 + <Van>40</Van> 815 + <Tot>100</Tot> 816 + </Table> 817 + <Table> 818 + <Projectcode>M20B0026-3200</Projectcode> 819 + <Projectnaam>Marwei Delfstrahuizen</Projectnaam> 820 + <Meetpuntnaam>DL07B03</Meetpuntnaam> 821 + <Monsternaam>dsa</Monsternaam> 822 + <Matrix>grond</Matrix> 823 + <Datum>2020-04-03T06:34:00+02:00</Datum> 824 + <Van>40</Van> 825 + <Tot>100</Tot> 826 + </Table> 827 +</NewDataSet> 828 +{{/code}} 829 + 830 +(% class="box infomessage" %) 831 +((( 832 +This could be parsed directly into a C# .Net Dataset 833 +)))