In Matillion, We have a TASK HISTORY which is really having detailed data. Is there any way I can use those data and trigger an email? like failure jobs task history or some specific job task history. Curious to know. Any suggestions, please

Matillion ETL
1

In Matillion, We have a TASK HISTORY which is really having detailed data. Is there any way I can use those data and trigger an email? like failure jobs task history or some specific job task history.

Curious to know. Any suggestions, please.

2

I have tried with Matillion API , but getting Invalid HTTP response! System error: Connection refused (Connection refused) error.

3

API Query is the right way. This link provides details(https://documentation.matillion.com/docs/2949006) . But at some other place it is mentioned that Task History is a Enterprise Feature(https://matillioncommunity.discourse.group/t/can-i-access-a-history-of-tasks/1144) . What kind of instance do you have?

4

I could do it today successfully. Used a API Extract Profile to connect to Task API, and could get the data . Added couple more components to get the data into a table in Snowflake. LEt me know if you want a walk through.

5

Yes it will be more helpful :)

6

Using Task History API is the best way to capture all Task History related information. We built a utility to ingest Task History information into Snowflake in a scheduled manner. Happy to help.

7

Thanks , i am able to fetch the task history through API Query component , but for that i need to change the setting in ADMIN -> SSL as Both(80/443) , currently we have only 443 port , changing this to BOTH will create any impact? i know 80 will allow http but not sure about the exact impact in enabling BOTH . With 443 its throwing invalid HTTP request error. Any idea?