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