0:00:01.509,0:00:05.750
Hi this is Tom from Coherent Logic and
today i'm going to give you a quick

0:00:05.750,0:00:09.590
demonstration of how to build a query
using the new Coherent Logic query

0:00:09.590,0:00:16.550
builder for the Quandl web services API.
So we have here an integration test

0:00:16.550,0:00:20.240
where behind the scenes we have the
Spring Framework already configured.

0:00:20.240,0:00:25.400
We're going to use the application
context to get an instance of the query

0:00:25.400,0:00:33.109
builder and if you take a look at the
URL here what we did in Firefox was we

0:00:33.109,0:00:38.839
executed that URL (we redacted the API
key) but this is what the response looks

0:00:38.839,0:00:44.659
like. This is what Quandl will return to
you and we need to transform this into

0:00:44.659,0:00:49.850
an object model and our object model is
already determined, all we need to do is

0:00:49.850,0:00:56.409
build up the query and execute it. And
let's try to do that now. So we need a

0:00:56.409,0:01:09.770
Quandl response we'll call that 'result', we
use the query builder and we'll call

0:01:09.770,0:01:25.630
data sets and we're going to pass it EOD
and HD so you use EOD and the code is HD.

0:01:25.630,0:01:32.570
Okay so that takes us up to here. The
next thing we need to do is call the dot

0:01:32.570,0:01:44.299
data method that will give us this and
then finally we will set the API key and

0:01:44.299,0:01:50.929
that's already being loaded in the setup
for this integration test. Then

0:01:50.929,0:01:58.909
finally we're going to do get a Quandl
response and that's it.

0:01:58.909,0:02:06.729
So that will give us a Quandl response
and then all we'll do is print it out.

0:02:07.890,0:02:15.180
There we go so there's a single result
from the Quandl web services. I

0:02:15.180,0:02:22.239
converted this into an instance of the
Coherent Logic Quandl Client API domain

0:02:22.239,0:02:28.569
model and we can scroll over and see
some of the data. So that's it and thank

0:02:28.569,0:02:31.209
you for your time if you have any
questions leave them below and I'll get

0:02:31.209,0:02:34.959
you an answer. Last but not least if
you like this video please give it a

0:02:34.959,0:02:38.580
thumbs up it's always appreciated.