How do you query task history by job name AND date range?

Matillion ETL
1

From https://docs.matillion.com/metl/docs/2972278/#get-filterby

 

you can filter by job name

```

<InstanceAddress>/rest/v1/group/name/<groupName>/project/name/<projectName>

/task/filter/by/job/name/<jobName>

```

 

you can filter by date range

```

<InstanceAddress>/rest/v1/group/name/<groupName>/project/name/<projectName>

/task/filter/by/end/range/date/<startDate>/time/<startTime>/to/date/<endDate>/time/<endTime>

```

 

but after some experimentation, I cannot figure out how to filter by both. I know it's possible since when you look at "Task HIstory" in the GUI, you get paginated results of exactly what I'm looking for.

2

Hi @jkaczynski​

Thank you for your post, I have raised this with a member of our team to find out if this can be done, I will be sure to reply back here as soon as I have an update.

If you have any further updates on your end, please do let me know.

Kind regards, Joe

3

Hello @jkaczynski​

I hope you are all well, I wanted to share what I have found out for you.

A way our team think this could be achieved would be by leveraging the Metadata API (Documentation here)

This has execution information, with start and end times in the parameters. You can also filter by jobType.

I hope this helps, please do let me know.

Kind regards, Joe