Is it possible to use Grid Variable for Connection Option in API Query?

Matillion ETL
1

Has there been anyone who is able to use Grid Variable to Iterate the URI parameter?

 

When setting it up originally, it requires to add the parameter = Value (shown below)

 

0694G00000J5gX0QAJ_0D54G00008DaG1QSAV
0694G00000J5gX0QAJ_0D54G00008DaG1QSAV991×119 3.69 KB

But when the grid variables are used, it produces an error because the value in the URI Connection is just the value (ex. 100000 instead of event_id=100000)

How can I add the parameter to the grid variable value to make this work?

 

0694G00000J5gWlQAJ_0D54G00008DaG1QSAV

 

Thanks,

Ryan

2

Hi Ryan,

 

I am not sure if this is the answer but you need to provide connection details in the 'Connection Options' like API key value. Please check the screenshot for this:

And the details should be passed in the API Query Component also. The value of grid variable should be passed when you declared it.

Hope this works for you.

0694G00000J5iUwQAJ_0D74G000007kZheSAE

 

Thanks,

Neelam

3

This is really helpful.

I've been able to make it work by leveraging the advanced settings and using the variable in the SQL query.

 

Thank you so much for the help!

4

Hey @ryan​ any chance you could share some pseudo-code for your solution? I'm also trying to get a job variable passed into the URI but no luck so far... cheers!