Use pipe ( | ) as CSV delimiter

Documents
1

Hi,

Is there an option to use pipe (|) as CSV delimiter. I try to enter it as custom value but get error while saving.

thank you

2

Hi @vturovsky,

I tried to enter the custom value as well and was able to do it without errors. Could you retry it and share with me the error screenshot, please?

Best regards,
Petr Bushuev
Plumsail team

3

Hi Petr,

sure, here's the error I get:

Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'request' validation failed in workflow operation 'Parse_CSV': The API operation 'FlowV1DocumentsJobsParseCsvPost' requires the property 'request/delimiter' to be set to one of its defined enum values '["Comma","Semicolon","Tab"]' but is set to '|'.'.

image
image1632×730 29.7 KB

4

Hi @vturovsky,

Yes,, there seems to be an issue with the custom value. We'll research it and reply. Thanks for waiting!

Best regards,
Petr Bushuev
Plumsail team

5

Hi @vturovsky,

We released a fix for the issue. The pipe delimiter is available in the custom documents connector

image

Please check out how to add the custom connector to your flow here.

Best Regards,
Petr Bushuev
Plumsail team