Hello Gopi,

Couple of confusions here. Are you using ICRT or ICS. It is not possible in ICRT to write the data into CSV. Because these are API's and the output will be in XML/JSON format only.

In ICS it is definitely possible. Create a Business service connector and call the same in mapping by using webservice transformation. Create a flat file connection and define a CSV file with the required structure. Pull that target into the mapping and link the webservice transformation to this target. While linking it will ask for "choose the object". Choose the correct object (Not fault group) and map the columns.

Try this and post the exact error if this is not working.

-Mahesh

First of all, in your service connector you'll need to create a process object which corresponds to the structure of the JSON you're getting back, so in you're case it would have the following fields:

• address
• city
• country
• email

Then you'll need to define an output property for your service connector action, which is of type Object List > {name of the object you created above}.

Then in your action output you'll need to use an xquery expression to parse the XML which Service Connector produces after receiving JSON.

then you'll need to loop through the objects and return an instance of PO for each record in JSON e.g:

for $element in //

return

<object>

   <address>{$element/address/data()}</address>

   ...

</object>

Could you try

for $element in /root

return

<catop>

   <email>{$element/email/data()}</email>

   <addr>

      <city>{$element/address/city/data()}</city>

      <country>{$element/address/country/data()}</country>

   </addr>

</catop>

or  for $element in /root/* or just /*

and make sure that Type is set to 'Xquery'

Gopinath,

Please see the attached artifacts.  This is a sample that consumes a JSON payload and outputs to a CSV.

InformaticaCommunity-connection-250888: This is a File connection with 1 Event Target configured.  You will run this on a local secure agent.  You will want to update the Directory to your desired location.  I have the delimiter set to |.

InformaticaCommunity-connection-250888:  This is the process that will consume the JSON (I just used POSTMAN in this example).  1 Assignment step and 1 Service Call. 

JSON input -

{
"input": {
"address": [
{
"city": "Kerrville",
"country": "US",
"email": "xyz@abc.net"
},
{
"city": "Kerrville",
"country": "US",
"email": "abcd@123.net"
}
]
}
}

CSV produced -

city|country|email
Kerrville|US|xyz@abc.net
Kerrville|US|abcd@123.net

Hope this helps!

Rich

Hi,

No problem.

To write it out to the flat file, you might need to flatten the object, so that it only has one 'level' of properties.

e.g. like that:

<catop>

    <email>muuurph@sbcglobal.net</email>

    <addrcity>Kerrville</addrcity>

    <addrcountry>US</addrcountry>

</catop>

as in my experience the delimited content writer omits the child nodes when creating the CSV.

for writing out the objects to CSV have a look at this thread ICRT Sample - Reading and Writing - XML to Delimited CSV or JSON and Vice Versa.

Gopinath,

Sorry about that, try out these changes.

Change on the Assignment step of the process.

Update this assignment DelimitedContentSerializationTask>Custom objects

With this Formula-

for $catop in $input.input
return
                <root>
                    <email>{$catop/email/text()}</email>
                    <city>{$catop/addr/city/text()}</city>
                    <country>{$catop/addr/country/text()}</country>
                </root>

Update this assignment DelimitedContentSerializationTask>Custom headers

(
<header>
<fieldIndex>1</fieldIndex>
    <name>email</name>
</header>,
<header>
<fieldIndex>2</fieldIndex>
    <name>city</name>
</header>,
<header>
<fieldIndex>3</fieldIndex>
    <name>country</name>
</header>
)

Updated Input to use in your request -

{
"input": [
{
"email": "bb@hy.net",
"addr": {
"city": "NewYork",
"country": "US"
}
},
{
"email": "sr@abd.com",
"addr": {
"city": "SanDiego",
"country": "US"
}
}
]
}

You should get your desired results in the CSV.

Thank you,

Rich

Try changing your customObjects formula -

for $catop in $output.allop/catop