Version 5.3 by Robert Jan Daams on 2022/08/23 11:17
Hide last authors
Roelof Zwaan 3.2 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
Robert Jan Daams 5.3 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
Roelof Zwaan 3.2 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
Robert Jan Daams 5.3 34 [[https:~~/~~/web.terraindex.com/DataWSExternals/ITWViewServiceASMX_V1_0.asmx>>https://web.terraindex.com/DataWSExternals/ITWViewServiceASMX_V1_0.asmx]]
35
Roelof Zwaan 3.2 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
Robert Jan Daams 5.3 43 [[https:~~/~~/web.terraindex.com/DataWSExternals/ITWViewServiceASMX_V1_0.asmx?wsdl>>https://web.terraindex.com/DataWSExternals/ITWViewServiceASMX_V1_0.asmx?wsdl]]
44
Roelof Zwaan 3.2 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.
Roelof Zwaan 4.1 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.
Roelof Zwaan 3.2 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 (((
Roelof Zwaan 4.1 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]]
Roelof Zwaan 3.2 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 (((
Roelof Zwaan 4.1 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]]
Roelof Zwaan 3.2 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 )))

Navigation

TerraIndex
asd