<
From version < 3.4 >
edited by Roelof Zwaan
on 2021/11/22 11:24
To version < 3.1 >
edited by Roelof Zwaan
on 2021/11/22 11:07
>
Change comment: Uploaded new attachment "1637575660334-733.png", version {1}

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,0 @@
1 -Setting up a Webservice connection to get Overview data from TerraIndex
Parent
... ... @@ -1,1 +1,0 @@
1 -Implementatie dcoumentatie.WebHome
Content
... ... @@ -1,833 +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>>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 -)))
TerraIndex
asd