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