I'm reading from an API with an iterator.
The iterator passes a "job id" into the API Query module. The API Query module should append this "job id" to the URI.
For example, here is the URI from the API Query (advanced mode):
<api:set attr="uri" value="https://[somevalue]/api/v1.0/companies/[_connection.companyID]/jobs/[_connection.jobID]" />
And here are the API Query "Connection Options":
“Accept” and “companyID” parameters seem to work ok (they are hard-coded values), however the “jobID” parameter doesn’t like the reference to a job parameter (${v_jobID})
How do I pass the value from the iterator into the API URI?
If there is somewhere (anywhere) in the Matillion documentation that fully discusses the API parameters please let me know. I find the Matillion documentation to be seriously lacking in content.
Thank you.
Dear Matillion - I edited out the actual API string but you have captured that and included it in my post. Why?
Ok I might have figured out my own problem. I need a semi-colon followed by [space] between the values. That's all I could see that I changed and my half day journey of frustration is over! :)
Also, thank you @JoeCommunityManager for fixing up my post! Would be great if we could somehow edit our own posts? Cheers!
Hi SB699925
Thank you for flagging this, I can see you have edited out the information you mention but the link preview has remained, I have now removed this, if this happens again in the future just click the small "X" next to the link preview at the bottom of your post and it will be removed, editing the text of the URL will not.
If you need anything else please do not hesitate to ask.
Kind regards, Joe
