Wiki source code of Setting up a Webservice connection to get Overview data from TerraIndex
Version 3.4 by Roelof Zwaan on 2021/11/22 11:24
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 | == 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 | ))) |