<
From version < 3.1 >
edited by Roelof Zwaan
on 2021/11/22 11:07
To version < 5.2 >
edited by Roelof Zwaan
on 2021/11/23 11:40
>
Change comment: Update document after refactoring.

Summary

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 +)))
TerraIndex
asd