Last modified by Olivier Roussel on 2025/04/25 09:57
From version 1.1 >
edited by Roelof Zwaan
on 2021/11/22 10:47
To version < 5.3 >
edited by Robert Jan Daams
on 2022/08/23 11:17
>
Change comment: There is no comment for this version

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
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.RoelofZwaan
1 +XWiki.RjDaams
Content
... ... @@ -1,0 +1,850 @@
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 +)))
1637574900554-168.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.RoelofZwaan
Size
... ... @@ -1,0 +1,1 @@
1 +147.3 KB
Content
1637575660334-733.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.RoelofZwaan
Size
... ... @@ -1,0 +1,1 @@
1 +151.9 KB
Content

Navigation

TerraIndex
asd