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

Creating API profiles within Matillion

hii
i have 1 additional question

Is it possible to write like for loop condition in xsd file ?

ex. i have restAPI url in which I have to pass certain id for retieving data from different menus
(www.restapi.com/A/response)
(www.restapi.com/B/response)
A and B are fixed id numbers to pass to access certain menu
( example A =. 12 , B = 25 )

i need to retrieve response from above both , 1 after the other without writing 2 different xsd files ( 1 for each url)
instead how can i pass these different values in URl at once in a loop so that i can retrieve data from both URLs 1 after the other?

Thanks
Sanket Zambre

1 Community Answers

Matillion Agent  

David Lipowitz —

Hi Sanket,

Thanks for the question. Yes, the behavior you describe is possible and here’s a link describing Using Parameters With API Profiles

I’d suggest parameterizing the URI you’re querying such that you can replace the A or B portion with the desired value. Then you can pass the value you want from, for example, a Fixed Iterator.

Please give that a try and let us know if you need any additional support.

Best Regards,
Dave

Post Your Community Answer

To add an answer please login