Last modified by Olivier Roussel on 2025/04/25 09:57
Change comment:
Uploaded new attachment "1637574900554-168.png", version {1}
Summary
-
Page properties (3 modified, 0 added, 0 removed)
-
Attachments (0 modified, 0 added, 1 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 -Implementation documentation.WebHome - Content
-
... ... @@ -1,831 +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>>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,1 +1,0 @@ 1 -XWiki.RoelofZwaan - Size
-
... ... @@ -1,1 +1,0 @@ 1 -151.9 KB - Content