Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

How to get matillion taskmanager using api query

Hi,

we get using default 'matillion api' profiles? or need to create any new profiles?

9 Community Answers

Matillion Agent  

Craig Rouse —

Hi Mathan,
I’m not able to understand your question.
Could you be more detailed in your question?
Thanks,
Craig


Mathan Selvaraj —

Hi Craig,

Sorry,as per- https://www.matillion.com/blog/redshift/amazon-quicksight-dashboard-matillion-jobs/

Using sample job.

Trying to run the api query component it returns some error.

I want to conform we need to change any extra in that job?

Thanks


Matillion Agent  

Kalyan Arangam —

Hi Mathan,

Please can you expand on what error you see?

Best
Kalyan


Mathan Selvaraj —

Hi Kalyan,

It returns error like

" {
"success" : false,
"msg" : "Unauthorized",
"id" : -1
}"

Thanks


Mathan Selvaraj —

and If i give authentication returns error

"<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
<link href="/resources/fonts/fonts.css" rel='stylesheet' type='text/css' />
<link type="text/css" rel="stylesheet" href="/resources/css/style.css"/>
<link rel="icon" type="image/png" href="/resources/images/favicon.png" />
<title>500 - Internal Server Error</title>
</head>
<body>

<div id="wrapper">
<div id="main_login">
<a href="http://www.matillion.com/" target="_blank"><img class="logo" src="/resources/images/logo.svg" alt=""/></a>
<h1 class="center_text login_title">500 Internal server error</h1>
<div>

<p class="center_text">Try refreshing or visiting <a href="/">the application root</a>.</p>
</div>
</div>
</div>

</body>
</html>"


Matillion Agent  

Kalyan Arangam —

Hi Mathan,

I think you have not configured credentials on the API Query component.

Please check the following article and the attached sample job.

https://redshiftsupport.matillion.com/customer/portal/articles/2720083?b_id=8915

This is more recent and should hopefully work better. Note that you need to provide some credentials under Connection Options. That’s clearly stated in the above page.

Hope that helps.

Best
Kalyan


Mathan Selvaraj —

Hi kalyan,

One last question,

We need to give any details inside the Matillion Api profile that .rsd code ?

Thanks


Matillion Agent  

Kalyan Arangam —

It should work without making any changes to the RSD itself. Usually, all it needs is credentials to access matillion.

Best
Kalyan


Mathan Selvaraj —

Thanks, Kalyan make sense.

Post Your Community Answer

To add an answer please login