First one question: you're talking about web service APIs by means of REST web services, right?
If so, then you're stuck between a rock and a hard place. PowerCenter does NOT have a built-in ability to parse JSON. Sometimes you can use an Expression transformation in order to parse JSON content, but - as far as I can tell from posts on this forum in the past - most customers use a Java transformation (JTX) to parse the JSON output and split it up into individual ports. Often they even perform the web service call and split the JSON response within the same JTX.
From this point of view it is clear that the mapping cannot be translated from the Developer world (i.e. Informatica platform, including applications like IDQ = Informatica Data Quality) to PowerCenter. In PowerCenter you have to replace the REST web service consumer by something else (as mentioned above, probably a JTX).
You may want to move this question to the Informatica Platform forum; it might be that there you will find people who can give more educated answers than I can.
Also you can find several threads about parsing JSON content within the PowerCenter forum, just search.
You may also want to look at exporting a DQ mapplet. If you are able to wrap the needed transformations in a mapplet you can export that to PowerCenter. Now how this is different is that Informatica creates a C code wrapper around the mapplet that allows PowerCenter to call a DQ mapplet containing DQ transforms. It becomes a blackbox to pwoercenter where you cant edit the mapplet but you can call it. Any changes you make in the developer tool and re-import.
Standard practice for customers wanting to use DQ inside PwC.
if we use informatica developer using rest consumer to get response in JSON by giving API URL and then using data processor to do so, we are not able to export the mapping as we need to use that mapping in our designer.
while exporting ,getting an error that we need to remove rest consumer. Can you suggest a possible way for it?
There is no way. Power enter does not support REST and even more so the web consumer in developer. That mapping has to stay there or you need to change to a mapplet
Can you tell me the way in which we can convert that mapping having web consumer and data processor into a mapplet?
I am using informatica developer tool to convert JSON to relational using data processor. My json file size in KB. When i am running data viewer in data processor i am not getting return records. I can see in source that data has been read. Can anyone please help me with the solution? is it because many key and values in json file?
It's not a good idea to post this question in this thread. The thread was about "copying" a mapping from the Developer to the Designer, and your new question is a technical question.
Please open a new thread for this new question. This makes it easier to keep separate issues separate and to get more attention from the right people to each of these issues.
B2B DT forum may get you an answer. Let me provide a certain information, which may be useful.
Instead of exporting to PowerCenter(PC) why can't this developer mapping can be invoked via DT transformation from PC with certain changes.
1. PC can be used to fetch the JSON and pass on the file to DT transformation.
2. Since the mapping in Developer does the conversion of JSON to relational, instead of relational a file target (Serializer) can be set and pass on the output to PC and connect to relational.
I'm not sure, but you can poke around.
interesting suggestion. What license options are needed to follow this approach? That would be good to know.
Thanks and regards,
Nico, to my knowledge this requires UDT (Unstructured Data Transformation) licence during 9.x period. Hope, that remains the same in current 10.x too. There were lot of changes especially to UDT during 9.x to 10.x upgrade.