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