Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
How can we read dynamic CSV file using stage file activity in ICS — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can we read dynamic CSV file using stage file activity in ICS

Received Response
19
Views
1
Comments
edited Dec 1, 2020 7:49AM in Integration 1 comment

Summary

The CSV file we receive from application can be dynamic as few columns may be missing. How to read this file correctly.

Content

Even if few columns are missing in CSV it does read the file but file data is getting manipulated. Attached below sample as how it is reading file data incorrectly.

After deleting VendorCode4 and VendorCode5 from file attachment which is uploaded and received by ICS.

The file read response from ICS is incorrect.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!