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

Matillion API unauthorized response JSON

Hi,

Recently I started working on Matillion API and these are the main articles currently I'm referring to.

1) https://redshiftsupport.matillion.com/customer/en/portal/articles/2531801-matillion-etl-api-?b_id=8915

2)https://redshiftsupport.matillion.com/customer/en/portal/articles/2565073-api-examples?b_id=8915

I use this (http://onlinecurl.com/) online curl requests submitting tool to test the curl requests mentioned in the article.

But I always ended up getting this error JSON response.

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

I tried changing security group in bounds of aws ec2 instance of my matillion account. But no luck! It would be great if someone can help me. Thank you!

2 Community Answers

Matillion Agent  

Laura Malins —

Hi Thedath

Can you SSH onto your Matillion EC2 instance? If so, can you try the Curl command via the command line there please?

Are you passing through a username and password using the format:
curl -u username:password -X GET -H “Content-Type:application/json” “http://52.215.67.111/rest/v0/projects?groupName=MyGroup&projectName=Project”

The user will need to be an API user in Matillion. This can be checked in the Matillion Admin Console.

Thanks
Laura


Thedath Oudarya —

Hi Laura,

I haven't included username and password in the cURL request. Now I get a valid results. Thanks for reaching out to me. :)

Post Your Community Answer

To add an answer please login