I want to get task history for specific period in time. For that, I need to use variable for start_date and end_date, but I did not find any document on how to do this.
Below is the GET Call:
http://<InstanceAddress>/rest/v1/group/name/<groupName>/project/name/<projectName>/task/filter/by/end/range/date/<startDate>/time/<startTime>/to/date/<endDate>/time/<endTime>
I want to parameterised highlighted part of the call? Can anyone please help with this?
@NeelamMacwan - If I understand correctly, you are trying to invoke the Matillion API from within a METL job using the API Query component.
In that case you can use "Connection" or "Input" parameters that can be passed through this component. Find instructions below.
https://docs.matillion.com/metl/docs/1734928/#overview
And then edit your API Query RSD XML (by going to Advanced mode) file to use them as
<api:set attr="uri" value="http://<InstanceAddress>/rest/v1/group/name/<groupName>/project/name/<projectName>/task/filter/by/end/range/date/[_connection.start_time]/time/<startTime>/to/date/<endDate>/time/[_connection.end_time]" />
Hope this helps.
Thank you so much, ramalingam.
This worked