I new to API and I am getting below error while running the API query component: Parameter Validation Failure: The value of the attribute could not be accessed: The attribute does not exist. I can successfully create the API query profile

Matillion ETL
21

The guidance you provided:

"You get the Parameter details in the rsd file in config tab.

 You need to add the same details in the API Component, in the Connection Options"

 

Has been super helpful, I could not find anything related to that in the documentation and this is the least intuitive setting ever...

and to top it off, you can not even copy the long string found under Parameter/Other...

 

Been really suffering, I wish I could just upload a Postman script and be done with it...

22

Hello Team , I am new to API . I am using Matillion API component.

Requirement : I have a table with asset_ids. I want to fetch all the data from the API for each asset_id . I need to do a initial(INIT) load and then a INCREMENTAL daily load.
API query param are asset_id , start_time , end_time

Problem : When I am hard-coding the param values in the API Query Profile it is working fine.
I am trying to parameterize them like below

<api:set attr=“paramname#1” value=“startTime” />
<api:set attr=“paramvalue#1” value=“[_connection.startTime]” />
<api:set attr=“paramname#2” value=“endTime” />
<api:set attr=“paramvalue#2” value=“[_connection.endTime]” />
<api:set attr=“paramname#3” value=“assetIds” />
<api:set attr=“paramvalue#3” value=“[_connection.assetIds]” />

<api:set attr=“DataModel” value=“DOCUMENT” />
<api:set attr=“EnablePaging” value=“TRUE” />
<api:set attr=“RepeatElement” value=“/json” />

<api:set attr=“elementmappath#” value=“/json/pagination/endCursor” />
<api:set attr=“elementmapname#” value=“rows@next” />
<api:check attr=“_input.rows@next”>
<api:set attr=“uri” value=“https://api.XXXX.com/intervals/stream?startTime=[_connection.startTime]&endTime=[_connection.endTime]&assetIds=[_connection.assetIds]&after=[_input.rows@next]” />
api:else
<api:set attr=“uri” value=“https://api.XXXX.com/intervals/stream?startTime=[_connection.startTime]&endTime=[_connection.endTime]&assetIds=[_connection.assetIds]&after=[_input.rows@next]” />

PS: I have added API Query component in my JOB like below
Other startMs=${V_JOB_START_TIME};endMs=${V_JOB_END_TIME}

And have set some JOB level value for V_JOB_START_TIME and V_JOB_END_TIME
And ASSET_ID is coming from a table iterator on Table ASSET

Issue : MAtilloin Job is failing while running it is saying not able to find [end_time]

I am stuck and no way to proceed without it. Please help /respond