fcc to proxy interface

[former_member327037]

Hi,

Scenario FCC to Proxy asynchronous:

My Fcc is having the fields(~ seperated .csv file)

TTHY~31396567~463499~~Pegasystems Software Limited Sp z.o.o~PORTMAN TRAVEL (IRELAND) LTD~08-OCT-17~24067499~Radoslaw~Nowak~RFPPEGAC01~CGT~~~

Total 15 fields

My FCC Configuration

Scenario is successful but getting , for the last field but it should be empty.

Please tell the settings required in FCC content conversion.

[former_member190293]

Hi Sai!

Please provide the complete contents of your source .csv file.

By the way, I see that the record in FCC is named "RateDetails", but in payload it's named "RateDetailsECC". Didn't you provided us payload after mapping where, for example, value is concatenated using comma as separator?

Regards, Evgeniy.

[former_member327037]

FCC RateDetails is for sender and RateDetailsECC is for Receiver.

[former_member190293]

As I've already said, don't you have any concatenating logic for that field in message mapping?

Does comma exist in source structure right after FCC?

Regards, Evgeniy.

[former_member327037]

Hi Eve,

Please find one record in SAP PI after mapping.This is just simple one to one mapping and sharing payload for after mapping step

i can see comma in payload and for before mapping step as well

There is no comma present in .csv file. img is added for reference no comma is present at the end.

Total 15 fields from FCC to Proxy.

[apu_das2]

Please share a sample file. Looking into your FCC, it should not provide some other value like comma if it is not there in the last field.

Share the csv file for which you are gerring this issue after FCC.

Thanks,
Apu

[Ryan-Crosby]

Hi Sai,

I can't tell with certainty because you have blocked it with blue color but it looks like you have violated the following constraint (highlighted in yellow) with your RateDetails.fieldNames configuration:

Regards,

Ryan Crosby

[former_member186851]

Even if comma is generated after FCC why don't you ignore the field in the mapping so that it wont be generated in the target proxy.

[former_member327037]

Some times that field will come raghuram.

[former_member186851]

Sai please post the actual file as Eve suggested .Is the comma ter in the actual file as well?

Even if comma is ter you can use if then without else to pass the value its not equals to comma.

[former_member186851]

some condition like below.

[former_member327037]

Hi Raghu,

I think above configuration works but needs to know why comma is coming raghuram.

[former_member186851]

Hello Sai,

Please share the file,Could be because of , present in the file.

Share the complete file and FCC parameters.

[former_member327037]

file.pngHi Raghu,

It is not possible to add csv file i am adding the image file.

[former_member186851]

Seems Weird, The input XML itself having this comma?

Only one thing I can notice is there are only 14 fields in the file whereas 15 fields are mentioned in FCC anyways add additional fields should take care of this.

Comma is generated everytime or for particular records?