HTTP protocol error. 401. - when running <API QUERY> matillion component

Matillion ETL
1

Hello. I am trying to use <API QUERY> Matillion component.

I use the settings like: 1) Profile field: "Matillion API" 2) Data Source field: "Run Historical Details"  3) Other required fields are set as well.

Result of running this component is: HTTP protocol error. 401.

 

When I choose Profile field: "Sample", I am able to load the data in the table.

 

Please let me know what could be a problem?

2

Hi AGosp,

 

A 401 error means unauthorized, so you mabye have not put a username and password?

 

On my system I have to remember to set

 

  • Authentication Method = User/Password (it defaults to 'Other')
  • Username = A Matillion user which has been granted API privilege (more info in this doc)
  • Password = the user's password

 

For me sample never works without the above.

 

BR

3

Thank you @deBaris​

I set the username and password and the issue was solved!

Best Regards, Alex