Include body params in Post API call in Matillion

Matillion ETL
1

Hi Team,

 

I have a similar scenario mentioned here :https://documentation.matillion.com/docs/2877639.

 

The difference is when I am making a POST call using API query component' , I am putting api_key in 'CustomHeaders' properties but I have one more parameter as 'secret' which I am not sure where to place.

 

When I make a curl request , I put this secret parameter under '-d secret:somevalue and it works fine.

 

I was able to establish the connection when I put this secret key in POST request body using Matillion while creating new rsd for eg:

{ "secret" : "some_value"}

 

Does anyone have any idea where to Put request body params in 'connection options' of API query component in Matillion

 

Kindly suggest.

 

Thanks,

Shivani

2

Has there been an update on this. I need to write a new API Query Profile that makes a POST request and the body needs to be a job variable. Documentation is rather poor when it comes to POST request using an API Query Profile. Please help

3

Hello All

 

The body needs to be defined when building the Query Profile.

 

Shivani, it looks like you are trying to create an authentication flow and this should rather be defined in Authentication in the Query Profile wizard. If this isn't possible, additional custom headers can be added by just adding another "CustomHeader" connection option, or (if it is a query parameter) use the "Other" connection option.

 

gparra, the Query Profile sits at the project level, and so a Job Variable can't be used with API Query. You should be able to use an Environment Variable (if I'm not mistaken), by ensuring the variable is defined first, with a default, and then is inputted using the variable syntax (i.e. ${...}).

 

Hope that helps.

Regards

Ben Smiles

4

the body of my POST request needs to look like this

username={0}&password={1}&command={2}&claimKey={3}&submit={4}

where username, password, command and claimKey are all job variables. I haven't had any success setting this up.

5

Hello gparra

 

Could you share what API you are trying to query? Alternatively, could you share what format the API is expecting the body to be in? Also, the correct variable syntax is username=${0}&password=${1}&command=${2}&claimKey=${3}&submit=${4} otherwise it will just be parsed as standard JSON.

 

Regards

Ben Smiles

6

API Query Profile

 

7

Hello gparra

 

I meant what API you are trying to access using API Query, so I could look up the documentation.

 

Regards

Ben Smiles

8

Im not trying to user Matillion API. I'm trying to set up an API Query Profile

 

9

I meant, what source system of you trying to connect to using an API Query Profile?