Just to be clear, REST web services are not supported by Web service consumer transformation. You need to use HTTP transformation.
Informatica developer tool 9.6.0 (not the PC designer) has a REST web service consumer transformation. I am using this transformation within the mapping of Informatica developer tool.
I tried HTTP transformation within PC mapping and it worked. But this has its limitation. Our requirement is to change the base URL or rather change the end point of the URL dynamically for each incoming row from relational table. HTTP transformation does not support dynamically changing of URL.
That is why I am exploring the use of Informatica developer tool. If all goes well, we will change the physical target to a logical target and deploy the mapping as an application service on Informatica web service hub. Consume this application service from a mapping within PC.
On a side note.. If you are the same Ravi Dua from UK then, Do you remember me? We worked together at Maersk.
Thanks Harish, I do remember you. Nice interacting with you again.
You can make HTTP transformation dynamic by passing $$URL as a parameter in the transformation.I would have gone for a Java Transformation which will be a clean approach even though it will take a bit of effort and time.
I tried HTTP transformation within PC mapping. Declaring a mapping parameter and using it as the base URL may not work for us as the parameter file is read once prior to execution of its session. Our requirement is to change or construct the base URL for each incoming row from a relational table. Pass this derived URL to HTTP transformation and capture the received xml response either as files or load target relational tables.
We tried using a mapping level variable and using setvariable() to change its value for each row. However, the HTTP transformation does not substitute the value of $$URL. We even opened a Informatica help desk ticket regarding the HTTP transformation. As per them .. HTTP transformation does not support dynamic changing of base URL.
I could explore the JAVA transformation but am not an expert at JAVA.
I am also having the same requirement calling REST Web service using java transformation , i have tried with the HTTP transformation and it has lot of issues like dynamic URL and looping for input, can anybody give a sample code where i can pass URL from relational table and able to modify the same URL using the loop concept inside java transformation like for loop etc
I have the same requirement . Is there any solution available using informatica developer version 10?
I defined a rest consumer and used a mapping parameter to be passed to the argument port. It is working when passing one value of the parameter to the rest web service.
The goal is to pass different values dynamically to the rest consumer and get back responses based on the argument values.