Convert Json to CSV with space

[Anonymous]

Hi,

I have a json payload with 50 fields. I need to convert the same and upload to an endpoint.

The twist is the field names have space between them. e.g First Name.

I am using tExtracJson and tFileOutputdelimited. This component doesnt accept space.

Can someone suggest how to resolve this issue without having to replace the space with no space or underscore.

Thanks

[manodwhb]

do you have Json file,which you wan tot convert right? first try to create for metedata for Json file,when you try to create metadata it will replace space with '_',please below screenshot for your information.

[Anonymous]

Hi,

I dont want to replace space with underscore. I want the Field name as is with space. Json has it with space and my target also has it with space.

So I need a csv file with space in field name

[manodwhb]

if you are getting from database,first create a metedata for the Json format and call the metadata in tExtractJsonfield of schema.

[manodwhb]

In Talend will not allow you with space,!,@,#,$,%,^,&,*,(,),- ,+ and = column names.

[Anonymous]

Hmm..any other way? 

This is my scenario:

I get a json file with data. I need to convert to csv. I need to map the fields to a survey. The survey fields has space. so i must have space between fields in csv too.

Can I create a metadat with space

[manodwhb]

you need to change the space to _as i mention in sceenshot.

[Anonymous]

But when I map the field, it errors our right?

[manodwhb]

correct,so thats why first you need to create a metadata ,while creating metadata it will convert space with '_' so you can use the same metadata.

[Anonymous]

This is exactly what I am telling. The space is getting converted to _ . But the field that I must map to does not have _ . So how do I do it?

I am using tHttpRequest to send the data. The output schema must have field name with space. But I am not able to give it. How do I proceed