CloverETL is now CloverDX - Learn Why

Pull Execution History from the http API

How-to(s), solutions to common problems, pearls of wisdom

Paulhbartosik
Posts: 11
Joined: Wed Sep 06, 2017 4:14 pm

Pull Execution History from the http API

Postby Paulhbartosik » Mon Oct 01, 2018 2:15 pm

I wanted to get a listing of the job status for the last day's activity. This is a very simple graph, but it was difficult for me to get it to work.

There were two challenges:
1. Getting the HTTP parameters correct. Remember that if you add parameters through the input mapping, you must delete them from the URL. Otherwise you get completely unhelpful error messages.

2. Reading the output in XML. You have to navigate the XML tree structure to pull the relevant data. The XML Extract can be sort of flakey.

See the attached graph. I have removed my password info.
Attachments
Execution History passwords removed.grf
(7.4 KiB) Downloaded 23 times

vazquezrosariop
Posts: 142
Joined: Mon Feb 29, 2016 5:33 pm

Re: Pull Execution History from the http API

Postby vazquezrosariop » Wed Oct 03, 2018 3:24 pm

Hi Paul,

Thank you for providing a solution to pull execution history from the http API, this will certainly help other customers that might have the same use case as yourself.
---
Pedro X. Vazquez Rosario
CloverCARE Support
CloverDX

Visit us online at http://www.cloverdx.com