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