# Retrieve information vom Graph Tracking (CloverETL-Server) **URL:** \ **Category:** CloverDX Platform\ **Created:** [March 17, 2014, 12:00am UTC](https://forum.cloverdx.com/t/retrieve-information-vom-graph-tracking-cloveretl-server/1368 "2014-03-17T00:00:00Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![svogel](https://avatars.discourse-cdn.com/v4/letter/s/96bed5/32.png) [@svogel](https://forum.cloverdx.com/u/svogel)\ **Post date:** [March 17, 2014, 12:00am UTC](https://forum.cloverdx.com/t/retrieve-information-vom-graph-tracking-cloveretl-server/1368/1 "2014-03-17T00:00:00Z")
Hi community, I’d like to make a report about the number of records read from the database, the number of records filtered in a specific filter-component. Now I see, that this information is already there: on the cloveretl-server there is (Execution \> History, select a Job and “Tracking”-Tab). Can I access the tracking-information somehow (especially the Records for Input/Output of specific components)? Where is this data stored? Thanks a lot for any hint. ---
**Author:** ![David\_Hlidek](https://avatars.discourse-cdn.com/v4/letter/d/58f4c7/32.png) [@David\_Hlidek](https://forum.cloverdx.com/u/David_Hlidek)\ **Post date:** [March 17, 2014, 1:37pm UTC](https://forum.cloverdx.com/t/retrieve-information-vom-graph-tracking-cloveretl-server/1368/2 "2014-03-17T13:37:18Z")
Hi Stefan, You have several way how to extract this information: \* tracking information of executed graph is available in output mapping of ExecuteGraph ([http://doc.cloveretl.com/documentation/ … graph.html](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/executegraph.html)) available in JobFlows of CloverETL Server Corporate+ from version 3.3 \* use SimpleHTTP API ([http://doc.cloveretl.com/documentation/ … p-api.html](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.server.docs/docs/simple-http-api.html)) or SOAP WS API ([http://doc.cloveretl.com/documentation/ … ap-ws.html](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.server.docs/docs/soap-ws.html)) to download tracking info from Server \* calculate tracking info within graph using Aggregate ([http://doc.cloveretl.com/documentation/ … egate.html](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/aggregate.html)) and store it somewhere (XML, DB, …) I hope this helps. ---
**Author:** ![svogel](https://avatars.discourse-cdn.com/v4/letter/s/96bed5/32.png) [@svogel](https://forum.cloverdx.com/u/svogel)\ **Post date:** [March 17, 2014, 3:00pm UTC](https://forum.cloverdx.com/t/retrieve-information-vom-graph-tracking-cloveretl-server/1368/3 "2014-03-17T15:00:10Z")
Hi Jaroslav, thanks for the quick response. That sounds really great. I especially like getting the data via the HTTP Connector as |-separated values. But now I got another issue that got me stuck. I get the complete HTML-body as “content” from the HTTP Connector, I’d like to have the lines as separate records. How I can I split the “one” line HTML-body (at character “\n”) to obtain several rows of data (which I can split with character | to obtain the separate fields) Thanks a lot in advance and kind regards ---
**Author:** ![svogel](https://avatars.discourse-cdn.com/v4/letter/s/96bed5/32.png) [@svogel](https://forum.cloverdx.com/u/svogel)\ **Post date:** [March 18, 2014, 7:01am UTC](https://forum.cloverdx.com/t/retrieve-information-vom-graph-tracking-cloveretl-server/1368/4 "2014-03-18T07:01:08Z")
Hi Jaroslav, thanks for the quick reply. That sounds awesome. I really like the possibility to query this information via http But now I got stock with the next thing. I’m reading the |-separated report from [http://…/clover/request\_processor/exe … ESCRIPTION](http://.../clover/request%5Fprocessor/executions%5Fhistory?returnType=DESCRIPTION) … I get the complete HTML-body in “content”, now I want to work through the lines of this report (filtering some information). But how can I split the content by “\n”? I searched through the components but found no adequate. And furthermore, if I got the complete body/content splitted in lines, how can I work with this format (as it has a different number of columns, based on the “keyword” in the first row). Is there something easy to use or do I have to program a few lines of code in CTL? ---
**Author:** ![imriskal](https://avatars.discourse-cdn.com/v4/letter/i/b38774/32.png) [@imriskal](https://forum.cloverdx.com/u/imriskal)\ **Post date:** [March 18, 2014, 3:09pm UTC](https://forum.cloverdx.com/t/retrieve-information-vom-graph-tracking-cloveretl-server/1368/5 "2014-03-18T15:09:55Z")
Hello Stefan, I recommend you using parameter returnType=DESCRIPTION\_XML. You do not have to split anything whis way, everything is served in a form of XML to you. And if you want, you can extract just the data you are interested in using XMLExtract component after the HTTPConnector. Regards, ---
**Author:** ![David\_Hlidek](https://avatars.discourse-cdn.com/v4/letter/d/58f4c7/32.png) [@David\_Hlidek](https://forum.cloverdx.com/u/David_Hlidek)\ **Post date:** [March 18, 2014, 3:17pm UTC](https://forum.cloverdx.com/t/retrieve-information-vom-graph-tracking-cloveretl-server/1368/6 "2014-03-18T15:17:44Z")
Hi Stefan, I would suggest Lubos’s way, but to make answer complete: For parsing non-heterogenous data you can use [http://doc.cloveretl.com/documentation/ … eader.html](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/complexdatareader.html) In this case you will get each of separate record types on separate output, each having own metadata. Records may be linked through id. Configuration of ComplextDataReader is not really straight-forward so this way may be hard. I hope this helps. ---
**Author:** ![svogel](https://avatars.discourse-cdn.com/v4/letter/s/96bed5/32.png) [@svogel](https://forum.cloverdx.com/u/svogel)\ **Post date:** [March 18, 2014, 10:03pm UTC](https://forum.cloverdx.com/t/retrieve-information-vom-graph-tracking-cloveretl-server/1368/7 "2014-03-18T22:03:53Z")
Hi guys, thanks a lot. You are really helpful. I didn’t know of the ComplexDataReader … good to know. And well ok, I will try to use the XML, but to be honest, I always try to avoid this Xslt-thing: I’ll have a look. Thanks for your help.