I just started using Matillion to connect to Greenhouse APIs. And was wondering if you can share your experiences?
Hi @saqib,
I haven't had any experience with Greenhouse API's but I did go take a look at their documentation and it seems like a pretty straightforward API. I didn't see anything that would make me think that it would be hard to implement within Matillion. Are you have specific struggles with their API's within Matillion?
Hi @Bryan .
One issue is that Greenhouse API uses Basic Auth. Where the username is a API Token generated by Greenhouse, and the password is blank. Very very odd way to authenticate. See:
https://developers.greenhouse.io/harvest.html#authentication
The challenge is that while Matillion supports Basic Auth, the UI requires a password to be entered (enforced). Whereas for Greenhouse API call, the password should be blank.......
I was able to get around this by using a {space} character for the password, but I am not sure if that will break in the upcoming release of the Greenhouse API / Matillion.
Saqib
I see what you are saying now. Yes, it is definitely an odd authentication approach. You should still be able to achieve what they are requiring pretty easily.
The good news is that when you use the the API Query component and you set the AuthScheme to basic it will automatically Base64 encode the username and password. In your case you would only supply the username (API Token) and no password and it should just work. I believe you would have to configure it similar to this:
It looks like the API Token is static once you have gotten one from Greenhouse so you could put the API Token in a job or environment variable and then use the variable for the value on the User parameter within the Connection Options. Let me know if this doesn’t seem to work or you have some other thoughts.
Thanks @Bryan . That was very helpful.