Last modified by Olivier Roussel on 2025/04/25 09:57
<
From version < 5.3 >
edited by Robert Jan Daams
on 2022/08/23 11:17
To version < 3.1 >
edited by Roelof Zwaan
on 2021/11/22 11:07
>
Change comment: Uploaded new attachment "1637575660334-733.png", version {1}

Summary

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

Navigation

TerraIndex
asd