Parse Delimited
Hi,
I am using a Parse-Delimited rule to parse a .csv file. In the "Parsing Details" section of the rule form, I have made some fields as required by checking the "Required" checkbox. However, even if the values for some of the required fileds are not provided in the file, I do not see any error while Parsing the document. Is there any way to enforce required field validation and throw error if the fields marked required are NULL or empty in the input file?
I didn't hear back from anyone. But, found a workaround - create an explicit Validate rule on the propperties you want to validate and enforce 'Required' validation there. In case if you have a better way to deal with this in the 'Parse-Delimited' rule itself, please let me know.
Hello Indrajith,
While using parse delimited rule I am able to parse only the first record. How to parse all the records in the csv. Any setting that I missed?
Hi Karran, I don't think of any extra settings at this point. Make sure you have set the record terminator property to \r\n in the 'Method' tab of Service File. You can refer to this link for detailed info on parsing csv file - https://pdn.pega.com/integration/how-to-parse-a-comma-separated-values-csv-file-using-a-file-service
Hello Indrajith,
Requirement is not to have a file service rule.
Hi Karran
Change the setting in PROCESSING METHOD to build value list in PARSE-DELIMITED Rule.
So that you can parse all the values.
Hello,
Thank you for your query. This has been passed to the appropriate Support Team members. Someone will contact you.
Regards,
Andrew Fontenelle
PDN Support Team