Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Creating API profiles within Matillion

I am using _input. and using api key as environment variable to pass in uri tag of API profile xsd

but inside advanced mode sql query part of (API profile query) component , i am receiving below mentioned error

( query . , select * from xsd table where authentication1 = '${api_key}'
and authentication2 = '${Secret_key}'

error :
Formatter [ authentication3 ] failed in the evaluation of https://restapi.surveygizmo.com/v5/survey/4918313/surveyresponse?[_input.authentication3]&[_input.authentication1]. The error was:
The value of the attribute could not be accessed: The attribute does not exist.

Any ideas?

Thanks
Sanket Zambre

3 Community Answers

sanket zambre —

error :
Formatter [ authentication1 ] failed in the evaluation of https://restapi.surveygizmo.com/v5/survey/4918313/surveyresponse?[_input.authentication1]&[_input.authentication2]. The error was:
The value of the attribute could not be accessed: The attribute does not exist.


Paul D'Angelo —

Did you happen to find a solution sanket?


Matillion Agent  

Arawan Gajajiva —

Hi Paul -

I can’t speak for Sanket’s particular issue as he marked this issue resolved on his own. However, one thing to mention is that you can pass in the values of Input Parameters while using Basic Mode in the API Query component. To do so, you need to add the following Connection Option in the API Query component configuration:

  • Parameter = PseudoColumns
  • Value = *=*

Once you have defined the above Connection Option, you will find that any Input Parameters defined in the RSD you are referencing will be available in the Data Source Filter property. You can then assign a value to the Input Parameters in this way.

If this isn’t what you are looking for, please let us know the details of the issue you are facing.

Thanks!
Arawan

Post Your Community Answer

To add an answer please login