Last modified by Olivier Roussel on 2025/04/25 09:57
Change comment:
Uploaded new attachment "1637575660334-733.png", version {1}
Summary
-
Page properties (3 modified, 0 added, 0 removed)
Details
- Page properties
-
- Title
-
... ... @@ -1,1 +1,0 @@ 1 -Setting up a Webservice connection to get Overview data from TerraIndex - Parent
-
... ... @@ -1,1 +1,0 @@ 1 -Implementatie dcoumentatie.Documentation TerraIndex Export format - dsFieldProject\.xsd.WebHome - Content
-
... ... @@ -1,833 +1,0 @@ 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 -)))