Alex Bitz

How to connect to REST Client API via PDI

Discussion created by Alex Bitz on Feb 7, 2018
Latest reply on Jun 20, 2018 by Brandon Jackson

Hello, I'm not sure if this is the right place for this I am trying to connect to a Rest API through Pentaho Data Integration. Using API Tester I can connect and get a proper response body quite easily so I know it works, but I can't for the life of me get it to work in Pentaho. I keep getting a "Error finding field [Authorization] in incoming stream" error.

 

In step 1, I generate a URL row with the proper URL that I need as a string.

 

In step 2, I use that URL field name within the REST Client.

 

Below are screenshots of how I have that setup. I need to pass in my Authorization API Token and I am putting it in the Headers section, where it should be, but it doesn't seem to like it there obviously. How do I get this to work where I can successfully pass my headers of "Authorization" and "Accept" and their values into the request header so this works? Do I need to pass them in the URL? If so, how do I do that (what is the format of that?)? I am using an HTTP Method of "GET" so I can't use any parameters.

 

Thanks for any and all help!!!

 

 

 

 

 

 

-Alex

Outcomes